I use date calculations to create dates in the future. I use the date pipe, but I can only do 1 calculation each time. So say I want to add 5 new dates in a datarow, I need to do 5 consecutive date pipe requests in order to get all 5 results.
I tried the date calculation field, but the output of this formula field cannot be used as a input parameters for a scheduled task for instance.
Is there a way I can tweak the date pipe ? So for instance do the following:
input–> date today
add 2 days → output 1
add 4 days → output 2
add 10 days → output 3…
Whenever a record is created, I want to set 5 dates for reminder emails.
I use the ‘add days’ function pipe, with the current date and the number of days to be added as input.
In the current setup I need to do that 5 consecutive times to get all dates.
The reminder emails are automations, based on a trigger that for instance ‘reminder email 4 date = current date’. Therefore I cannot use the calculation date field field, since those fields cannot be used in automations.