Add extra table

You can create extra database tables to register different types of data in SuperOffice. After you create the table and add extra fields 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.
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.
   Some table properties cannot be set until you have added fields.
4. Click OK to save the new table (runs create table y_mynewtable ...).
5. Add fields to your new table.
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

​

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.