I have some tables in our Google Sheets and a lot of formula and processing. I need these tables to be on our wordpress website https://ifooty.net ... But these are interactive: Whenever a visitor to the website chooses a match/line, the selections should be sent to the google sheets, be processed and results be shown back on the website again.
Unfortunately this cannot be achieved using the plugin's builtin features.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
What you can do with wpDT is to create a table from the google spreadsheet (remove all formatting and formulas from the source file first; if you are going to use a Google Spreadsheet with formulas, please follow this – Tutorial) and recreate the sheet within wpDT. You can add filters if you need to further refine the results.
Thank you for your reply. What if I have 2 different tables in wpdatatables. When I click on 1 cell in table 1, then some data from table should be shown. How can I do this?
You are most welcome, I wish I could be more helpful. Unfortunately it is not possible to make dependent columns with wpDataTables. The only way to modify what the table displays is by using filters.
Hello
I have some tables in our Google Sheets and a lot of formula and processing. I need these tables to be on our wordpress website https://ifooty.net ... But these are interactive: Whenever a visitor to the website chooses a match/line, the selections should be sent to the google sheets, be processed and results be shown back on the website again.
Is your plugin capable of doing this?
Regards
Edwin Dee
ifooty.net
Hi Edwin
Thank you for reaching out to us.
Unfortunately this cannot be achieved using the plugin's builtin features.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
What you can do with wpDT is to create a table from the google spreadsheet (remove all formatting and formulas from the source file first; if you are going to use a Google Spreadsheet with formulas, please follow this – Tutorial) and recreate the sheet within wpDT. You can add filters if you need to further refine the results.
Thank you for your reply. What if I have 2 different tables in wpdatatables. When I click on 1 cell in table 1, then some data from table should be shown. How can I do this?
You are most welcome, I wish I could be more helpful. Unfortunately it is not possible to make dependent columns with wpDataTables. The only way to modify what the table displays is by using filters.