Skip to content

Fields

Fields are the columns of a collection. Each one has a technical key (delivery_date), a visible label («Delivery date») and a type.

Type (key)In the app
text, textareaText, Long text (Texto, Texto largo)
number, currencyNumber, Currency
dateDate
select, multiselectList, Multiple list (color and icon per option)
checkboxYes/no
email, phone, urlEmail, Phone, URL
image, image_multipleImage, Images
chips, tagsFree list, Tags
location, addressLocation (map), Address
relationRelation to another collection or to users
lookupShows a field of the related record
personPerson: from a fixed list or another collection
functionValue computed with JavaScript
  1. Go to Settings → Collections (Configuración → Colecciones), pick the collection and open Fields (Campos).
  2. Add a field, choose the type and mark whether it is required and shown in the table or the form.
  3. Mark one field as the title: the readable name of the record in relations and lists.
  4. Advanced options: numbering (prefix, year and counter, e.g. COT-2026-00001), unique value (alone or combined with other fields), line rollup (sum, count, min, max or average of a line collection), dependent relations (State → City) and Use as filter (Activar como filtro).
  • Key: lowercase letters, numbers and _, starts with a letter, up to 60 characters and unique in the collection.
  • Up to 100 fields per collection and 5 filterable fields (a lookup field cannot be filtered).
  • Lists: 1 to 100 options of up to 80 characters.
  • A function field’s code has up to 5000 characters.
  • A schema deploy never deletes data or changes field types.
  • get_field_guide: types, options and exact format; with collectionId, the current fields. Read it before changing fields.
  • patch_schema_draft with add_field or update_field, then plan_schema_draft and deploy_schema_draft (see Schema and draft).
  • export_schema shows the result.