Google Sheets filters not reading operators or values

[ModesofLiving]

Checklist

• [x] I have searched budibase discussions and github issues to check if my issue already exists*

*Similar issues Closed bug: https://github.com/Budibase/budibase/issues/8557 Merged pull request: https://github.com/Budibase/budibase/pull/9886

Hosting

• Tenant ID: modesofliving.budibase.app

Describe the bug Filters that were working no longer were able to read or interpret any operators and/or values submitted, and consistently return "No rows found". Problem replicates on Data and In-App Data Provider filters.

To Reproduce Steps to reproduce the behavior:

1. Go to Data > Sheet > Table (or App > Data Provider)
2. Click on Filter > Add Filter (operator or value)
3. Scroll down to 'N/A'
4. See error (no data)

Expected behavior Filters read operator or value and display matching/qualifying data

Screenshots

App Export If possible - please attach an export of your budibase application for debugging/reproduction purposes.

Desktop (please complete the following information):

• OS: Windows
• Browser Firefox
• Version 125.0.3

Additional context Filters were working fine the last time I accessed my apps on 6th May 2024
Tried updating from 2.26.1 to 2.26.4 but problem persists. Other problem with Google Sheets is Field data-types all default to Text and cannot be changed.