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 Zone
How do I make a formula to search through the array and iterate through the zone name Id’s?
Thanks
Josh
