Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automation with variable date field

Topic Labels: Automations
Solved
Jump to Solution
255 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to set an automation that duplicates a record every time the original record is updated to status DONE.

But I’m finding trouble.

How could I set for TOMORROW the DATE FIELD of the new record created by the automation?

1 Solution

Accepted Solutions

Unfortunately, automations don’t allow you to write formulas, so you would need to create a formula field in your table that equals tomorrow. (You can hide this formula field after you create it.) Then you can call upon this field in your automation.

See Solution in Thread

1 Reply 1

Unfortunately, automations don’t allow you to write formulas, so you would need to create a formula field in your table that equals tomorrow. (You can hide this formula field after you create it.) Then you can call upon this field in your automation.