> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Add extra table

> How to define extra tables in SuperOffice

You can create extra database tables to register different types of data in SuperOffice. After you create the table and [add extra fields][1] to it, you can open the table to add content.

## Steps

1. Go to **Settings and maintenance** > **System design**. Then select the **Tables** tab.

2. Click **New table**.

   ![Create extra table -screenshot][img1]

3. In the **Table properties** screen, enter data about the new table.

   * Enter a *name* to be used as the label.
   * Enter a *database table* beginning with **y\_** to identify it in the schema.
   * Optionally set other properties. Se details about the fields below.

   <Note>
     Some table properties cannot be set until you have added fields.
   </Note>

4. Click **OK** to save the new table (runs `create table y_mynewtable ...`).

5. [Add fields to your new table][1].

6. Optionally, adjust table properties such as sort order. (Click the table name in the list to enter edit mode.)

7. Click **Restart NetServer**. If Travel is activated, you will also see a message that a new Travel database must be generated.

You can now open the table in the UI to add content to it **or** populate it via the APIs.

## Table properties

| Property                        | Description                                                                                                                                                                                                                                                           |
| ------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Folder                          | To place the table in an existing folder, select a folder from the list.                                                                                                                                                                                              |
| Name                            | The UI label of the table.                                                                                                                                                                                                                                            |
| Database table                  | The database table's name can only be set during creation and **cannot be changed**. It should start with "y\_", and can only include underscores, letters (a-z), and numbers. A logical name is recommended for easy identification of the database content.         |
| Search header                   | The header used in the search screen for this table.                                                                                                                                                                                                                  |
| Header for viewing entry        | The header used when you display an entry in this table.                                                                                                                                                                                                              |
| Header for new entry            | The header used when you create a new entry in this table.                                                                                                                                                                                                            |
| Header for editing entry        | The header used when you edit an entry in this table.                                                                                                                                                                                                                 |
| Sort order                      | The column the table is sorted on. If you check **Descending**, the values are sorted in descending order. For numerical values, this means the highest value will appear at the top of the table. The table must contain fields before you can select anything here. |
| Display field                   | When data from this table is shown in another (related) table, you need to choose the field to display in that table. The table must contain fields before you can select anything here.                                                                              |
| Parent field                    | Used in connection with hierarchical tables.                                                                                                                                                                                                                          |
| Full name                       | If this is a hierarchical table, this field can specify a field that is automatically updated with the entry's full name based on the name field for this entry, and all parent entries.                                                                              |
| Hide ID field                   | If selected, the ID field will not be shown when listing entries in the table.                                                                                                                                                                                        |
| Hide the table                  | If selected, the table will not be visible from **System design** > **Tables**.                                                                                                                                                                                       |
| Enable batch webhook in Service | If selected, batch updates on this table will trigger [webhooks][2].                                                                                                                                                                                                  |

## Show table in a web panel

In SuperOffice you can create web panels that can contain table information. To set the relevant access rights, the user must belong to a role that has the functional rights **List tables** and **Edit tables**.

[1]: ./create-extra-field

[2]: /en/automation/webhook/dev/index

[img1]: /media/loc/en/custom-objects/create-extra-tables-and-fields.png


## Related topics

- [Third-party tables](/en/custom-objects/learn/extra-table.md)
- [Expander Services](/en/admin/license/expander-services.md)
- [System design](/en/ui/blogic/learn/index.md)
- [Add extra fields](/en/custom-objects/admin/create-extra-field.md)
- [Extra menus](/en/ui/blogic/learn/extra-menus/index.md)
- [extra_tables table](/en/database/tables/extra-tables.md)