I would like to create an automation that triggers when a new record is created. This record contains a field "date" without time. After the trigger, the action is to create multiple records with a field "date" with time. I would like to use the date from the record in the trigger and add a time afterwards.
- Trigger = new record created with a field Date equal to "22-05-2023"
- Action = Create 5 records, taking the date of the trigger, and adding time -> "22-05-2023 14:00" ; "22-05-2023 15:00", etc.
I have tried to achieve this using a script in the automation but it doesn't work. Somehow the output in the script testing is correct, but the value displayed in the created records are wrong..