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:
Setup link in the top right corner of the window.
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||In the |
|Column Name||In the |
|Column Type||From the |
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;
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.