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))
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago
    struggling with this one.  i need the date stamp of the last time the multiple choice (with log edit) of "WIP" was set.  there may have been other statuses after WIP, but i need to display Date Stamp of when WIP was selected.  thanks for your help.
  • 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.