Set a date to another field, minus 7 days

Is it possible to use an automation to fill in a date field, if the user has missed it?

I would have a publication date for a piece of content, and would want to set the writer’s deadline 7 days’ prior.

I’m new to automations, so any pointers on how could I do this?

I was thinking of creating a view to show such records, and using a record entering that as a trigger.

Hi David,

You’d need to have a formula field with the formula DATEADD({Publication Date}, -7, "days") to first calculate the date of 7 days before the publication date.

Your idea about using a view to show such records works, and there’s an automation trigger for “When record enters view” that you can use

After that, you’d make the action “Update record”, where you would update the record that triggered the automation, and paste the value from the formula field mentioned above.

Given that for the automation to work you must have a formula field with the calculated date in it, do you think we could just do away with the automation and just use that formula field instead?