Shortcode for form count returns '0'

If you change the short code to cfdb-table doe it show results?

Yes.
Could it possibly be that the short code doesn’t like the date in the form title? The form that works with cfdb-count doesn’t have a date in the title — 5 others that do have dates do not work. Just a thought…

This code works beautifully:

[cfdb-table form="Registration - Multi-disciplinary Team Based Models - Oct. 7, 2015" show="First-Name,Last-Name,Organization,TitlePosition,from_email,Phone,sector,Other-Sector,trained-as-Community-Health-Worker,trained-as-a-Community-Paramedic,Community-Health-Workers,Community-Paramedics,Dietary-Needs,Accessibility-Needs,learning-teams,Signature,Date" role="Editor" permissionmsg="true" headers="First-Name=First,Last-Name=Last,Organization=Org,TitlePosition=Title,from_email=Email,Phone=Phone,sector=Sector,Other-Sector=Sector,trained-as-Community-Health-Worker=CHW Trained,trained-as-a-Community-Paramedic=CP Trained,Community-Health-Workers=Org has CHWs,Community-Paramedics=Org has CPs,Dietary-Needs=Diet,Accessibility-Needs=Access,learning-teams=Teams,Signature=Sig,Date=Date"]

I think there is a bug. Probably due to the comma in the form name. Can you change the name of the form?

Thought it might be something like that. Yes, I can change form names, though with first try it looks like FS Contact Form changes the displayed title but not the database title, so will need to edit the database, unless you know of another route. I’d make new forms & duplicate settings, but there are already numerous entries being recorded in the current ones. Will let you know if changing names does the trick. Thank you!

You can change the form name via PHPMyAdmin.

Assuming your new form name is “Multi-disciplinary Team Based Models – Oct. 7 2015”

Execute SQL:

update wp_cf7dbplugin_submits
set
form_name = 'Multi-disciplinary Team Based Models - Oct. 7 2015'
where
form_name = 'Multi-disciplinary Team Based Models - Oct. 7, 2015'

Thanks!! That worked great for changing the form names and now the submissions & count for the newly named forms are displaying properly from the shortcodes.

This brings up another question, then:
Submissions to the forms with the original names now live in a separate list in the CFDB admin (so, for example — the form with the new name displays 1 record; the form with the old name shows 6 submissions). Is there a way to merge the two sets form submissions from CFDB admin, or should I do it with PHPAdmin?

I thought that is what we are doing. Use the query to change the old form name to the new form name so that old and new submissions appear under the same title.

If your new form has a different title, use the query again, changing the form_name values as desired.

Got it! Thanks!!

Okay, one final question… is there a way to avoid duplicate submissions, testing for email address?

I have an example of this for Contact Form 7 so that it gives an error on the submission page to the user. But I don’t have an example for FSCF. You would have to ask on the FSCF forum if there is a hook for data validation then code something similar.

Great! I can work with that. Thank you!