Build ordered date picklist for form

Beginner Questions
, ,
1

:bullseye: What is your goal?

I’d like to fully automate the management of a form field picklist by adding a new value.

I currently have many bundles (each bundle = one picklist option: {
“label”: “Monday March 2, 2026”,
“value”: “2026-03-02”,
“selected”: false,
“isDefault”: false
},
)

I want to insert one new bundle (mynew date option) and then I want to rebuild one single array (the full picklist) by aggregating all these bundles. Then I’d like to order these dates in cronological order.

:test_tube: What have you tried so far?

[
{
“label”: “Monday March 2, 2026”,
“value”: “2026-03-02”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 1,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday March 3, 2026”,
“value”: “2026-03-03”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 2,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday March 4, 2026”,
“value”: “2026-03-04”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 3,
“IMTLENGTH”: 65
},
{
“label”: “Thursday March 5, 2026”,
“value”: “2026-03-05”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 4,
“IMTLENGTH”: 65
},
{
“label”: “Friday March 6, 2026”,
“value”: “2026-03-06”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 5,
“IMTLENGTH”: 65
},
{
“label”: “Monday March 9, 2026”,
“value”: “2026-03-09”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 6,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday March 10, 2026”,
“value”: “2026-03-10”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 7,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday March 11, 2026”,
“value”: “2026-03-11”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 8,
“IMTLENGTH”: 65
},
{
“label”: “Thursday March 12, 2026”,
“value”: “2026-03-12”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 9,
“IMTLENGTH”: 65
},
{
“label”: “Friday March 13, 2026”,
“value”: “2026-03-13”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 10,
“IMTLENGTH”: 65
},
{
“label”: “Monday March 16, 2026”,
“value”: “2026-03-16”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 11,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday March 17, 2026”,
“value”: “2026-03-17”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 12,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday March 18, 2026”,
“value”: “2026-03-18”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 13,
“IMTLENGTH”: 65
},
{
“label”: “Thursday March 19, 2026”,
“value”: “2026-03-19”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 14,
“IMTLENGTH”: 65
},
{
“label”: “Friday March 20, 2026”,
“value”: “2026-03-20”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 15,
“IMTLENGTH”: 65
},
{
“label”: “Monday March 23, 2026”,
“value”: “2026-03-23”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 16,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday March 24, 2026”,
“value”: “2026-03-24”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 17,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday March 25, 2026”,
“value”: “2026-03-25”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 18,
“IMTLENGTH”: 65
},
{
“label”: “Thursday March 26, 2026”,
“value”: “2026-03-26”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 19,
“IMTLENGTH”: 65
},
{
“label”: “Friday March 27, 2026”,
“value”: “2026-03-27”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 20,
“IMTLENGTH”: 65
},
{
“label”: “Monday March 30, 2026”,
“value”: “2026-03-30”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 21,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday March 31, 2026”,
“value”: “2026-03-31”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 22,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday April 1, 2026”,
“value”: “2026-04-01”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 23,
“IMTLENGTH”: 65
},
{
“label”: “Thursday April 2, 2026”,
“value”: “2026-04-02”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 24,
“IMTLENGTH”: 65
},
{
“label”: “Friday April 3, 2026”,
“value”: “2026-04-03”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 25,
“IMTLENGTH”: 65
},
{
“label”: “Monday April 6, 2026”,
“value”: “2026-04-06”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 26,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday April 7, 2026”,
“value”: “2026-04-07”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 27,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday April 8, 2026”,
“value”: “2026-04-08”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 28,
“IMTLENGTH”: 65
},
{
“label”: “Thursday April 9, 2026”,
“value”: “2026-04-09”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 29,
“IMTLENGTH”: 65
},
{
“label”: “Friday April 10, 2026”,
“value”: “2026-04-10”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 30,
“IMTLENGTH”: 65
},
{
“label”: “Monday April 13, 2026”,
“value”: “2026-04-13”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 31,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday April 14, 2026”,
“value”: “2026-04-14”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 32,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday April 15, 2026”,
“value”: “2026-04-15”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 33,
“IMTLENGTH”: 65
},
{
“label”: “Thursday April 16, 2026”,
“value”: “2026-04-16”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 34,
“IMTLENGTH”: 65
},
{
“label”: “Friday April 17, 2026”,
“value”: “2026-04-17”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 35,
“IMTLENGTH”: 65
},
{
“label”: “Monday April 20, 2026”,
“value”: “2026-04-20”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 36,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday April 21, 2026”,
“value”: “2026-04-21”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 37,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday April 22, 2026”,
“value”: “2026-04-22”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 38,
“IMTLENGTH”: 65
},
{
“label”: “Thursday April 23, 2026”,
“value”: “2026-04-23”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 39,
“IMTLENGTH”: 65
},
{
“label”: “Friday April 24, 2026”,
“value”: “2026-04-24”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 40,
“IMTLENGTH”: 65
},
{
“label”: “Monday April 27, 2026”,
“value”: “2026-04-27”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 41,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday April 28, 2026”,
“value”: “2026-04-28”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 42,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday April 29, 2026”,
“value”: “2026-04-29”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 43,
“IMTLENGTH”: 65
},
{
“label”: “Thursday April 30, 2026”,
“value”: “2026-04-30”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 44,
“IMTLENGTH”: 65
},
{
“label”: “Friday May 1, 2026”,
“value”: “2026-05-01”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 45,
“IMTLENGTH”: 65
},
{
“label”: “Monday May 4, 2026”,
“value”: “2026-05-04”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 46,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday May 5, 2026”,
“value”: “2026-05-05”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 47,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday May 6, 2026”,
“value”: “2026-05-06”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 48,
“IMTLENGTH”: 65
},
{
“label”: “Thursday May 7, 2026”,
“value”: “2026-05-07”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 49,
“IMTLENGTH”: 65
},
{
“label”: “Friday May 8, 2026”,
“value”: “2026-05-08”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 50,
“IMTLENGTH”: 65
},
{
“label”: “Monday May 11, 2026”,
“value”: “2026-05-11”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 51,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday May 12, 2026”,
“value”: “2026-05-12”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 52,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday May 13, 2026”,
“value”: “2026-05-13”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 53,
“IMTLENGTH”: 65
},
{
“label”: “Thursday May 14, 2026”,
“value”: “2026-05-14”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 54,
“IMTLENGTH”: 65
},
{
“label”: “Friday May 15, 2026”,
“value”: “2026-05-15”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 55,
“IMTLENGTH”: 65
},
{
“label”: “Monday May 18, 2026”,
“value”: “2026-05-18”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 56,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday May 19, 2026”,
“value”: “2026-05-19”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 57,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday May 20, 2026”,
“value”: “2026-05-20”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 58,
“IMTLENGTH”: 65
},
{
“label”: “Thursday May 21, 2026”,
“value”: “2026-05-21”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 59,
“IMTLENGTH”: 65
},
{
“label”: “Friday May 22, 2026”,
“value”: “2026-05-22”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 60,
“IMTLENGTH”: 65
},
{
“label”: “Monday May 25, 2026”,
“value”: “2026-05-25”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 61,
“IMTLENGTH”: 65
},
{
“label”: “Tuesday May 26, 2026”,
“value”: “2026-05-26”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 62,
“IMTLENGTH”: 65
},
{
“label”: “Wednesday May 27, 2026”,
“value”: “2026-05-27”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 63,
“IMTLENGTH”: 65
},
{
“label”: “Thursday May 28, 2026”,
“value”: “2026-05-28”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 64,
“IMTLENGTH”: 65
},
{
“label”: “Friday May 29, 2026”,
“value”: “2026-05-29”,
“selected”: false,
“isDefault”: false,
“IMTINDEX”: 65,
“IMTLENGTH”: 65
}
]

I iterate through the dates, I aggregate them, then I create a variable to collect existing date, thenI set another variable to add the new date to the existing, but I’m stuck. It seems it doesn’t work, my function doesn’t work either.

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

Screenshot 2026-02-27 110417.png
Screenshot 2026-02-27 110417.png485×512 28 KB

1 Like
3

Hey Laura,

toCollection() converts an array to a collection. So it doesn’t work like that. Also your semicolons are wrong, they are just plain text at the moment and not part of the function.

You can use a Set Multiple Variables module to create the new items, then use add() to add the entire output bundle from that module to add the item to the array.

Here is a quick and dirt example:

4

Hi Stoyan,

thanks for your reply.

I have tried to reproduce what you have built.

  1. Array Aggregator

image
image417×596 28.3 KB

Output: [
{
“array”: [
{
“label”: “Monday March 2, 2026”,
“value”: “2026-03-02”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday March 3, 2026”,
“value”: “2026-03-03”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday March 4, 2026”,
“value”: “2026-03-04”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday March 5, 2026”,
“value”: “2026-03-05”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday March 6, 2026”,
“value”: “2026-03-06”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday March 9, 2026”,
“value”: “2026-03-09”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday March 10, 2026”,
“value”: “2026-03-10”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday March 11, 2026”,
“value”: “2026-03-11”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday March 12, 2026”,
“value”: “2026-03-12”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday March 13, 2026”,
“value”: “2026-03-13”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday March 16, 2026”,
“value”: “2026-03-16”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday March 17, 2026”,
“value”: “2026-03-17”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday March 18, 2026”,
“value”: “2026-03-18”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday March 19, 2026”,
“value”: “2026-03-19”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday March 20, 2026”,
“value”: “2026-03-20”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday March 23, 2026”,
“value”: “2026-03-23”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday March 24, 2026”,
“value”: “2026-03-24”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday March 25, 2026”,
“value”: “2026-03-25”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday March 26, 2026”,
“value”: “2026-03-26”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday March 27, 2026”,
“value”: “2026-03-27”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday March 30, 2026”,
“value”: “2026-03-30”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday March 31, 2026”,
“value”: “2026-03-31”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday April 1, 2026”,
“value”: “2026-04-01”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday April 2, 2026”,
“value”: “2026-04-02”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday April 3, 2026”,
“value”: “2026-04-03”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday April 6, 2026”,
“value”: “2026-04-06”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday April 7, 2026”,
“value”: “2026-04-07”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday April 8, 2026”,
“value”: “2026-04-08”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday April 9, 2026”,
“value”: “2026-04-09”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday April 10, 2026”,
“value”: “2026-04-10”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday April 13, 2026”,
“value”: “2026-04-13”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday April 14, 2026”,
“value”: “2026-04-14”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday April 15, 2026”,
“value”: “2026-04-15”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday April 16, 2026”,
“value”: “2026-04-16”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday April 17, 2026”,
“value”: “2026-04-17”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday April 20, 2026”,
“value”: “2026-04-20”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday April 21, 2026”,
“value”: “2026-04-21”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday April 22, 2026”,
“value”: “2026-04-22”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday April 23, 2026”,
“value”: “2026-04-23”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday April 24, 2026”,
“value”: “2026-04-24”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday April 27, 2026”,
“value”: “2026-04-27”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday April 28, 2026”,
“value”: “2026-04-28”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday April 29, 2026”,
“value”: “2026-04-29”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday April 30, 2026”,
“value”: “2026-04-30”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday May 1, 2026”,
“value”: “2026-05-01”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday May 4, 2026”,
“value”: “2026-05-04”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday May 5, 2026”,
“value”: “2026-05-05”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday May 6, 2026”,
“value”: “2026-05-06”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday May 7, 2026”,
“value”: “2026-05-07”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday May 8, 2026”,
“value”: “2026-05-08”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday May 11, 2026”,
“value”: “2026-05-11”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday May 12, 2026”,
“value”: “2026-05-12”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday May 13, 2026”,
“value”: “2026-05-13”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday May 14, 2026”,
“value”: “2026-05-14”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday May 15, 2026”,
“value”: “2026-05-15”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday May 18, 2026”,
“value”: “2026-05-18”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday May 19, 2026”,
“value”: “2026-05-19”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday May 20, 2026”,
“value”: “2026-05-20”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday May 21, 2026”,
“value”: “2026-05-21”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday May 22, 2026”,
“value”: “2026-05-22”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Monday May 25, 2026”,
“value”: “2026-05-25”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Tuesday May 26, 2026”,
“value”: “2026-05-26”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Wednesday May 27, 2026”,
“value”: “2026-05-27”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Thursday May 28, 2026”,
“value”: “2026-05-28”,
“selected”: false,
“isDefault”: false
},
{
“label”: “Friday May 29, 2026”,
“value”: “2026-05-29”,
“selected”: false,
“isDefault”: false
}
],
“_IMTAGGLENGTH_”: 65
}
]

  1. Set Multiple Variable

image
image417×915 30.1 KB

output is: [
{
“label”: “1 June 2026”,
“value”: “2026-06-01”,
“selected”: “false”,
“isDefault”: “false”
}
]

  1. Set Variable

image
image626×515 33 KB

I think 'I’m still doing something wrong as I get an error when I run the scenario.

image
image425×675 35.2 KB

Do you spot the error? :joy:

5

You are missing a semicolon before desc.

3 Likes
6

Stoyan, you saved me a lot of time! Sometimes these details are the easiest to overlook, thank you.
Have a nice weekend

1 Like