Hi there, your app looks amazing. Before purchasing, I wanted to inquire about the Google spreadsheet import function. If I import a table from a Google spreadsheet, will it automatically update if the original spreadsheet is updated?
Yes, of course - if you update the Google Spreadsheet the table was created from it will update that table. There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTables.
Also, the data is read from the data source every time the page loads, so when your tables are large (more than 2000-3000 cells) this source won’t be the right choice since the page with large tables will load slow, or even crash after reaching a certain size.
Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:
Changing the column’s name,
Changing the column’s order,
Deleting the column, and
Adding a new column.
are highly not recommended, because the old table will not work, at the moment. If you make any of these changes, please recreate the table again.
Please let me know if you have any more questions.
I believe this question should be turned to the hosting provider
Every table sends out an admin-ajax call, and while I have encountered users that have a lot of tables on the same page, the more tables you put there - the more time it will take to load the page.
If the tables are small, like you said, I believe we're talking about a few seconds. For example, I just created a page with 20 tables, and it took 9 seconds for it to load. Like I said, it varies on the server and hosting provider. I am on a local network, and without any additional plugins active, so that can also impact the speed.
Hi there, your app looks amazing. Before purchasing, I wanted to inquire about the Google spreadsheet import function. If I import a table from a Google spreadsheet, will it automatically update if the original spreadsheet is updated?
Thanks,
Craig
Hello Craig.
Thank you for your interest in our plugin.
Yes, of course - if you update the Google Spreadsheet the table was created from it will update that table. There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTables.
Also, the data is read from the data source every time the page loads, so when your tables are large (more than 2000-3000 cells) this source won’t be the right choice since the page with large tables will load slow, or even crash after reaching a certain size.
Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:
are highly not recommended, because the old table will not work, at the moment. If you make any of these changes, please recreate the table again.
Please let me know if you have any more questions.
Best regards.
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
Aleksander,
Thanks for your prompt reply. This is excellent.
My tables are small, with the largest one having 170 cells. However, I intend on having upwards of 30 tables on the same page, will that be an issue?
Thanks,
Craig
Hi Craig.
I believe this question should be turned to the hosting provider
Every table sends out an admin-ajax call, and while I have encountered users that have a lot of tables on the same page, the more tables you put there - the more time it will take to load the page.
If the tables are small, like you said, I believe we're talking about a few seconds. For example, I just created a page with 20 tables, and it took 9 seconds for it to load. Like I said, it varies on the server and hosting provider. I am on a local network, and without any additional plugins active, so that can also impact the speed.
Best regards.
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