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?
Answer
Automation with variable date field
+2Best answer by ScottWorld
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.
+35Unfortunately, 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.