Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Automation: change dates

860 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mathias_Elmose
7 - App Architect
7 - App Architect

Hi

I want to make automation that changed a date.

Trigger: If “start” date if before today

Action: change “start” date to one week from now

My question is: how do a make an action that changes a date?

1 Reply 1

There are a couple of ways to do this.

  1. If you’re comfortable with scripting, you could write a short bit of code in a scripting action that will take the existing date in {Start}, add one week to it, then put that new date back into the same field.

  2. If you prefer a no-code option, Make a formula field that adds one week to {Start} using DATETIME_ADD(). The automation’s action would then be an “Update record” action, and would update {Start} with the value from the formula field.