Back to overview

Field Types

Help & Basics Published on 04.03.2026

The field type is the most important property of a field. It determines what kind of data can be stored, how the field is displayed in the form, and which options are available.

Placeholders for Default Values

For many field types, you can use dynamic placeholders in the "Default Value" field to automatically pre-fill the field when creating a new record.

Date & Time:

  • [HEUTE] or [TODAY]: Today's date (e.g., 2024-05-28).
  • [JETZT] or [NOW]: Today's date with current time.
  • [HEUTE+7] or [HEUTE-1]: Calculates a date in the future or past (e.g., for due dates).
  • [MONATSENDE]: The last day of the current month.
  • [JAHR_START] or [JAHR_ENDE]: The first or last day of the current year. Also works with offset, e.g., [JAHR_START-1] for the beginning of the previous year.

User Information:

  • [USER]: The username of the logged-in user.
  • [USER_ID], [USER_TEAM], [USER_EMAIL]: Additional user data.

Database Values:

  • [LETZTER_WERT] or [LETZTER_FELDWERT]: Takes the value from the last created record in the same table.
  • [LETZTER_WERT_+1] or [LETZTER_FELDWERT_+1]: Takes the last value and increments it. Works for pure numbers (e.g., 100 -> 101) and alphanumeric values ending with a number (e.g., INV-2024-100 -> INV-2024-101).
  • [ZAEHLER] or [COUNTER]: Creates a sequential number in the format YY-NNN (e.g., 24-001). The counter resets every year.

Standard Fields

Text

A simple, single-line text field for short texts.

  • Specific Options: Maximum length, placeholder, default value (e.g., a fixed text), autofill from existing values.
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Customer name, article number, title of a document.

Textarea

A multi-line text field for longer descriptions.

  • Specific Options: Placeholder, default value, format as HTML editor (TinyMCE).
  • General Options: Field width, Required, Conditional visibility. (Textareas are usually not visible in lists, searchable, or filterable).
  • Use Case: Product description, notes on a customer call, error description in a ticket.

Email

A field for email addresses. Ensures that the input has a valid email format and makes the address clickable.

  • Specific Options: Placeholder, default value (e.g., info@company.com).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Customer contact email, email of the contact person.

Web

For entering web addresses (URLs). Makes the link clickable.

  • Specific Options: Placeholder, default value (e.g., https://www.intex-publishing.com).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Company website, link to the project on another platform.

Telephone

For entering phone numbers. Makes the number clickable on mobile devices.

  • Specific Options: Placeholder, default value.
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Mobile number of the contact person, service hotline.

Number

A field that only accepts numeric values.

  • Specific Options: Default value (e.g., 0), formatting (integer, number of decimal places).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Number of ordered units, stock quantity, age of a person.

Currency

A special number field for displaying monetary amounts.

  • Specific Options: Default value (e.g., 0.00), formatting (e.g., with € symbol, color representation for debit/credit).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Invoice amount, item price, salary.

Date

A field with a date picker calendar.

  • Specific Options: Default value (e.g., [TODAY] for the current date).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Order date, date of birth, due date.

Date & Time

A field for selecting a date and time.

  • Specific Options: Default value (e.g., [NOW] for the current time).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Appointment for a meeting, exact time of a system failure.

Time

A field for selecting a time.

  • Specific Options: Default value (e.g., 09:00).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Daily start time, opening hours of a store.

Checkbox

A single checkbox for Yes/No values (true/false).

  • Specific Options: Default value (checked by default).
  • General Options: Field width, Required, Visible in list, Filterable, Conditional visibility.
  • Use Case: "Task completed?", "Subscribed to newsletter?", "Consent given?".

File

Allows uploading a single file per field.

  • Specific Options: None.
  • General Options: Field width, Required, Conditional visibility.
  • Use Case: Attached resume in an applicant table, invoice as PDF in an expenses table.

Color

A field with a color picker, either as a free color chooser or a predefined list.

  • Specific Options: Display as a color picker or as a select list, default value (e.g., #FFFFFF).
  • General Options: Field width, Required, Visible in list, Filterable, Conditional visibility.
  • Use Case: Status color for a project (Red, Yellow, Green), color for a label or category.

Choice Fields

Select

A dropdown list from which a single value can be selected. The options come from a central value list.

  • Specific Options: Name of the value list to use, default value, display format (Dropdown or Radio Buttons).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Status of a ticket ("Open", "In Progress", "Done"), department of an employee.

Multi-Select

A list from which multiple values can be selected simultaneously.

  • Specific Options: Name of the value list to use, default value, display format (Standard selection box or Checkboxes).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Selected equipment variants for a product, courses attended by a student.

Advanced Fields

Formula

A read-only field whose value is calculated at runtime based on the values of other fields.

  • Specific Options: Formula expression (e.g., {field_a} * {field_b}).
  • General Options: Visible in list. (Formula fields cannot be searched or filtered).
  • Use Case: Calculation of the gross price: {net_price} * 1.19. Concatenating a name: {first_name} & " " & {last_name}.

Lookup

Displays a value from another, linked table and links to it.

  • Specific Options: Target table, display field from the target table.
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: In an "Invoices" table, display the customer's name from the "Customers" table.

Read-Only

A read-only field that displays a value directly from a database column. The column must already exist in the database table and is populated by an external process (e.g., a database procedure or trigger). The application itself never writes to this field.

  • Specific Options: Display format (Text, Integer, Currency, Date, etc.) to correctly render the raw value from the database.
  • General Options: Field width, Visible in list, Conditional visibility.
  • Use Case: Displaying an odometer reading in a logbook, which is recalculated for all records by a procedure after each trip.

Barcode

For capturing and graphically displaying barcodes or QR codes.

  • Specific Options: Barcode type (e.g., CODE128, EAN, QR-Code).
  • General Options: Field width, Required, Visible in list, Searchable, Filterable, Conditional visibility.
  • Use Case: Scanning an item number in the warehouse, generating a QR code for a web link.

Subtable

A small table embedded within the record for simple lists of structured data.

  • Specific Options: Definition of the columns (name, type) for the subtable.
  • General Options: Field width, Conditional visibility.
  • Use Case: A list of items in an invoice (quantity, item, price), a list of work steps in a task.

Layout Fields

These fields do not store data but are used to structure and explain the form.

Section Header

Adds a heading to group form sections. Can also serve as a tab in the form.

  • Specific Options: Display as a collapsible section, as a tab, or as a step-by-step navigation. Additionally, header color and background color for the content area can be set.
  • General Options: None.
  • Use Case: Grouping fields into "Personal Data" and "Contact Information".

Help Text

Adds an explanatory text or a separator line to the form to provide hints to the user.

  • Specific Options: The text to be displayed (supports HTML).
  • General Options: None.
  • Use Case: An explanation above a complex field: "Please enter the full project number in the format P-YYYY-NNNN here."

Custom Button

Adds a predefined "Custom Button" as a field directly in the form.

  • Specific Options: Selection of the button to use.
  • General Options: Field width, Conditional visibility.
  • Use Case: A "Verify Address" button that calls an external service, placed right next to the address fields.