I'm about to take on a new project that will require a fairly large entry form.
After adding new entries, I'd like a few select columns to be displayed in a wpDataTables table, however, I'd like to be able to edit all fields from the wpDataTables table. Now I'm fairly certain this can be achieved using Gravity Forms Integration, but my question is more related to how the data is stored.
If I'd like to export the database from phpMyAdmin to a CSV format, would all the entries be located in a wpDataTables MySQL table or a Gravity Forms table? Or would they be split according to where the entry was made i.e. entries added using the Gravity Form would be in the Gravity Forms table and entries added using the wpDataTables New Entry button would be located in a wpDataTables MySQL table?
I appreciate your response, although I'm now more confused as to best the setup for my use case. I've tried to explain my ideal working scenario below, if you're able to offer any more advice?
Ideally, I would like to use wpDataTables functionality (including placeholders / variables etc.), however, use Gravity Forms to create the large entry form.
Would it be possible to use Gravity Forms to create the entry form and table to store the data inputted, and then create a table using wpDataTables SQL Query Selecting * from the Gravity Forms Table. With this table, I'd then like the Gravity Form modal to pop up when adding a new entry.
I hope that makes sense and would really appreciate any assistance
Like I said in my previous response, wpDataTable doesn't actually save the data in the database, and it's only pulling it from several Gravity Forms tables.
There is no wpDataTable stored in the database, so you can't use that.
You can create a table linked to the form, enable Server-Side processing, and you would be able to edit the table, and add new entries.
I see. Am I correct in assuming that if I proceed with that setup, I won't be able to utilise all the features wpDataTables has to offer, such as the placeholders and variables?
In that case, could I use the plugin you mentioned earlier to create a new table that stores the inputted form entries. My thinking would then be to create a wpDataTable using a SQL query, Selecting all fields from the new form table, allowing full wpDataTable functionality?
If that would all work, what would happen when pressing "New Entry" or "Edit" on my wpDataTable? Would it still present the Gravity Form in the modal?
If not, could I instead embed a Gravity Form to process new entries and then disable the "New Entry" on my wpDataTable and only add new ones using the embedded form? On the other hand, I imagine I will be unable to "Edit" my existing entries?
This is proving to be lot more complicated than I initially thought 😥 I didn't even think I needed a third party plugin as all I essentially wanted was to customise the wpDataTable entry form to handle a lot fields presented under different sections 🥺
You're assuming correctly - the integration add-on will not be able to do this.
If you were to install the Gravity WPDB plugin, you would be able to create a simple wpDataTable using SQL query:
SELECT * FROM thatNewTable
The modal from Gravity would not work, but you would be able to disable editing from front-end, so people can still use Gravity's entry form. The data should automatically be stored in that new table generated by the other plugin, so wpDataTables would just be refreshed when the page is refreshed.
Hiya,
I'm about to take on a new project that will require a fairly large entry form.
After adding new entries, I'd like a few select columns to be displayed in a wpDataTables table, however, I'd like to be able to edit all fields from the wpDataTables table. Now I'm fairly certain this can be achieved using Gravity Forms Integration, but my question is more related to how the data is stored.
If I'd like to export the database from phpMyAdmin to a CSV format, would all the entries be located in a wpDataTables MySQL table or a Gravity Forms table? Or would they be split according to where the entry was made i.e. entries added using the Gravity Form would be in the Gravity Forms table and entries added using the wpDataTables New Entry button would be located in a wpDataTables MySQL table?
Appreciate any assistance :)
Y
Thanks Aleksandar!
I appreciate your response, although I'm now more confused as to best the setup for my use case. I've tried to explain my ideal working scenario below, if you're able to offer any more advice?
Ideally, I would like to use wpDataTables functionality (including placeholders / variables etc.), however, use Gravity Forms to create the large entry form.
Would it be possible to use Gravity Forms to create the entry form and table to store the data inputted, and then create a table using wpDataTables SQL Query Selecting * from the Gravity Forms Table. With this table, I'd then like the Gravity Form modal to pop up when adding a new entry.
I hope that makes sense and would really appreciate any assistance
Hello again Yuveer
Like I said in my previous response, wpDataTable doesn't actually save the data in the database, and it's only pulling it from several Gravity Forms tables.
There is no wpDataTable stored in the database, so you can't use that.
You can create a table linked to the form, enable Server-Side processing, and you would be able to edit the table, and add new entries.
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
I see. Am I correct in assuming that if I proceed with that setup, I won't be able to utilise all the features wpDataTables has to offer, such as the placeholders and variables?
In that case, could I use the plugin you mentioned earlier to create a new table that stores the inputted form entries. My thinking would then be to create a wpDataTable using a SQL query, Selecting all fields from the new form table, allowing full wpDataTable functionality?
If that would all work, what would happen when pressing "New Entry" or "Edit" on my wpDataTable? Would it still present the Gravity Form in the modal?
If not, could I instead embed a Gravity Form to process new entries and then disable the "New Entry" on my wpDataTable and only add new ones using the embedded form? On the other hand, I imagine I will be unable to "Edit" my existing entries?
This is proving to be lot more complicated than I initially thought 😥 I didn't even think I needed a third party plugin as all I essentially wanted was to customise the wpDataTable entry form to handle a lot fields presented under different sections 🥺
Hi again Yuveer
You're assuming correctly - the integration add-on will not be able to do this.
If you were to install the Gravity WPDB plugin, you would be able to create a simple wpDataTable using SQL query:
SELECT * FROM thatNewTable
The modal from Gravity would not work, but you would be able to disable editing from front-end, so people can still use Gravity's entry form. The data should automatically be stored in that new table generated by the other plugin, so wpDataTables would just be refreshed when the page is refreshed.
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