how to take objects from an array and “tie” them together like in the 2nd image? ChatGPT is suggesting thjis - “mapItem.StaffName & " | Priority: " & mapItem.PriorityRank & " | Calendar: " & mapItem.CalendarID” but i cant seem to find “mapItem” function
Welcome to the Make community!
From your screenshot/output bundle, it appears that you have an ARRAY of items. What do you do when you have an array?
“Looping” Through Array Items
When you see an array in your module’s output, think of using an Iterator module.
In this example, this variable is an array of items (collections). You’ll want to map this array in an Iterator module.
Question: Have you tried mapping your array variable into an Iterator module, ran the scenario once, and view the output?
Next,
Combining Bundles Using Aggregators
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
- Array aggregator
- Text aggregator
- Numeric aggregator
- Table aggregator
- JSON aggregator
- CSV aggregator
- Archive (ZIP) aggregator
- other app-specific aggregators
Question: Which is the best aggregator do you think you’ll need for your use-case?
Example
Here is an example of how your scenario could look like:
This is just an example. Your final solution may or may not look like this depending on your requirements and actual data.
For more information, see “Mapping with arrays” in the Help Centre. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.
Hope this helps! If you are still having trouble, please provide more details.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
thanks @samliew Yes I had tried array aggregator but that was even more confusing so i used json just to figure out the correct syntex. Attached is the actual workflow. I am trying to map the output of Array aggregator (141) to come out as a nicely structured rows of text like this. I tried the map () in the syntex but it only outputs one of the objects of the array either Staff name (staff A) or Priority no (1,2,3) or Calander url. I am trying to make it to out put all 3 of these not jsut one of the fields
Staff A | Priority: 4 | Calendar: staffA@group.calendar.google.com
Staff B | Priority: 3 | Calendar: staffB@group.calendar.google.com
Staff C | Priority: 2 | Calendar: staffC@group.calendar.google.com
Staff D | Priority: 1 | Calendar: staffD@group.calendar.google.com
What other aggregators are there?