Can I bring a “User” into a record from another table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I created a Staff table which includes a “User” field, so I could add our staff’s Quickbase User name to their Staff record. In my Projects table, I would like to automatically fill in a Project record’s “User” field based on the Staff member assigned to a Project. Can I do this?


Photo of Patrick

Patrick

  • 40 Points

Posted 3 years ago

  • 0
  • 1
can you describe if you have a relationships between Projects and the User table?  Are you choosing the staff member assigned to the project via a drop down list from a relationship?  if so, just add a lookup field to the relationship to bring down the User field too, into the project record.
Photo of Patrick

Patrick

  • 40 Points
Thank you Mark, that was so easy, and I was trying to make it so hard!!! I really appreciate it,  Pat
:) thx for letting me know.  Yes, QuickBase is supposed to be easy, but sometimes its just a bit mysterious when you have never done something before.