Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Using automations to timestamp based on single select

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

Hello!

I am trying to create timestamps of the start can completion date based off of a status field I have set up. I have a status field, a Start Date field, and a Completed field. The status has the single selections of “To Do”, “In Progress”, and “Completed”. I have set it up, so timestamps are automatically populated into the Start Date and Completed fields based off of “In Progress” and “Completed” status. I wanted to know if there was a way to clear the records within the Start Date and Completed fields when the “To Do” status is selected? Is this possible?

Thank you in advance for the help!

1 Solution

Accepted Solutions

Hm, I just left the field empty and it seemed to work

Screenshot 2022-05-12 at 10.29.30 AM

Working version here

See Solution in Thread

4 Replies 4

Hmm, this would be possible via an automation that triggered when the status of a record was “To Do”, and then the action would be to update the “Start Date” and “Completed” fields to be blank?

I feel like I’m missing something though, apologies

Yeah, I have set up an automation to detect the “To Do” status and I tried making a static date that wasn’t filled in, but that didn’t update the record unfortunately.

Hm, I just left the field empty and it seemed to work

Screenshot 2022-05-12 at 10.29.30 AM

Working version here

That worked! I just had to reselect the To Do Status.

Thank you!