If I understand you right you should check out Gravity form support to checkout how to do that.
What is possible in our plugin is to create tables from Gravity forms data with wpDataTables and our Gravity integration add-on. You can read more about this here. It will not be created new table in database, we are using synchronization with Gravity tables in database for CRUD(Insert, Update or delete entries)
Thanks for your response. I viewed the videos and have a question to see if I can use wpDataTables:
Can I access the data in the table created from the plugin so I can process that data in my program without user intervention? I can't see how just viewing or editing it on a web page could possibly do that.
However, if it were to put the data in a .csv file which I could access, or a table in a MySQL database on my host (Hostgator), that would be great.
Steve
Background: My current website (non-WordPress) does that but I don't have the source for it. Its shortcomings require a rebuild. I program in Visual Foxpro, but my php/html knowledge is limited so I'm trying WordPress with Gravity Forms, hoping to "capture" the data entered.
Gravity Forms (along with all other form plugins) store data in multiple tables as serialized arrays. Pulling that data into wpDataTables is done with an SQL query that runs in the background, and is generated programmatically.
This means that wpDataTables is not storing the data in the database or anywhere else, but is just displaying the data from Gravity Forms' entries in a wpDataTable.
Thank you Aleksandar, for explaining how that works. My next question is where does that wpData Table lie? And is it possible to access the table (or the data IN the table) from my Windows PC, particularly from my Foxpro program?
The table's structure exists in wp_wpdatatables_columns database table, where only the configuration of columns and options are stored. The data itself is still in Gravity's database tables, and it's being pulled into wpDataTables using a programmatically created MySQL query.
Unfortunately, you can't see the query nor the actual data anywhere else other than in the wpDataTable.
The Submit button on my Gravity Forms form sends the data input on that form to my by email.
What do I need and how can I also send that data to a table I can create in my existing database (MySQL on Hostgator)?
Hi Steve,
Thank you for your interest in wpDataTables.
If I understand you right you should check out Gravity form support to checkout how to do that.
What is possible in our plugin is to create tables from Gravity forms data with wpDataTables and our Gravity integration add-on. You can read more about this here. It will not be created new table in database, we are using synchronization with Gravity tables in database for CRUD(Insert, Update or delete entries)
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
Thanks for your response. I viewed the videos and have a question to see if I can use wpDataTables:
Can I access the data in the table created from the plugin so I can process that data in my program without user intervention? I can't see how just viewing or editing it on a web page could possibly do that.
However, if it were to put the data in a .csv file which I could access, or a table in a MySQL database on my host (Hostgator), that would be great.
Steve
Background: My current website (non-WordPress) does that but I don't have the source for it. Its shortcomings require a rebuild. I program in Visual Foxpro, but my php/html knowledge is limited so I'm trying WordPress with Gravity Forms, hoping to "capture" the data entered.
Hello Steve
Gravity Forms (along with all other form plugins) store data in multiple tables as serialized arrays. Pulling that data into wpDataTables is done with an SQL query that runs in the background, and is generated programmatically.
This means that wpDataTables is not storing the data in the database or anywhere else, but is just displaying the data from Gravity Forms' entries in a wpDataTable.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you Aleksandar, for explaining how that works. My next question is where does that wpData Table lie? And is it possible to access the table (or the data IN the table) from my Windows PC, particularly from my Foxpro program?
Steve
Hi again Steve
The table's structure exists in wp_wpdatatables_columns database table, where only the configuration of columns and options are stored. The data itself is still in Gravity's database tables, and it's being pulled into wpDataTables using a programmatically created MySQL query.
Unfortunately, you can't see the query nor the actual data anywhere else other than in the wpDataTable.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables