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 👍🏾🙏🏾

Hello again ​@TheTimeSavingCo , 

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

Hmm, 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 ​@TheTimeSavingCo , 
not sure if my DM came through.

In any case, managed to get this solution that does exactly what I need in my base.