Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Integromat | Formula to search for Name

Topic Labels: Integrations
393 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello All
I have an integration with Integromat (that pulls NOAA Weather Zone Alerts).

When Integromat fires off a response… in the alert body an array is presented with zone or multiple zones:

"UGC": [
 "CAZ070",
 "CAZ071",
 ]

Now. Here is the issue:
I then want to search in my NWZ Zone table to get the record ID for each ZoneScreenshot 2021-11-08 083118

How do I make a formula to search through the array and iterate through the zone name Id’s?

Screenshot 2021-11-08 084000

Thanks

Josh

0 Replies 0