May 10, 2022 03:49 PM
I have an automation that creates new records in table B when a record is created in table A. For those records, I want to have as a due date Today() + 3 days. How can you do that within the automation without creating a new field in table A (workaround)?
May 10, 2022 04:08 PM
Hi Maria. Is what you are asking the same as if the due date was the “date of the record creation” + 3 days? The records I’m speaking of are the new records in table B. If so, you could just create a formula field (the due date) in table B with the formula being
DATEADD(CREATED_TIME(), 3, 'days')
Does that work for you?
May 10, 2022 06:16 PM
You either need a a new field in the table or a a script that calculates the date. You cannot use formula directly in an automation.
DATEADD(TODAY(), 3, 'days')
May 11, 2022 12:41 AM
I do not want to populate Table A with extra fields only relevant to the automation.
May 11, 2022 12:42 AM
Could you help on with the script syntaxis?
May 11, 2022 05:27 AM
I wasn’t suggesting a field in table A. Only that the due date field in table B be a formula field that uses the creation date of the record as the date to which 3 days will be added. Do you not want a due date field?
May 11, 2022 08:19 AM
Hi @augmented yes, this is a project that has different stages so I’m creating each stage with a different due date based on the creation date.
May 11, 2022 09:01 AM
@Maria_Alvarez So, is it correct to say that 1) you need a due date field in table B and 2) the due date is 3 days after the creation date? If so, see my original answer. Nothing needs be done in an automation.
If I have misunderstood, please clarify for me if you can. Thanks. Good luck!
May 11, 2022 05:03 PM
Hi @augmented I need a due date in table B, but depending on the task type it will be one value or another. So I can use one formula for all, I will need to “ideally” do it during the automation.