> ## 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 fields
> How to define extra fields in SuperOffice
After you create an [extra table][1], you must set up fields in the table, to allow you to subsequently input data (entries). You can also create extra fields in standard tables.
## Steps
1. Go to **Settings and maintenance** > **System design**. Then select the **Tables** tab.
2. Browse to your desired table, point at the table name, and click **New field**.
![Create extra field -screenshot][img1]
3. Select a type for the new field and click **OK**.
4. In the **Field properties** screen, enter data about the new field.
* Enter a *name* to be used as the label.
* Enter a *database field* beginning with **x\_** to identify the field in the schema.
* Optionally set other properties. The type (specified in step 3) determines what is available. Se details about the fields below.
To make a field mandatory, select **Cannot be empty**.
5. Click **OK** to save the new field (runs `alter table y_mynewtable add column x_mynewfield ...`).
6. Continue adding more fields.
7. Click **Restart NetServer** when you are done. If Travel is activated, you will also see a message that a new Travel database must be generated.
## Field properties
| Property | Description |
| ------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Cannot be empty | Makes it mandatory to fill in this field. |
| Choose from list box | If the field is connected to an extra table, select this option to display a list of table values. |
| Choose values from list | If checked, the field turns into a list box. The list options are the text strings inputted in the text box, with one option per line. |
| Create index | If selected, it is possible to search by this field. It is quicker to search for data in indexed fields. |
| Database field | The column's name in the database must be unique within the table. It should be a single word, containing only underscores, letters (a-z), or numbers, and must start with "x\_". This can only be set during creation and and **cannot be changed**. |
| Decimal places | The number of decimal places that are allowed in a number. |
| Default value | The value to be inserted by default in this field. |
| Description | The default description. |
| Display value | Whether to display the field's value. |
| External | If checked, the field is available from a customer centre. Relevant only for standard tables (extra tables are always displayed in customer centres). |
| Header for list | A header for these entries when they are displayed as "sub-entries" in a list. |
| Hide function buttons | (relations) Select this option to hide the function for adding new entries to relation tables. |
| Hide the field | Whether to display the field. |
| Keep HTML tags | (text) Select this option to include the HTML tag in the text. |
| Name | The name of the field. |
| Number of units | (time span) The maximum number of units for the "largest" selected time unit. Example: If you selected hours and minutes, and enter "4", a maximum of 4 hours can be selected, while minutes go to 60. Similarly for days and hours, a maximum of 4 days can be selected, while hours go to 24. |
| Only allow leaf nodes for hierarchical list boxes | (extra table relation) Specify if only the lowest node in a hierarchy can be selected by the user. |
| Position | Specifies this field's position among the other fields in lists. |
| Search operator | Which search operator to use for this field. |
| Show in table | If checked, this field is displayed as a column in screens where several entries are displayed in a table. |
| Show one-to-many relations | If you selected the **Contact relation**, **Company relation** or **Request relation** field types and want to display a tab containing data from this table in the contact, company, or request screens, you can check this field. |
| Table | The table this field belongs to. |
| Target table | Which table to use. |
| Text area / Height | The number of lines of the text field. |
| Type | Displays the field type you selected. |
| Update null values now | Check this option to replace all null values (empty fields) in the database with the default value. **This operation can take a while.** |
| URL | The URL of the dynamic link here. |
| Use active user as default value | If checked, the field's value is by default set to the current user. |
| Use current date/time as default value | If checked, the field's value is by default set to the current date/time. |
| Use days / Use hours / Use minutes | The time unit for the time span field. |
| Use default value | If checked, the field is assigned a default value unless otherwise specified. |
| View in relational choosers | If the current table has a relation with another table (extra table relation), select this option to make this field available as a search field. Example: You created an extra table called "Products" with an extra table relation to the **Requests** table. In this way you can search for and add products in the **Extra fields** tab when creating new requests. By selecting **View in relational choosers** for specific fields in the "Products" table, these fields are available as search fields in the **Extra fields** tab. |
## Add relation (foreign key, FK)
1. Click **New field**.
2. Select the relation type for the entity you want to connect to and click **OK**.
3. Set field properties as described above.
Available from version 10.3.4 in pilot: Selecting **Show one-to-many relations** adds a section tab (archive) to related standard entities.
4. Click **OK** to save the relation.
5. Click **Restart NetServer** to apply the changes.
For example, to connect all incoming requests to a specific sale, you can add an extra field of type sale relation to requests ([ticket table][4]). To list connected requests when viewing a sale in SuperOffice CRM, you will need to build a web panel.
[1]: ./create-extra-table
[4]: /en/database/tables/ticket
[img1]: /media/loc/en/custom-objects/create-extra-tables-and-fields.png
## Related topics
- [Add extra table](/en/custom-objects/admin/create-extra-table.md)
- [Third-party tables](/en/custom-objects/learn/extra-table.md)
- [The More tab](/en/custom-objects/learn/more-tab.md)
- [Working with custom objects and fields in API](/en/custom-objects/reference/index.md)
- [Extra fields](/en/custom-objects/learn/extra-field.md)
- [Add navigator group and extra menu](/en/ui/blogic/learn/extra-menus/navigator.md)