Forum Discussion

jeannejeanne's avatar
jeannejeanne
Qrew Cadet
8 years ago

Datetime Stamp for When Status set to a specific status.

I want to a datetime stamp from a multiple choice field when set to a specific status. I do not want to use the log edit method, i want to status to only show the last status chosen. Is this possib...
App builders
Ask about Quickbase functionality
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
As posted above

Date of most recent update (this needs to be a formula date field)

ToDate(Left(Right([my update field],"["),9))
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
OK, sorry, I missed the point about needing only for a particular status.

I think that we need to go to plan B here.  Nevermind the log field. 

I suggest using Actions. You will find that in Settings for the Table

Set up a child table to log changes to that field in the main record.  call it Status changes for status XXX

The Action will trigger when the record is saved and the status changes and the status is the special value.

Then on the relationship summarize the maximum of that field and you will have the date of the most recent change.