[Plugin: Contact Form 7 to Database Extension] Retreieve data to display on pages

As of version 1.2.1: In wp-admin, go to “Contact” -> “Database”.

See this screenshot

I’m not sure, but I think the original poster was asking how to call the data from the plugin database to display on a site page for public view.

Can this be done with any type of shortcode? If not, this would be a great future feature for your plugin, which is awesome, btw. ??

I was asking about displaying the data on a page, like smallwebsolutions suggests. I would LOVE this as a feature!

I misunderstood. The answer is ‘no’ as of right now (version 1.4.1). But that is one of the things already on my list to look into. I have to figure out how shortcode stuff works, and if it is not too hard, I’ll put it in sooner rather than later.

I was able to code up something to support this fairly quickly. I added a shortcode. Examples of what to paste in your post/page:

[cf7db-table form="your-form" ]

To anticipate your next request:
[cf7db-table form="your-form" show="field1,field2,field3"] (optionally show selected fields)

[cf7db-table form=”your-form” hide=”field1,field2,field3″] (optionally hide selected fields)

[cf7db-table form="your-form" show="f1,f2,f3" hide="f1"] (hide trumps show, f1 not shown)

I marked this as version 1.4.2. It is not the “stable version” yet. I would like you to try it out and report back to me on how it works for you.

You will have to manually update the plugin by downloading Version 1.4.2 and unzipping the contents in your host’s wp-content/plugins/ directory (overwriting the contact-form-7-db subdirectory).

NOTE: users will need to have permission to view the form data. To let anyone viewing your page to see the data, in admin go to Contact -> Database Options and set ‘Can See Submission data’ to ‘Anyone’

Hi mr Simpson,
really glad to be using your plugin to add my users to the database. I too will populate a published page with that data. I have a question though. In the table of contact 7 database … the field EMAIL is the only one i see that i can cross check with the logged in user. I have a family tree and a whole lot of pages,,, one for each member of the family. What I would like to do is to be able to populate ONE page based on their login detail. In WP users area we have nickname and email. The email i would like to cross ref to the one in the table you created for contact 7. I wonder if I should base the data on login session (one page only) or have a page for each member in the event that they might want to add more data not on the database… will keep you informed.
here is the site to see if you desire https://www.thenewmanclan.com

Hi again I tried the following text (bold) but couldn′t get any info to show up…. could you make a FOR DUMMIES explanation. Sorry for the bother

Server: localhost
Database: kiwichap_wrd6
Table: wp_CF7DBPlugin_SUBMITS

what i tested
[cf7db-table form=”contact-form-2″ show=”submit_time,field_value”]

Be sure you have the latest version (currently 1.4.3) installed.

When you create a post or page in the WP editor and insert the text you have in bold above, that should do the trick (assuming you have data in the form, and spelled the form name and columns right…)

Try first just:
[cf7db-table form="contact-form-2" ]
and if that works, add the “show” part.

Hi Mr Simpson,
I solved the riddle. If one goes to contact 7 tool and checks the forms created, there is code to see to insert forms.

Here is an example (bold)
[contact-form 2 "Registration Form"]

I was using the name “contact-form-2” when I should have been using the name “Registration Form”

So here is my working example
[cf7db-table form=”Registration Form” show=”your-name,your-email”]

Next question… can I create a layout without the table?
meaning putting the values on the page in a way that looks like the actual form that was filled out.

Thanks again for your assistance

No layout support as yet.