Store/Transpose items from multiple bundles into new unique fields in 1 single record

I have a set of Airtable record IDs that I want to process. I process them by using the iterator module, followed by a ‘Get record’ Airtable module. The next step I would like to do is store each item inside of each bundle and map them to their own unique field inside of 1 record. For example:

Take the ‘message body’ in bundle 1 and map it to a field called ‘message 1’, then take the ‘message body’ in bundle 2 and map it to a field called ‘message 2’, then take the ‘message body’ in bundle 3, and map it to a field called ‘message 3’, etc.

How can I achieve this? Would appreciate some help if anyone knows.

Hello @Chaz_A,
Welcome to the community.

Just use Array Aggregator after you Get a Record., Which is combining all bundles into an Array again.
Then Use get() and map() functions.

Read more about GET and MAP
https://academy.make.com/courses/IntermediateC02
https://www.make.com/en/help/functions/general-functions#get--object-or-array--path-
https://www.make.com/en/help/functions/array-functions#map-complex-array--key--key-for-filtering---possible-values-for-filtering-separated-by-a-comma--


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions :white_check_mark: and give :+1: If you need expert help or have questions? Contact or comment below! :point_down:

Thanks @dilipborad I followed the training on Array Aggegators and get() and map() functions which helped me massively resolve the issue.

For anyone who wants to see how I resolved, see screenshot:

2 Likes