Skip to main content
Question

Datetime Stamp for When Status set to a specific status.

  • June 21, 2017
  • 0 replies
  • 115 views
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 possible? This needs to be done through grid edit. I am new to QuickBase and learning as i go
    This topic has been closed for replies.

    The best way in terms of low tech solutions is to use a multiple choice field  with log changes enabled.

    You create formula fields to hive off the information from the most recent update and use those fields in View mode on forms and on reports.

    Here are the essential formulas.

    Parsing Append Only Fields

    so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry.  I am also assuming that you are logging the date and not the date and time.

    Most recent value (formula text field type)

    Trim(Right([my update field],"]"))

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

    ToDate(Left(Right([my update field],"["),9))

    Who did the most recent update (formula text field type)

    Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
    • jeannejeanne
    • Author
    • Registered
    • June 21, 2017
    Thanks, will give that a try, and yes only need the date. Is there any examples of this method?
    • jeannejeanne
    • Author
    • Registered
    • June 21, 2017
    I have it setting my forumla field to the last status set, but how do i get the date of the last entry for a specific status entered? thanks again!
    As posted above

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

    ToDate(Left(Right([my update field],"["),9))
      • jeannejeanne
      • Author
      • Registered
      • June 23, 2017

      thanks, actually got that working with the log field.  i am getting the date of a specific satus what is the formual to get the user name? can't seem to get that right.  this is what i am using to get date of WIP

          If(Contains([Update Status],"WIP"),
             ToDate(Left(Right(NotRight([Update Status],"WIP"),"["),9)),null)

      To get the name of the person who did the update, it should be this.

      Who did the most recent update (formula text field type)

      Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
      • jeannejeanne
      • Author
      • Registered
      • June 27, 2017
      At a lost.  Don't want to use forms, have a status field that has 9 choices, and will most likely be at least 7 or 8 of them as it goes through the process. for three the processes i have to store the date it was set to that specific status and for one of the status i have to record the person who set it to that specific status. I have tired log edit and using and creating a table to and using actions to put data in the table.  but with both i cannot get the specific information i need by lookup or formula to get the specific data I need.  Is this possible in grid edit?  thank you for any help or insight!
      Terms & ConditionsAccessibility statement