budibase
budibase copied to clipboard
Google Sheets filters not reading operators or values
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:
- Go to Data > Sheet > Table (or App > Data Provider)
- Click on Filter > Add Filter (operator or value)
- Scroll down to 'N/A'
- 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.