User Table

This table is used to store information about the application’s users. When a user logs into the application, their information is stored in memory. The information of who is logged into the system can be very useful for creating workflows. In the example below, the user named (Jacob A. Smith) is logged into the system. When adding a new record, its name is automatically loaded in the field (Owner) through a workflow associated with the button (New). In this case, the field (Owner) is a drop-down list and the data source is the table (User Table).

Example of initializing a drop-down list field through the workflow

You can create multiple workflows from a drop-down list that uses the table (User Table) as a data source. For example, allow editing the record only when the logged in user is the same as the one in the field, in this case (Owner).

*Whenever it is necessary to add the name of people to an interface and that name is related to the users logged into the system, it is recommended to create a drop-down list field having the table (User Table) as a data source.

*The topic (Users) covers information about the users screen.

Below is an example of how to create a drop-down list having the table (User Table) as the data source.

Example of how to create a drop-down list field using the table (User Table) as a data source

In this example, the fields users_ID and users_full_name were selected. The users_ID field is the primary key (identified by the * symbol). It is the content of this field that will be stored in the table in which the drop-down list will be a part. However, it is the contents of the users_full_name field that will be visible in the drop-down list.