You can, using an additional plugin. I use Shortcode Exec PHP. Then you would write a little custom PHP code that you can call using the shortcode for this additional plugin. Below is a simple example of the code used. Basically, just do a count off the specific form table. You can make a more complicated query as needed. In teh sample below, “4” would be your site ID (there’s a plugin for that, too if you need). “65” is the default form number/name when you first create the form (which you may have renamed later). If you re-named it, you can find out the number by going to your form, then in the URL, you will see “id=65” at the end. That last number is your form number. So, in my case below, the site number (I’m using multisite) is 4, and the form id is 65.
global $wpdb;
// First Choice Column
$submission_count = $wpdb->get_var( "SELECT COUNT(*) FROM wp_4_fm_data_65 " );
echo $submission_count;
Hi Manakuke,
TNX!! It worked great!!
I wasn’t familiar with this plugin.
It’s pretty cool, but simple. Nice way to tweak or add something via PHP/MSYQL without needing to write a full blown plugin. I’ve also used it to dynamically pull in content from one multsite site into another. Something the current WordPress doesn’t do out of the box.
