Forum Discussion
MarkShnier__You
3 years agoQrew Legend
I think that you have two choices here. If you want the result of your selections to be actual users than you you need to use a field type called list user. That field type does not allow for selections from another table. It will however have the ability to offer up all users in your application that are flagged as being available for Showing in User Pickers on the Users page.
Alternatively, you can make a field on your employees table called [Full Name] with a formula of UsertoName([my user field]) and then you will get a clean list of names. Those negative numbers actually represent the way that a user is uniquely identified. The unique identification is a strange number. But that allows for the user to change their name and also even change their email address and that user will still be the same userid. It's kind of like the SSN number for the user in Quickbase.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Alternatively, you can make a field on your employees table called [Full Name] with a formula of UsertoName([my user field]) and then you will get a clean list of names. Those negative numbers actually represent the way that a user is uniquely identified. The unique identification is a strange number. But that allows for the user to change their name and also even change their email address and that user will still be the same userid. It's kind of like the SSN number for the user in Quickbase.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------