As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I want to create a website that can display tables and charts from my Google Sheets files. Some of these Sheets files are live/updating with functions, like "importhtml". Will WpDataTables update/refresh at the same time as Sheets? Also, do I need to have Wordpress and/or Sheets open and running on my end for the update/refresh to be viewable for my website visitors?
Hello Rowson
Thank you for your interest in wpDataTables.
Formulas and formatting are not carried over from any external source, so they can't be used. You can create separate Formula Columns in wpDataTables, if the data is being calculated from within the table.
I can't guarantee that functions like IMPORTHTML will work.
Also, the spreadsheet needs to be published to the web, so the plugin doesn't need the file to be active. You only need to provide the correct URL for the Spreadsheet generation.
You can read more about these tables in our documentation.
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
Thanks for the reply, Aleksandar. I am still hopeful that what I'm attempting to do can be accomplished by your plugin. If I create a sheet with a formula, like "importhtml", and publish it to the web. That published URL should be updating the data periodically. Your plugin may not be able to pull the formula from this published sheet, but it should still pull the refreshing nominal values, correct?
Thank you for your time and patience with my questions.
Hi again Rowson
That sounds right, yes. If you do need to use formulas in your Google Spreadsheet, you should create another sheet that will use IMPORTRANGE function to pull the data from your original sheet. You can read more about this here.
That new sheet will only pull the values, so wpDataTables will have no issues with formulas from the original sheet, and would be able to pull dynamic values from the second sheet.
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