I was hoping you could help me with the following questions:
1) Is it possible to link a table to two data sources, namely MySQL and GravityForms? (i.e. have some columns display from MySQL, and other columns display from GravityForms?)
2) Is it possible to have MySQL linked as the data source, but have a GravityForms form (i.e. a 5-star user-rating form) displayed in one of the columns (so that the user can submit a rating)?
3) Where I am using GravityForms as the data source, is it possible to use conditional logic to determine what GravityForms data to display in each column?
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features. Tables can be created only from one data source.
2. Gravity Forms based tables don't have Foreign Key functionality, so that can't be used, and due to 1. you can't combine two different sources.
3. You can use conditional formatting, yes, but if you choose to hide a row with some custom CSS, that row will still be present on the page, only not visible. So, if you hide first 20 rows, you will have 2 blank pages in the table.
1. In that case, would a solution be to consolidate the relevant GravityForms data and other MySQL data into a single MySQL database and then link my table to that MySQL database?
I suppose that could work, yes. If you can pull the data you need from the table, and the form into a single database (or database table), you would be able to do that.
Hi,
I was hoping you could help me with the following questions:
1) Is it possible to link a table to two data sources, namely MySQL and GravityForms? (i.e. have some columns display from MySQL, and other columns display from GravityForms?)
2) Is it possible to have MySQL linked as the data source, but have a GravityForms form (i.e. a 5-star user-rating form) displayed in one of the columns (so that the user can submit a rating)?
3) Where I am using GravityForms as the data source, is it possible to use conditional logic to determine what GravityForms data to display in each column?
Thanks in advance for your time and help!
Paul
Hello Paul
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features. Tables can be created only from one data source.
2. Gravity Forms based tables don't have Foreign Key functionality, so that can't be used, and due to 1. you can't combine two different sources.
3. You can use conditional formatting, yes, but if you choose to hide a row with some custom CSS, that row will still be present on the page, only not visible. So, if you hide first 20 rows, you will have 2 blank pages in the table.
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
Hi Aleksandar,
Thanks for your reply.
1. In that case, would a solution be to consolidate the relevant GravityForms data and other MySQL data into a single MySQL database and then link my table to that MySQL database?
Thanks,
Paul
Hi again Paul
I suppose that could work, yes. If you can pull the data you need from the table, and the form into a single database (or database table), you would be able to do that.
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
Hi Aleksandar, thank you for your help.
You're welcome Paul
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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