Forum Discussion

JamesDalton's avatar
JamesDalton
Qrew Trainee
2 years ago
Solved

Question about Last updated by

Just wondering, Is the timestamp, Last updated by, a combination of the Date Modified and Last Modified By fields? Or is there a difference. Thanks, ------------------------------ Ja...
  • BrianSeymour's avatar
    BrianSeymour
    2 years ago

    For clarity, what Mark is saying is that Quickbase will auto-create a handful of fields when you create a new table:

    Date Created     (Field ID 1)
    Date Modified    (Field ID 2)
    Record ID#       (Field ID 3)
    Record Owner     (Field ID 4)
    Last Modified By (Field ID 5)

    However, it's possible that an Admin in your app created a Last updated by field, but how that is implemented would be specific to your app.

    Ahh, after re-reading this one, it sounds like you are referring to the time and userstamps displayed in the footer when viewing a single record. Yes, native Quickbase displays the Last updated by as a combination of the Last Modified By and Date Modified fields in the form footer as you described in your question.


    ------------------------------
    Brian Seymour
    ------------------------------

JamesDalton's avatar
JamesDalton
Qrew Trainee

Thanks Brian. That's what I suspected. I'm trying to build a work-around wherein my pipelines manually copy who actually modified the record to the target record. Most of the records that are created or modified in my app are done so through pipelines and since I'm the owner, the Last update by footer keeps pointing to my name.



------------------------------
James Dalton
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago

The built in fields cannot be changed. But you don't have to show them on the Form.

The Form Settings has a  tab for Properties where you can suppress those from showing.

Then you would need to build you own fields to display.

For example you can have the Pipeline populate fields for the date that the Pipeline was run and the last modified by of the user who did the update which triggered the update. Then display those on the form along with the native fields for who created the record and when.  



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • JamesDalton's avatar
    JamesDalton
    Qrew Trainee
    2 years ago

    Thanks, that's good to know. As far as a solution goes, that's what I'm thinking.



    ------------------------------
    James Dalton
    ------------------------------