My mind is melting, and I’m nearly sure this is a bug but can’t be certain. A custom list of an external collection from Airtable was, until this afternoon, completely functional at allowing a user to search and find the item they were looking for, using this formula:
We have had this function operating on several custom lists on several different screens on several apps without fail for a few months now, and a few paying customers using each. We’re trying very eagerly to ensure that tomorrow morning they don’t become angry, non-paying customers. I’ve asked Adalo for help already a few hours ago when we noticed the problem. Maybe the community can help (geez I miss the Slack group).
Here’s a video of the issue in progress: Loom | Free Screen & Video Recording Software
Haven’t made any changes to the connection to the external collection, in fact we haven’t touched any part of that feature in a while (and have even copy/pasted it into other apps without any problems). The formula works fine if I hard code a search in there, it only stops functioning if I try to use the input box to filter the search using the formula above. Which again, until a few hours ago, worked just fine for months.
I checked Airtable’s API documentation to make sure nothing changed, and it didn’t (my tests in Adalo assured me of the same). It seems to all come down to the input box no longer wanting to pass text into the custom list’s formula after it’s typed in.
Interestingly enough, when I add text to the input box (which does nothing), then click to a different screen, then navigate back to the search page, the text that remains in the input box manages to filter the list properly. But then modifying the contents of the input box does nothing again (until I navigate away and come back another time).
Any ideas, folks?