Answer

Using automations to timestamp based on single select

Forum|Forum|3 years ago
May 12, 2022
4 replies
53 views

James_Rhoads
Participating Frequently

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!

Best answer by TheTimeSavingCo

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

Working version here

+31

TheTimeSavingCo
Brainy
Forum|Forum|3 years ago
May 12, 2022

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

Adam, Airtable Consultant - thetimesaving.company

Like

J

James_Rhoads
Author
Participating Frequently
Forum|Forum|3 years ago
May 12, 2022

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.