I’m trying to create an automation with Zapier by using a search formula upon a field in Airtable. What I can’t figure out is how to create a conditional formula that will search for strings containing certain information. For example, Based on input data from an Outlook Event input into Zapier, I want to search the subject of that event where the string value contains something that matches what is in Airtable. So, if the Subject is “Meetings | 100.1” how do I search for items matching “100.1” in Airtable? Thanks.
First off, how are you extracting that “100.1” in Zapier? Is it always going to be “100.1”, or will the search term vary based on the subject? I’m guessing it’s the latter, which is why I asked about your extraction method, as that will affect how you execute the search.