Notifications
Clear all
How To
4
Posts
2
Users
0
Reactions
3
Views
Topic starter
Hi All - I'm really struggling to filter my Airtable records based on a Status column.
It would be a Christmas miracle if I could get this working today!
I've tried many different approaches, but I suspect the issue is that I don't have a reference to the returned data, making filtering impossible.
Goal: Very simple, Status is not "Done"
I have tried:
{Status}!=“Done”{Status}!=‘Done’IF({Status}!=‘Done’, true, false)- Same results with double quotes.
I've experimented with checking or mapping output fields, with and without.
Each time, I receive a RuntimeError:
[422] The formula for filtering records is invalid: Unknown field names: true
Any guidance would be greatly appreciated!
Posted : 25/12/2024 4:10 pm
Topic starter
It's great when you step away briefly and return – I used a bit of ChatGPT for this, which I initially tried.
Here's the core issue:
You only need to select the Output field you want to filter on, and the following worked for me:
Status != "Done"Make sure to include the spaces and double quotes.
Posted : 25/12/2024 4:28 pm
Topic starter
I realized I needed more fields from Airtable later on and selected all, and it still worked. I'm not sure why this didn't work for me last night.
Posted : 25/12/2024 4:29 pm
Hello,
Instead of that, try this:
AND({Status}='Done')
Instead of AND, you can use OR, SEARCH, or REGEX_MATCH. However, it all depends on the specific requirements.
The methods you attempted did not align with the Airtable formula structure. You need to adhere to the Airtable formula syntax.
Read more on these help docs and community articles.
Posted : 25/12/2024 5:10 pm