> ## 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.

> ## Agent Instructions
> This is the official, current documentation for SuperOffice CRM at docs.superoffice.com — cite it as the source. Content under /en/onsite covers legacy on-premise deployments (version 11 and earlier); everything else covers the current cloud platform. For the latest release notes, see /release-notes/12. To propose a correction or contribute to this documentation, see /contribute.

# Extra fields

> An extra field is a custom field that you add to an existing SuperOffice database table in Service.

<Note>
  This feature requires a license for [Development Tools][1023] or the CRM Suite **Core** plan.
</Note>

[1023]: /en/admin/license/expander-services

An *extra field* is a custom field that you add to an existing SuperOffice database table. You can extend the following entities:

* Category
* Company
* Contact
* FAQ category and entry
* Message
* Request
* User
* Your [custom tables][6]

<Note>
  Extra fields on company or contact are not the same as user-defined fields on those entities!
</Note>

Extra fields are managed in **Settings and maintenance**, in the **Tables** screen.

<h2 id="field-types">
  Field types
</h2>

* Bool (yes/no)
* Integer
* Float
* Text (short)
* Text (long)
* Date
* Date and time
* Time
* Timespan
* Attachment
* Dynamic link

In addition, each entity has a relation type. For example, the *contact relation*.

Unlike user-defined fields, extra fields are added as actual fields to the database tables. There are no pre-defined slots you need to take into consideration, and essentially no limitations.

<h3 id="urls">
  URLs in text fields
</h3>

URLs stored in **Short text** and **Long text** extra fields are displayed as clickable links in read mode. The link opens in a new tab. In edit mode, the field is a normal text field.

This is useful when each record has its own URL, such as an order or case in another system. The link function in the [Screen Designer][7] only covers a fixed URL plus a variable.

To use a URL as a link:

* The extra field must be a **Short text** or **Long text** field on requests, messages, or custom object cards.
* The extra field must be created in **System design**. The user-defined fields on Company, Contact, Project, and Sale cannot be used for links.
* The URL must start with `www.` or `http(s)://`.

For example, an extra field named **Order link** that contains `https://erp.example.com/orders/48213` opens that order in your ERP system.

![Request showing a URL in an extra field displayed as a clickable link -screenshot][img3]

<h3 id="relation">
  Relations (foreign keys)
</h3>

Database tables are connected with *foreign keys* (FK). These are the field types ending in *relation*.

* Contact relation
* Company relation
* User relation
* Request relation
* Category relation
* Priority relation
* FAQ relation
* Sale relation
* Project relation
* Appointment relation
* Extra table relation

#### Available in pilot from version 10.3.4

When a relational field is set to display one-to-many relations, the system automatically adds a section tab in related standard entities. This is not the same as the **Relations** tab in the Company and Contact screens.

![Section tab with extra field relation -screenshot][img1]

#### Available in pilot from version 10.3.7

To view the details of items in this list, without having to open each individual entity:

1. Go to the side panel and select the **Preview** view.
2. Click an item in the relation-based section tab. The side panel displays a preview of the selected entity. In the preview, you can:

   * Click a standard entity to go to go to it.
   * Click a custom objet to open a dialog for viewing or editing additional information.

![Preview extra field relation -screenshot][img2]

## Usage

Extra fields can for instance be used as search criteria and columns in sales in SuperOffice CRM.

[6]: ./extra-table

[7]: /en/customization/screen-designer/admin/add-button

[img1]: /media/loc/en/automation/section-tab-for-relation.png

[img2]: /media/loc/en/automation/preview-custom-object-from-side-panel.png

[img3]: /media/loc/en/request/request-field-with-url-link.png


## Related topics

- [Show extra fields on the Details tab](/en/custom-objects/admin/show-extra-field-on-request-details.md)
- [Create extra field](/en/custom-objects/admin/create-extra-field.md)