Skip to content
Briques Docs

Column types

Every column has a type. The type decides what you can put in a cell, how it is entered, and how it looks. You pick the type when you add the column.

To add one, open a table and tap Add field. Give it a name, choose a type, and decide whether it is required.

📷 Screenshot: the Add field sheet with the type picker open.

The picker groups types into six families. Here is the whole set.

Text

  • Text — a single line. Names, titles, short labels.
  • Long text — paragraphs. Notes and descriptions. Pick the plain editor, or Markdown for headings, bold, and lists.
  • Email — an email address. Validated, and tappable to send mail.
  • URL — a web address. Validated, and tappable to open.
  • Phone — a phone number. Tappable to call.

Numbers

  • Number — whole or decimal.
  • Currency — a money value. Pick the currency (USD, INR, EUR, and more) and Briques shows the right symbol.
  • Percent — a value from 0 to 100.
  • Rating — a star rating. Set what it is out of. Five or fewer shows stars; more shows a “3 / 10” badge.
  • Duration — a length of time, in hours and minutes.

Choice

  • Select — pick one from a fixed list you define.
  • Multi-select — pick several from that list.
  • Tags — free-form chips. Like multi-select, but anyone can type a new one.
  • Checkbox — yes or no. Add a display statement like “Client is active” to show beside the box.

For Select and Multi-select, you build the option list right in the field editor: add, rename, reorder, and recolor each option. Renaming an option later updates every record that chose it, so fixing a typo never breaks your data.

Date & time

  • Date — a calendar date.
  • Time — a time of day.
  • Date & time — both together.

Date and Date & time fields can take an optional allowed range. Each side accepts a fixed date or a relative one, like Today or Today + 7 days. Use it to stop someone booking in the past, or to cap how far ahead a due date can land.

Attachments

  • Image — one or more pictures.
  • File — any file type.

For both, set how many uploads each record may hold, or leave it unlimited.

Advanced

  • Relation — link a record to records in another table. See Relationships.
  • Location — a point on a map.

Making a column required

Turn on Required and a record cannot be saved until that column has a value. Leave it off for anything optional. You can change this later without losing data.

Columns Briques manages for you

Every table already carries a few columns you cannot edit or remove. They show as locked rows so you always know what is there:

  • ID — a unique identifier for the record.
  • Created and Updated — when the record was added and last changed.
  • Created by and Updated by — who did it.

You never fill these in. Briques keeps them current on its own, and your views can show them like any other column.