Yeap, you could do this with the AND() and OR() functions, documentation here
Are you facing any specific difficulties in creating the formula?
I simply can't get my head around how to structure it. I'm not very techie.
Once you get past the first wall, you will understand
If I put it into a formula as you have explained, it would be this.
IF(
AND(
FIND("*{{1.postcodeZone}}*", {Postcode Zone}),
{Field 1},
OR(
FIND("all",{Field 2}),
FIND("abc",{Field 2})
)
),
"true",
"false"
)
Once you get past the first wall, you will understand
If I put it into a formula as you have explained, it would be this.
IF(
AND(
FIND("*{{1.postcodeZone}}*", {Postcode Zone}),
{Field 1},
OR(
FIND("all",{Field 2}),
FIND("abc",{Field 2})
)
),
"true",
"false"
)
Thanks, I really appreciate that.
I think maybe I didn't explain well. I ALWAYS need the postcode zone to contain the input variable.
So with the above in mind, I had a play around, but I get an error.
IF(
AND(
FIND("*NN1*", {Postcode Zone}),
{Test Field 1},
OR(
FIND("*NN1*", {Postcode Zone})
AND(
FIND("all",{Test Field 2}),
OR(
FIND("*NN1*", {Postcode Zone})
AND(
FIND("abc",{Test Field 2})
)
),
"true",
"false"
)
I still can't see what your goal is.
Add a check for postcode and if postcode is empty, it will be false.
IF(
AND(
AND(
FIND("*{{1.postcodeZone}}*", {Postcode Zone}),
{Field 1},
OR(
FIND("all",{Field 2}),
FIND("abc",{Field 2})
)
),
{Postcode Zone}
),
"true",
"false"
)
I still can't see what your goal is.
Add a check for postcode and if postcode is empty, it will be false.
IF(
AND(
AND(
FIND("*{{1.postcodeZone}}*", {Postcode Zone}),
{Field 1},
OR(
FIND("all",{Field 2}),
FIND("abc",{Field 2})
)
),
{Postcode Zone}
),
"true",
"false"
)
Ok, so the use case is, I'm using the make.com airtable formula search field.
What I'm trying to do, is distribute leads to local clients. IE, they cover that postcode AND then they offer the service the lead is looking for...
So, they need to have the postcode listed as something they cover AND then they need to have the service offering, hence the AND/OR, ie they offer that service specifically, or offer "all" services.
I've run this formula, and it just returns a bunch of records that don't even contain the postcode zone...
