Array Aggregator "add item" help

[Keith_Sublett]

I am looking for the “add item” or “map toggle” in the Array Aggregator for “aggregated fields.” I am using ChatGpt and this is what I’m dealing with…Option 1 — Reveal the hidden “Map / Add item” in Array aggregator

You do have the right module. You just need to switch that section into mapping mode.

1. In Array aggregator (green panel):

   • Source module: Iterator [3]

   • Target structure type: Custom

2. In the Aggregated fields header row, look on the far right for a tiny “Map” toggle (sometimes it’s offscreen).

   • If you don’t see it:

     • Zoom out the browser to 90%

     • Widen the right panel, or

     • Click the ⋮ (kebab) menu at the very top-right of the green panel and select Switch to mapping (wording varies).

3. When Map is ON, the checkboxes disappear and you’ll see a purple “+ Add item” at the bottom-right of that section.

4. Click + Add item four times and set:

   Group by (field under that section): select userEmail.

   • employee_name → Aggregation: first → Value: userName

   • regular_hours → Aggregation: sum → Value (click fx, paste):

     if(
       type = "TIME_OFF";
       0;
       round( duration / 3600 ; 2 )
     )
     
     

   • pto_hours → Aggregation: sum → Value:

     if(
       and( type = "TIME_OFF"; lower( if( empty( timeOffType ); ""; timeOffType ) ) = "vacation" );
       round( duration / 3600 ; 2 );
       0
     )
     
     

   • holiday_hours → Aggregation: sum → Value:

     if(
       and( type = "TIME_OFF"; lower( if( empty( timeOffType ); ""; timeOffType ) ) = "holiday" );
       round( duration / 3600 ; 2 );
       0
     )
     

[samliew]

Welcome to the Make community!

You have been misled by ChatGPT, as AI is not trained on how Make works. There is no such feature in Array Aggregators yet. You will have to use a “Set Multiple Variables module” before the Aggregator if you want to add additional fields.

What a great idea! I’m sure others will agree that this would be nice to have.

If this is important to you, please submit this suggestion to the Idea exchange, under Platform Ideas and Improvements. However, do search for a similar request first (and also upvote), just in case it has already been suggested to avoid duplicates.

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

— @samliew
_{P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!}