User Columns

User Columns comprise users of your database. For instance, if you want to assign a task to your staff or your team member, who is TeamDesk user, you should choose the User type column and the list of users will be suggested automatically.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

General Properties:

You can set the Current user option in the General Properties and the current user value will be inserted by default in this User field, when a new record is created.

Properties defined by the column type:

User Options

Column Property



This property allows a user to specify the format for entering user names. The following values are possible:

  • Full Name
  • Last Name, First Name
  • Screen Name

User Set

This property allows a user to specify the set of users that will be used in the system:

  • Select the Default Set option if you want to use pre-configured set of users;
  • Select the Custom Set option if you want to make up a custom list of users. In this case the emails of already invited users should be entered in the text field that will appear as soon as the Custom Set option is selected. (Note that each email should begin with a new line. No punctuation marks are required.)

Sort Choices

Select Sort choices alphabetically if you want to display options in the alphabetical order.


When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Please note that the Default User Set is comprised of users form the user list where the Default Set checkbox is checked.

In case the User Property table is created, every User column includes the User Properties section. In this section you can create lookups to the information stored in the User Property table directly from the column form.

To add a lookup, click on the New button and select a column from the User Property table you want to refer.

Furthermore, if there are more than 50 users in the database user list and the User column is specified in a filter of a database object (view, trigger, button, document etc) or in e-mail notification settings (for example, in the “To” field), you should enter some letters or words to find a user you need. By default the first 50 names of users are listed in the dropdown. You may see the example in the screenshot provided below:

Next: File Attachment Columns