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?
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.
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.
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.
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