0

Time Stamps for Status Changes

I have multiple "process status" fields that I want to time stamp when the status changes (or the last time it was changed).

I'm using both Yes/No and Choice type fields.

So when a status changes to Yes, I want to display the time that happens. 

I tried using:

if 'Accepted By Processing' then
now()
end

Obviously the problem here is that this field is always changing to the Now time.  How do I lock in the time when a status field changes.

I've looked through the forum and could not find a formula for this.

THANK YOU in advance!

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

    I assume you have Date/Time fields setup to accept the time stamp? If so, you can add something like this to your Yes/No and Choice fields...

     

    let t := this;
    if t.'Yes / No' then
    t.('Date / Time' := now())
    else
    t.('Date / Time' := null)
    end

     

    let t := this;
    if text(t.Choice) = "YourValue" then
    t.('Date / Time' := now())
    else
    t.('Date / Time' := null)
    end

    Like
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

    The code would go in the "Trigger after update" for the Yes/No and Choice fields.

    Like
    • wstarnes
    • wstarnes
    • 3 yrs ago
    • Reported - view

    Sean,

    Thank you for your response.  It looks like that sorts out my problem!  Big Thanks!!

    Cheers!

    Like
Like Follow
  • 3 yrs agoLast active
  • 3Replies
  • 1201Views