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
Best answer by TheTimeSavingCo
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")}}
+28Hey
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)?
Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!
Mike, Consultant @ Automatic Nation
YouTube Channel
Hello
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
+31If 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
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
+31Hm, if I were you I’d do:
Hello
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
+31Try 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
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
+31Glad I could help! I’d really appreciate it if you could mark it as the solution!
Hi
I haven’t done this before so can I check if you are referring to the greyed out “Best Answer” label at the bottom?
+31Yeap, thank you!
Hello again
Building on the scenario, my Array Aggregator now groups results by single select field in my airtable base i.e. Tag or Medium (see attached image)
I need to map these grouped IDs into the Airtable linked fields, but I don't know what the correct formula/syntax is.
Can you kindly assistance for the correct syntax for the each of the fields shown in the attached image of my airtable module
Thank you very much
+31Hmm, if you could DM me a link to your base and invite me to your Make org I could take a look at this for you!
Hello
not sure if my DM came through.
In any case, managed to get this solution that does exactly what I need in my base.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.