Aug 07, 2022 06:00 AM
Hi, I have a database of professionals for whom I want to create a formula to search for the appropriate therapist using MAKE
There are categories where I want to search all searchable categories, and there are categories where I want to search one or another category.
for example-
I am interested in looking for a therapist “for children” in the area or “Tel Aviv” or Jerusalem.
AND(
SEARCH(“children”,{categorys})
OR(
SEARCH(“Tel Aviv”,{categorys})
SEARCH(“Jerusalem”,{categorys})
)
)
But apparently the formula is incorrect.
Would appreciate help
Solved! Go to Solution.
Aug 07, 2022 08:44 AM
One important thing to note is that Airtable is extremely finicky when it comes to capitalization. So Airtable will see “children” as different than “Children”.
Aug 07, 2022 08:36 AM
So all of the words you’re looking for are inside that one category formula field?
If so, this formula should work:
OR(
AND(
SEARCH("children",{categorys}),
SEARCH("Tel Aviv",{categorys})
),
AND(
SEARCH("children",{categorys}),
SEARCH("Jerusalem",{categorys})
)
)
Aug 07, 2022 08:44 AM
One important thing to note is that Airtable is extremely finicky when it comes to capitalization. So Airtable will see “children” as different than “Children”.
Aug 07, 2022 11:27 AM
Thank you very much, but unfortunately the formula does not work
And I checked in capital letters, everything is the same
Aug 07, 2022 11:43 AM
It is hard to read your screen capture but here are some possibilities.
"
and not curly quotes. Your text example has some curly quotes “”
.{
,(
, }
, )
.Try something like this:
AND(
SEARCH("children", LOWER({categorys}) ),
OR(
SEARCH("Tel Aviv", {Area} & ""),
SEARCH("Jerusalem", {Area} & "")
)
)
Aug 07, 2022 11:54 AM
Thank you very much, I will try
Aug 07, 2022 11:58 AM
It works great. Thank you
Aug 07, 2022 12:08 PM
Alternatively, note that it’s often easier to create & keep those large formulas in Airtable.
In Airtable, your formula field would result in a 1 (if it is true) or a 0 (if it is false).
Then, in Make.com, you would simply need to put the name of your formula field (within curly brackets) for your search criteria.