I need to reload my data tables from time to time without reloading the whole page. I created a table using "Create a data table linked to an existing data source" option. Then I tried to insert the short code inside a div and reloading the same with jquery. But that is reloading the data table without its stylesheet. How can I reload the data table say every 15 minutes with its style sheet without reloading the whole page.
- Auto-refresh feature for the tables, using the built-in functionality of our plugin is only possible if you create server-side enabled tables, such as a manual table, or a server-side SQL query-based table. This option will appear on the "Data source" tab above the table.
You can add the interval (in seconds) after which the table will refresh itself, thus displaying any changes that happened in that time period.
- For tables linked to a data source, you will not be able to enable server-side processing, and this requires a custom JQuery solution.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future...
but, one of our users came up with a workaround, you can try his solution :
"Create a filter. Make sure that you choose "above the table". it is because we'll need the filter id for this trick.
jQuery("#filterBox_table_5").hide(); //if you don't want to see this filter, check your table id and use it here.
jQuery("input[placeholder='YOUR FIELD NAME']").trigger('keyup'); // this refresh your table. Call this jQuery line each time you want to refresh it. "
- Hopefully, that helps.
- Maybe I didn't understand exactly what you need. If that is the case, apologies.
I can see on the related page, you have a Google Spreadsheet linked table.
For Google Spreadsheets, when you modify or add new rows, the plugin will show those changes within 15 minutes (since there's cache on Google's side). If you don't want to face any issues with cache, you can use the Google Sheets API method.
If you require further assistance, please contact us again.
I need to reload my data tables from time to time without reloading the whole page. I created a table using "Create a data table linked to an existing data source" option. Then I tried to insert the short code inside a div and reloading the same with jquery. But that is reloading the data table without its stylesheet. How can I reload the data table say every 15 minutes with its style sheet without reloading the whole page.
Hi, Indrajit Mukherjee
Thanks for reaching out to us.
- Auto-refresh feature for the tables, using the built-in functionality of our plugin is only possible if you create server-side enabled tables, such as a manual table, or a server-side SQL query-based table. This option will appear on the "Data source" tab above the table.
You can add the interval (in seconds) after which the table will refresh itself, thus displaying any changes that happened in that time period.
- For tables linked to a data source, you will not be able to enable server-side processing, and this requires a custom JQuery solution.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future...
but, one of our users came up with a workaround, you can try his solution :
"Create a filter. Make sure that you choose "above the table". it is because we'll need the filter id for this trick.
jQuery("#filterBox_table_5").hide(); //if you don't want to see this filter, check your table id and use it here. jQuery("input[placeholder='YOUR FIELD NAME']").trigger('keyup'); // this refresh your table. Call this jQuery line each time you want to refresh it. "
- Hopefully, that helps.
- Maybe I didn't understand exactly what you need. If that is the case, apologies.
I can see on the related page, you have a Google Spreadsheet linked table.
For Google Spreadsheets, when you modify or add new rows, the plugin will show those changes within 15 minutes (since there's cache on Google's side). If you don't want to face any issues with cache, you can use the Google Sheets API method.
If you require further assistance, please contact us again.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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