Hello,
I am trying to use the Airtable search module, but I need a formula that searches a string that contains certain text, not the exact string.
The one above works only for the exact string. I tried to find a solution in the Airtable documentation but without success. Any experience with this?
Try this.
Don’t use any search formula. Increase your limit to your whole base.
Then use a filter after for Org name contains Company name from airtable kinda like below.
Imagine Id is company name from airtable
and org name is org name from module 2
Thanks for the tip @Mr.Make! This helps but it is making the scenario complicated afterward since I don’t get the record ID if the data exists.
If the company exists I need to update the record and if not I need to create a new one. Any tips for this case?
