Field types

Each object in your database has a set of fields. The field type defines what kind of data it can store and how it appears in forms, grids, and detail views. Choosing the right type once saves validation work later and keeps imports, APIs, and tasks consistent.

Built-in types

Type	Example	Description
Textual
Text	John Smith	One-line text field — names or other short strings. Optional Min length (chars).
Long Text	This is example text. Second line!	Multiple lines — longer paragraphs
E-mail	john@example.com	Single e-mail address
Multiple E-mail	a@x.com, b@y.com	Several e-mail addresses on one field (useful for CC lists or multi-contact records)
Password	xkjsd8.w/	Stored encrypted; enables the object for user authentication
URL/Link	https://example.com	Website link
IP (v4)	192.168.10.10	IPv4 address
Choice	- Individual - Company	One value from a list (dropdown or radio buttons). Optional colour per value.
Multiple choice	Tag 1 Tag 2 Tag 3	Several values from a list (combo box or checkboxes). Optional Min items / Max items. Optional colour per value.
Numeric
Number	42	Integers or decimals. Max decimals is the storage scale: values are rounded to that many places on every write (forms, tasks, API, import, auto fields), not only when displayed. Min decimals only pads for display.
Rating	⭐️⭐️⭐️	Rating in stars
Files/images
File		File upload (any type). Tasks can store a SHA-256 hash of a file into a text field when you need integrity checks. On grids and detail widgets, Open as can show PDFs in a modal or side pane (non-PDFs still download). Forms can also Browse SharePoint when that integration is enabled.
Image		Image (JPG, GIF, PNG)
Date/time
Date	2023-01-01	Date in YYYY-MM-DD format
Time	18:43:22	Time in HH:mm:ss format (no time zone)
Date and Time	2023-01-01 18:43:22	Date/time in YYYY-MM-DD HH:mm:ss format (no time zone)
Other
Yes/no	true	Boolean
GPS Point	41.900888,12.478671	Lat/lon coordinates (map pin)

Choice and Multiple Choice colours

On a Choice or Multiple Choice field, each permitted value can have an optional colour (#RRGGBB). Set it next to the value in the field definition (colour picker).

When the field is shown in grids, detail views, and similar readouts, that colour is applied to the value text. Index badge chips use it as the chip background. Colours are part of the field definition — they are not configured per widget display rule.

Link to another object (Reference)

Create a field that links to one record of another object. For example, a Car object can link to a Manufacturer. That connection powers filters, auto fields, related tasks, and navigation between pages.

Useful options:

• Display field — which field of the linked object to show in forms, grids, and detail views (defaults to the object's record name / id)
• Sort by — which field of the linked object to order candidates by in dropdowns and user filters, with ascending or descending direction

Multiple links to another object (Reference Array)

Multiple links to another object (Reference Array) stores many-to-many style relationships: one record can link to several records of another object without an intermediate join table you have to manage yourself.

Typical scenarios:

• a project linked to several team members;
• an article tagged with multiple topics stored as objects;
• an order associated with several related documents.

Options include:

• Display field — which field to show for each linked record
• Display items as — Badges or Bullet points in grids and detail views
• Min items / Max items — constrain how many links are required or allowed
• Form input — Dropdown menu with autocomplete or Checkboxes

Reference Arrays appear in grids and detail views like other columns, so operators can see the full set of links at a glance.

For app-wide configuration that should exist only once, see Global objects. For when to choose Reference vs Reference Array vs a join object, see Data modeling.

Uniqueness

On a field’s Definition tab, enable Unique so no two records may share the same value for that field (or combination of fields). Empty values are skipped — uniqueness is only checked when the relevant fields are filled.

When Unique is on, choose:

• this field alone — e.g. each e-mail address may appear only once
• along with — pick partner fields to form a composite key (e.g. code unique along with year, so the same code may exist in different years)

An object can have several independent constraints. For example, mark email unique alone, and separately mark code unique along with year. Each field belongs to at most one combination; when you add partners, Bobuild mirrors the group on every member.

Use cases:

• login identity — for e-mail + password, the e-mail field must be unique alone
• natural keys such as invoice number + fiscal year
• create tasks that skip a duplicate and reuse the existing row when any uniqueness group would fail

For uniqueness that spans alternative fields (one or the other), use a form validation task instead of a Unique constraint.