Google Sheets filters not reading operators or values

[ModesofLiving]

Checklist

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

*Similar issues
Closed bug: #8557
Merged pull request: #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.

[linear]

BUDI-8266 Google Sheets filters not reading values

[JohnM053]

I have encountered the exact same problem. It worked fine when I accessed my app a week or two ago, now filters like "is empty" or "not equals" are not working anymore. It's a huge problem, I hope we can solve that soon. Thanks!

[danrenfroe2016]

Same Problem here. simple filters on the data provider always show no rows found. The other functions of my app appear to work fine.