Posted 1 year ago #
Is there anyway to write the fields from the Contact Form 7 form into a spreadsheet file? In addition to sending an email, I would like a "database" of all the entered material in a spreadsheet. This would mean, of course, that the spreadsheet would need to be updated -- not replaced -- with every new entry.
Thank you. (I did look for this in the forums, but must have missed the answer. Sorry if it was covered.)
Posted 1 year ago #
Install this extension on your wordpress site.
http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/
Then you can visit the plugin page, and activate it "Contact Form 7 to DB Extension". There is a settings link there on the same plugin activation page.
It logs all the fields into a mysql database table.
On the same plugins page in WP, it will has a link beside "Contact Form 7 to DB Extension" which says "Data"
That link shows all the data/information submitted in your forms from wordpress.
From the data page you can then export to Excel, see the rows, delete the rows, etc.
In Excel (I used verison 2010) it will open, and prompt you to Enable (security warning) then you can type your wordpress username and password. You can click the data tab hit the Refresh button and it will dynamically query that mysql table using the login and password you saved. Save the Excel file on your computer documents, and just open the Excel file in the future and do the data tab > refresh (F5) to get updated data from the WordPress server.
This topic has been closed to new replies.
