Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 23, 2022 09:32 AM
I’m trying to make a button in my interface that will update a date field to today, but it looks like buttons can only update fields to be a specific, pre-determined date. I wish the function was there to add relative dates like today, yesterday, a week from now, etc.
Sep 23, 2022 11:56 AM
Hey @Noah_Coleman,
You are right, can’t do it directly, unfortunately.
However, there is a workaround using an automation.
In your interface:
Sep 23, 2022 11:57 AM
There are ways to do this with a button that triggers an automation.
You can use formula fields to calculate today, yesterday, a week from now, etc.
Then have the automation copy the date from the formula field to the editable field.
If you use scripting, you can do it without the helper formula fields.
Sometimes I use an automation triggered by a single select and use the value of the single select to determine the specific action, instead of a button.