- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2020 09:49 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2020 08:38 AM
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.