We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I am running into an issue with the Auto-Cache feature. I am using Google Sheets and Google API to integrate with WPDataTables on a Bluehost WordPress site.
I have too many tables so that the burst limit is being reached when the cron job runs for the cache update to check for changes. By my math I can only run 20 tables at a time. I have tried writing some scripts manually to create something that batches 20 at a time and cycles through but so far have not found any success.
Is there any suggestions on how to be able to use the Auto Cache feature to check if any of my tables have changed but not get the Too Many Requests error (obviously without adding an expense of upgrading Google API as I am dong this as a hobby/non-profit and not a business).
Hi Kenneth,
The best/easiest way to solve this situation, is to remove the Google API key from our Plugin settings, but keep using the "Auto Update Cache" method.
This way, you will avoid having the API limit reached, and our tables will keep functioning the same way as before.
The only downside of this is, all your Google Sheets have to be published, so you can't use private ones.
That being said, nobody will be able to 'access' any of your Sheets from our tables on front-end, so in that regard, security is not an issue.
You can see more details explained and multiple methods to solve the 'too many requests' from Google API on this article.
Let me know if you have any questions.
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
ok thank you.
Do I still need to do a Cron Job for the cache to update if a change is made to the Sheet, or is that all handled in the ~15 minute refresh discussed in the article?