Creating a New Table

The system allows you to design new tables in case you need to store and manage specific data.

To create a new table:

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

2. Select the New Table button. The system will display the New Table form:
   

Use the form fields to specify what columns this new table will have:

Table Name

Enter the name of the table.

Note: Always enter table names in the singular form, as the system automatically changes table names to plural according to English grammar rules. Singular names must be unique within a database, so ensure that there are no table name duplicates.

Column Name

Enter text that will be used as a table headline.

Column Type

From the list, select the necessary format for data stored in a column.

When finished, click Save to add a table into the system; click Cancel to discard changes.

You may also use the Suggest Columns button to speed up the process. With the help of AI, the system will suggest the common columns based on the table name and set the respective column types automatically.

After you add a new table, the system will automatically add:

• A new table tab with the table name (in plural form).

• Six system columns:

  • Created By (name of the user who created a record).
  • Date Created (date and time when a record was created).
  • Last Modified By (name of the user who was the last to modify a record).
  • Date Modified (date and time of the last modification). These four columns are maintained by the system and cannot be edited by users.
  • Record Owner (by default, the name of the user who created a record; the system allows editing this column).
  • ID (autonumber used as a key column).

• A new form that will be used to add records to a table.

• Two views: List All and List Changed.

• A dashboard.

When you create a new table, you may add 10 columns at a time. If you wish to add more, please refer to the Creating New Columns section.