I am working on a Zap and trying to use a search formula to be able to find a phone number when there are multiple phone numbers in a cell. These are text strings and not linked records as I know linked records are identified by ID. Forewarning, I'm terrible with crafting formulas!
Here is where I'm at with the formula:
Here is the formula in textual format if you want to play with it:
Basically, what I want to happen is for the search formula to look at a comma-separated list of phone numbers, see if the phone number from Ring Central is in that list and if so, return the number.
Here are some modifications/things I know that need to change:
- Airtable doesn't seem to support ISNUMBER so that will have to be removed
- I actually don't care if the phone number itself is returned. Returning "True" or "False" will work just fine.
Best answer by Openside
Actually it looks like their documentation does require quotes:
Contact Name}="<TriggerValue>(Step 1: From Name)<TriggerValue>"