User Property Table

There may be times when you need to add additional information such as salary or department to your database users’ records. The problem arises when you need to extract this information for the current user, typically when defining access rights such as "Allow viewing records related to the people from my department." Using TeamDesk, you can extract users’ additional information for every table you need this information in. To make this process much easier, create the User Property table:

User Property table

To set up the User Property Table, follow these steps:

  1. Click the Setup link in the top right corner of the window.

  2. Select the Database tab.

  3. From the setup menu, select Sharing/Roles > Set User Property Table.

  4. TeamDesk will propose you to select an existing table having a User column as a key column, or create a new one:

    Create User Properties Table

Once the User Property Table is created, it will be extended with the E-Mail, First Name, Last Name, Screen Name, Role, Default Set, External User, and Last Access read-only columns.

User Properties Table

After that, you should add users to the User Property Table. You can add them via the Manage Users page or create new records in the User Property Table for each user.

To add users via the Manage Users Page, go to the Setup and select the Database tab.

Click Sharing/ Roles > Manage existing users shares in the setup menu. The system will display the list of users with the Add User Property button. Click on this button to add a user to the User Property table.

Add User Property

If a user has already been added to the User Property table, the User Property button is displayed for this user.

When the User Property table is created, you have a couple of additional options:

To add lookups to the user properties table, follow these steps:

  1. Click the Setup link at the top right corner of the window.

  2. Select a table you need.

  3. From the setup menu select Columns > Customize existing columns. The system will display the Columns form.

  4. On the Columns form, click on a necessary User type column name, and the Column Properties Form will be displayed.

  5. To add a lookup, click the New button near the User Properties section displayed under the Column Properties Form.

    User Properties section

Please note that in each database, only one User Property Table can be created.