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:
Click the Setup link in the top right corner of the window.
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:
| Option | Description |
|---|---|
| Table Name | In the Table Name field enter the name of a table (Note: Always enter table names in singular, as the system changes table names to plural automatically according to English grammar rules. Singular names must be unique within a database, so make sure that there are no table name duplicates). |
| Column Name | In the Column Name field enter a text that will be used as a table headline. |
| Column Type | From the Column Type 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 you 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 a table name (in plural);
-
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(data 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 to edit this column),ID(autonumber that is used as a key column); -
A new form that will be used to add records to a table;
-
Two views:
List AllandList Changed; -
A dashboard.
When you create a new table you may add 10 columns at a time. If you want to add more please read the Creating New Columns section.