Spreadsheet Reader Changelogs

Added offline fallback system for spreadsheet data fetching. If the Google Sheets API request fails and no fresh cache is available, the plugin will automatically serve the last successfully fetched data stored in the database. This ensures better reliability during external service downtimes.

Users can now perform a live test of the spreadsheet data by clicking a "Live Test" button. This will fetch the spreadsheet data without cache and display it in real-time, making it easier to test the integration directly on the website.

Added 'no_cache' attribute to the shortcode, allowing users to fetch data directly from the Google Sheets API without using cached data. This attribute helps ensure real-time data fetching and is especially useful for testing or situations where fresh data is required. By default, 'no_cache' is set to false, but setting it to true will bypass cache and fetch the data again from the source.

Corrected 'row_limit' and 'col_limit' behavior to properly respect the sort attribute and work consistently whether pagination (limit) is enabled or not.

Resolved PHP Warning in EDD_SL_Plugin_Updater under certain conditions.

Refined Clear Cache and Remove buttons.

Added pagination in [spreadsheet_table] shortcode.

Added support for setting a data limit in Bricks Query Loop when pulling from the spreadsheet.

Shortcode's table UI.

Editing a shortcode now automatically clears its previous cache.

Validation message on form when adding new Shortcode.

Add notification message when user has not set Google API Key.

Downgraded to SweetAlert2 v11.4.8 to avoid vulnerabilities present in newer versions.

Enhanced code security by improving input validation, sanitization, and proper escaping of user data.

Resolved a bug when clearing cache using the "Clear Cache" button in the shortcode table.

Fixed an issue where the Spreadsheet ID field did not immediately appear when enabling "Show Spreadsheet ID" in settings.

EDD_SL_Plugin_Updater to v1.9.4.

Some bugs.

Changed the AJAX name on the plugin to avoid possible conflicts.

Some typo in Shortcode usage.

Add shortcode bug.

Shortcode ID field bug.

User Interface - using Bulma CSS Library.

Some bugs.

Initial Release