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:
Setuplink in the top right corner of the window.
New Tablebutton. The system will display the
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.
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.