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.

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 All and List 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.

Next: Managing Existing Tables