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
jeannejeanne's avatar
jeannejeanne
Qrew Cadet
8 years ago
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!
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago
    Think i figured out by creating a (action) table for each status, is that the best solution or is there a better way? thanks.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Why can't you just use one table to have the Action write to, to record the Status changes?  Why a table per Status?
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago

    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


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    You can do a summary maximum of the date subject to the filter that the status was a particular status.
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago

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



  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Yes, the Summary field is created in the relationship.
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago

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


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
  • jeannejeanne's avatar
    jeannejeanne
    Qrew Cadet
    8 years ago
    how would i do this if i want to get the user name of the last modified by?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.