search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.78k stars 1.49k forks source link

Google Sheets filters not reading operators or values #13720

Open ModesofLiving opened 3 months ago

ModesofLiving commented 3 months ago

Checklist

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

Hosting

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):

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[bot] commented 3 months ago

BUDI-8266 Google Sheets filters not reading values

JohnM053 commented 3 months ago

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 commented 3 months ago

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

tclifton-chess commented 2 months ago

I am having the same issue with trying to filter based on text. This is a huge issue that makes the sheets integration useless.

robstevens7182 commented 1 month ago

Is this something that is being addressed? It is kind of a big problem for us.