How-to
Article MarkdownReport an error

How to configure field type?

The semantic Type defines how data is stored, validated, and shown in the table and record card. Types are grouped in the editor: Basic, Contacts & links, Lists & relations, Media, System.

When you need this

  • You add a new field and need the right type.
  • You want Email, Phone, or Date & time instead of plain text.
  • You need to link tables via Table relation.

Key terms

  • Field type — choice in the field card on Fields or in Add field.
  • Managed by type «{type}» — some settings are set automatically by the type.
  • Changing an existing field type is a risky schema change — Review changes before save appears.
  • Full type list — Semantic field types reference.

Before you start

Step-by-step

  1. On Fields, click Add field or open an existing field.
  2. Open Type — types are grouped:
    • BasicText, Number, Date, Checkbox, etc.
    • Contacts & linksEmail, Phone, Link, Coordinate.
    • Lists & relationsList, API list, Table relation.
    • MediaFile, Image (URL).
    • SystemUser, Subject, Tag, etc. (see Configure system field types).
  3. Pick a type — a hint appears below.
  4. Fill Label and optionally Technical key (before the table is saved).
  5. For type-specific settings, expand:
    • ValidationRequired, Unique values, rules (Must be an email, Digits only).
    • Association — for Table relation: Table, Label field, Value field (FK).
    • Lists — for List: options; for API list — ActionJail action and List label field (see List by API (ActionJail)).
  6. Click Save at editor level — confirm Review changes before save if you changed an existing field type.

What happens next

The field gets the matching editor in the records table and card. Existing values may need manual cleanup after a type change.

How to verify

  • The cell shows the type format (e.g. clickable Email).
  • Validation triggers on bad input (Must be a valid email).
  • Association shows the linked record label, not only ID.

Other options

  • Quick add from the table — Add fieldField typeOpen full editor for association and API lists.
  • Non-standard keys — JSONcolumns_json (advanced).
Using your own AI agent?Install the open skill so your AI agent can work with current official ConnectiveOne documentation.Get the skillNeed support?Couldn’t find the answer or need help from the ConnectiveOne team? Create a request in Client Portal.Create a request