Airtable formula correct in Airtable but does not work in Make

How To
1

Hello,

I am creating a modules “search records” where I want to use this formula to filter records : FIND(“2025-11-12-Midi”, {cles_de_plages_reservees}) > 0).

The formula works fine in Airtable but not in Make.

Can you please help me find why ?

creation et gestion demande reservation.blueprint (1).json (36.3 KB)

4

Try to change double quote to single quote:

FIND(‘2025-11-12-Midi’, {cles_de_plages_reservees}) so >0 does not change anything. Module still will return 0 bundles.

The FIND formula in Airtable returns zero if no results are found. I don’t know your use case, but take a look to see if SEARCH might be a better choice.

Learn more about FIND() and SEARCH(): Airtable Community- Confusion with simple formula using FIND() and SEARCH()

Zrzut ekranu 2025-11-5 o 19.22.12
Zrzut ekranu 2025-11-5 o 19.22.121256×1210 143 KB

5

Hi There,

Thanks for your feedback.

Actually, I turned it otherwise (instead of looking for items matching condition, I have searched for items not matching condition and the right formula to use is : NOT({Cles_de_plages_reservees} = “{{2.Cle_de_plage_demandee}}”)

A now it works fin :slight_smile:

3 Likes