How to convert Airtable Search Records Output to String (Multiple Collections to one String)

[cd]

Hello everyone,

I get the following output from an Airtable Search Records Module:

Airtable Search Records Output.json (4.6 KB)

Next, I would like to set a variable “product_listings” to contain Title, Subtitle, Description and Analysis of all records found by the Airtable module in one string, separated by a line break (Description and Analysis should be returned in full, just shortened for readability in this post):

Title: Urban Explorer Tactical Backpack
Subtitle: Outdoor Gear
Description: This tactical backpack is designed for urban expl...
Analysis: - **Most relevant niche:** Outdoor adventure and tactical ge...

Title: Vintage Vinyl Record Player
Subtitle: Retro Music Lover's Delight
Description: This vintage-style vinyl record player com...
Analysis: - **Most relevant niche:** Vintage audio equ...

I tried multiple things for many hours but I am stuck… Your help is highly appreciated!

[Msquare_Automation]

Hi @cd

Could you please share the steps you have taken so far and where you are lagging?

Regards,
Msquare Automation - Gold Partner of Make

[cd]

Sure, I can let you in on my attempts. The closest was aggregating the output to an array of collections using the array aggregator module.

Array Aggregator Output.json (4.5 KB)

However, I failed in putting the result in one string with whatever string or array formula make.com provides in the set multiple variables module. I am not even sure if that is the way to go or if I am missing something.

[Msquare_Automation]

@cd

It would be better if you would attach the exported blueprint of your scenario.

To share the blueprint, Please refer to below image:

Sharing of blueprint is completely safe.

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

[cd]

Sure, here we go:

Product Listings.json (14.3 KB)

Thanks for your help

[samliew]

Change your Array Aggregator to a Text Aggregator.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

[Msquare_Automation]

Hi @cd

Please import the attached blueprint I’ve edited in your scenario.
blueprint (30).json (18.2 KB)

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

[cd]

@samliew @Msquare_Automation

Thanks a ton. The Text aggregator seems to solve most of my challenges.

However, one thing remains, I need to know how many products have been aggregated the text. Therefore, I set a variable “numberOfInputs”. Using the text aggregator, the Total number of bundles from the Airtable module is no longer within reach. Any idea how to solve that?

[samliew]

If you need the total number, then you have to use an Array Aggregator first.

Then after that, use an Iterator to iterate the array, which you aggregate to text shown in my previous post.

If you need further assistance, please provide the following:

• screenshot of updated scenario and module fields.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

[cd]

I tried this as well… unfortunately, due to the aggregator, at the end of the cycle the total number is forgotten already.

Module 16, at the end should define one variable at the end containing the aggregated text from module 13 and the info how many items were aggregated (Bundles of module 2).

[samliew]

The Text Aggregator’s source module field should be set to the Iterator module.

Otherwise you wouldn’t be able to access the array from the array aggregator!

[cd]

Thank you! That worked