Search Airtable records from Make using an array of values
Hello Airtable Community,
I’m receiving an array from a Fillout form via webhook into Make (see attached image)
I would like to use this array in a Search Records module for Airtable to find all records where the primary field matches any of the values in the array.
What’s the correct formula syntax in Make’s Airtable module to achieve this?
Thanks in advance
Page 1 / 1
Hey @Project_NP_LS,
What about using an Iterator module, to iterate through all values of the array, and then search for one value at a time (using the output of the iterator as the input for your formula -FIND() or just “is equal to- on your Airtable search records module)?
thank you for your suggestion. I will give that a try.
In the meantime, make support wrote back to me with their suggestion (see attached image).
As you probably guessed, it resulted in 0 Bundles
Re your kind offer to join the Hackathon, I really am a novice who works very slowly so I suspect I’m far far behind the 8 ball from this event unfortunately
If it’s an exact match, try adding an Iterator module and using the value from questions → 1→ value in there, then set up your formula like so:
{Medium}="{{1.value}}"
Hello @TheTimeSavingCo , @Mike_AutomaticN,
thank you both very much for your help.
The Iterator and Text Aggregator works well overall — I’ve set Row separator = Other (comma) to combine the matching results.
However, instead of producing one operation with all the matching results flattened, it’s currently returning the same number of operations as the Airtable Search module (one per iterator loop).
My goal is to flatten all the matching results into a single comma-separated string (one operation), and then use the split() function in my Airtable module’s formula field to turn that string back into an array.
Could you please confirm how to configure the Text Aggregator so it runs once after all iterator searches have completed, rather than once per iteration?
Ultimate goal: to upsert (create or update) one Airtable record and populate its linked-record field with all the matching records returned from the searches — i.e. one record in Airtable containing all linked results.
Thank you in advanced
P.S Please do let me know if I have over engineered this or if this is indeed the way to get to my ends goal
Hm, if I were you I’d do:
Iterator
Search records
Array aggregator to consolidate the Search Records results
Upsert with the Array aggregator data
Hello @TheTimeSavingCo ,
yes I tries the initially but it still returns the same number of operations as the search i.e. it doesn’t consolidate the results.
This is where I am stuck
Try setting the Array Aggregator’s source to the Iterator instead and select the ID:
And so you’ll end up with this:
For the upsert module’s linked field, set it up like this:
{{map(3.array; "id")}}
Hello @TheTimeSavingCo ,
That’s exactly it. Thank you so so much for your help with this. Much Much appreciated 😊 I am doing virtual cartwheels as we speak 🤣 Your perfect solution will save me an inordinate amount of time, effort and nerves. Again thanks so much for your generosity of time to help me solve this,
Best
Ladi
Glad I could help! I’d really appreciate it if you could mark it as the solution!
Hi @TheTimeSavingCo ,
I haven’t done this before so can I check if you are referring to the greyed out “Best Answer” label at the bottom?