Good day, I'm planning on having a lot of tables imported from Google Sheets. The problem is that, according to this article (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/), it will not be updated automatically on page load when certain changes are present at the source table. So, my question is if there's a way to update the tables automatically, let's say every few hours. I understand that the functionality that I'm asking for is currently not in the plugin, but is there a WAY to do this? Maybe there is a hook I can hook into?
You don't need to hit "Save changes" every time for the table data to refresh. It is automatically refreshed, but with a delay. So, if you add a row in the Google Spreadsheet file all you need to do to see the change is to refresh the page where the table is (on back-end, or front-end, regardless).
If you need the page to remain active, without refreshing it manually, you would need to perform a meta refresh on a page after a certain time.
Could you please tell me how to disable scrolltop on thead click (when you sort tables on front-end)? I've been searching with Notepad++ in wpdatatables directory for 30 minutes but no luck. Where is the piece of code located?
Good day,
I'm planning on having a lot of tables imported from Google Sheets. The problem is that, according to this article (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/), it will not be updated automatically on page load when certain changes are present at the source table.
So, my question is if there's a way to update the tables automatically, let's say every few hours. I understand that the functionality that I'm asking for is currently not in the plugin, but is there a WAY to do this? Maybe there is a hook I can hook into?
All I need is basically hit "Save Changes" button on each table every few hours
Hello Andrey
Thank you for your interest in the plugin.
You don't need to hit "Save changes" every time for the table data to refresh. It is automatically refreshed, but with a delay. So, if you add a row in the Google Spreadsheet file all you need to do to see the change is to refresh the page where the table is (on back-end, or front-end, regardless).
If you need the page to remain active, without refreshing it manually, you would need to perform a meta refresh on a page after a certain time.
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
Thank you for your reply, Aleksandar.
That's good news but still, if I were to add a new column it will not update it automatically, right?
If you add a new column, Andrey, the table will break.
As per our documentation, adding, renaming, deleting or reordering of columns in the source file will cause the table to break.
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
Could you please tell me how to disable scrolltop on thead click (when you sort tables on front-end)?
I've been searching with Notepad++ in wpdatatables directory for 30 minutes but no luck.
Where is the piece of code located?
Hello Andrey
Why go through the code when you can disable sorting for individual columns:
Or for the whole table, in the Sorting and Filtering tab above 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