As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I have some tables that are created dynamically from a Google Sheets source. That have been working fine on and off, but recently I started getting essentially empty tables displaying. They show sometimes just one record in the table with field values such as "#N/A" and "#NAME?" which are Google Sheets error messages.
However, when I load the published Google Sheet (in an incognito tab), I see all of the correct values without these errors.
I am wondering if there might be a timeout configured? When a pageview tries to hit the Google Sheet for its values, does the plugin timeout if it takes too long to load? If so, is there a way to adjust this timeout?
I am implementing caching so a fresh page view to hit the Google Sheet will only actually happen once a day, so I am fine if the timeout is long to ensure that the data is captured correctly from the Google Sheet.
Thanks!
A few other notes. The published Google Sheet is here. I have tried creating a new data table in WordPress, and it results in the same errors. This table and sheet combo used to work, but since I have added more data to the sheet, now the table does not work (shows previously mentioned errors).
Thanks!
This seems to be a Google Sheets bug and not a wpDataTables bug. I have been able to see the erroneous results on my published Google Sheet directly, so I understand why wpDataTables is displaying it. Will try to debug through Google support. Thanks.