Skip to main content

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
 

 

 

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)?

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 ​@Mike_AutomaticN Mike_

 

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:

  1. Iterator
  2. Search records
  3. Array aggregator to consolidate the Search Records results
  4. 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?


Yeap, thank you!


Done 👍🏾🙏🏾