How to recall airtable field name in Filter in Airtable search record module

Beginner Questions
1

:bullseye: What is your goal?

Sorry for such a basic question, but I’ve looked through the documentation and still can’t figure it out.

I have a variable in the iterator that’s text. Before saving it to Airtable, I’d like to check if the text already exists in Airtable.

So I created an Airtable search record, connected the database there, and now I have to enter a formula in the field.

So, I entered the field name “Dish Name” = 2.Name from the iterator, according to the Airtable name, and it keeps telling me there’s an error:

[422] The formula for filtering records is invalid: Unknown field names: false

How do I insert the field name from Airtable so it’s recognized?

4

Hello @gumi

Assuming your field is exactly “Dish Name”, the correct search formula will look like this:

{Dish Name}='{{2.name}}'

You can also use FIND() or SEARCH()- especially combined with LOWER() if you want your search to be case-insensitive.

Remember that Airtable uses exact match. If you need fuzzy search, unfortunately you won’t be able to do it in Airtable.

I created a sample scenario so you can see the difference: