Forum Discussion

RickyWhite's avatar
RickyWhite
Qrew Member
20 days ago

Auto-generate Name of User

I need to create a field that Auto-generates the User who input a date into a date field. What are some ways of doing this?



------------------------------
Ricky White
Ricky
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger

    I don't know if you are using Legacy forms or new style forms, but you should be able to set up a form rule that triggers when the record is saved, and the date field has changed, then take the action to change the value of the field for who updated the date to the current user.  make the field of who  change the date a user type field..

    If the form rule doesn't natively offer up the current user as a choice to put in that field, then you can make a helper field called current user as a formula user type with the formula of User(). Then have the form rule change the value of the target field two the value in that current user field.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • RickyWhite's avatar
      RickyWhite
      Qrew Member

      Okay, that worked. I was thinking doing it that way would mess up if someone was to edit the form again it would change the name, but it only seems change if the field changes from false to true, which I have the condition set to is not blank. So, thank you!



      ------------------------------
      Ricky White
      Ricky
      ------------------------------