I have two fields Employee (Text) & Employee User (User). Is it possible to make the Employee User a Formula-User field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
The names from the employee field is imported to QuickBase. I want QB to automatically enter the User to the Employee User field. When clicked we can still see the user information. Please see attached picture for example.

Photo of Ann

Ann

  • 22 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 340 Points 250 badge 2x thumb
There's a "ToUser" function that you can use in formulas - but that works really best with emails - because that's much more likely to be unique (vs. names).

If you're looking to update mass update the User field in your data - you can run reports like you have already, and then use Fill Down in the Grid Edit to update the User field for many records at once (similar to how you would use Fill Down in Excel).
Photo of Ann

Ann

  • 22 Points
thanks!