Discussions

Expand all | Collapse all

Datetime Stamp for When Status set to a specific status.

  • 1.  Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 11:35
    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


  • 2.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 12:47
    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))


  • 3.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 14:39
    Thanks, will give that a try, and yes only need the date. Is there any examples of this method?


  • 4.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 15:33
    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!


  • 5.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 15:42
    As posted above

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


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


  • 6.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 18:33
    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.


  • 7.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-21-2017 18:48
    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.


  • 8.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-23-2017 15:38

    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)



  • 9.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-23-2017 23:04
    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))


  • 10.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-26-2017 20:33
    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!


  • 11.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-26-2017 22:01
    Think i figured out by creating a (action) table for each status, is that the best solution or is there a better way? thanks.


  • 12.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-26-2017 22:14
    Why can't you just use one table to have the Action write to, to record the Status changes?  Why a table per Status?


  • 13.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 11:03

    i wasn't able to figure out how to do a lookup from the parent table to the status table to get the date/time of a specific status




  • 14.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 11:55
    You can do a summary maximum of the date subject to the filter that the status was a particular status.


  • 15.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 12:46

    in the report? How? I couldn't figure out how to do that, so did the summary on the table relationship





  • 16.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 13:27
    Yes, the Summary field is created in the relationship.


  • 17.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 13:33

    You can do multiple summaries with different criteria in the relationship?




  • 18.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 13:35
    There is no limit to the number of summary fields you can create in a relationship.

    The easiest way to make the 2nd one is to duplicate the first field and change the filter criteria.


  • 19.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 14:08
    how would i do this if i want to get the user name of the last modified by?


  • 20.  RE: Datetime Stamp for When Status set to a specific status.

    Posted 06-27-2017 15:19
    OK, so that is a bit more complicated with a child table.  You will need to make a summary maximum field of the maximum [Record ID#] of the status log records for that Status.

    Then make a new "reverse relationship"  where 1 status log has many Parent records.  (I don't know what your parent records are called).  But them use that [Maximum Record ID#] field on the right side of the relationship.  Then lookup the user field up to the Parent.