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:

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:

   

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.

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.

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:

• For any column of the User type, you can create lookups to the information stored in the User Properties table right from the column form.

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.

   

• Wherever you need User Properties information related to a current user, you can simply refer to a column of the User Property table by its name.

  

• In the Setup mode, there is the Manage Users page. It is extended with buttons to edit the corresponding record in the User Property table.

  

  Obviously, users just invited do not have a registered record in the User Property table. For such users, the button is named "Add User Property." This button allows adding a new user to the Users Properties table as a record with the user’s dropdown pre-selected.

  

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