Skip to main content
Question

Using User Fields in Connected tables

  • February 23, 2023
  • 0 replies
  • 65 views

We have many apps that use employee tables, and every time we have a new hire or someone changes departments, we need to update all of these tables.  So we created a master table and connected it to all the other apps.  However, when I bring in the user email field, it comes in as a text field instead of a user field.  When I try to change it to a user field, it gives me an error.  I want to make this the Key field in the employee table, but I can't figure out how to make it let me.

I have used User fields as Key fields in other non-connected tables, and it is excellent for employee-to-employee relationships, so I know it is possible, but I can't make it work in a connected table.

Any advice?

Thanks,

David



------------------------------
David Pontier
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    I suggest that you just use that text field as the key field. You can calculate that value from a any user field or the Current User

    User()

    from any other table

    ToText(UserToEmail([My user field])))

    and make your relationship and look up any Fields you need from your user table



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement