Fields
What it is
Section titled “What it is”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, textarea | Text, Long text (Texto, Texto largo) |
number, currency | Number, Currency |
date | Date |
select, multiselect | List, Multiple list (color and icon per option) |
checkbox | Yes/no |
email, phone, url | Email, Phone, URL |
image, image_multiple | Image, Images |
chips, tags | Free list, Tags |
location, address | Location (map), Address |
relation | Relation to another collection or to users |
lookup | Shows a field of the related record |
person | Person: from a fixed list or another collection |
function | Value computed with JavaScript |
How it works
Section titled “How it works”- Go to Settings → Collections (Configuración → Colecciones), pick the collection and open Fields (Campos).
- Add a field, choose the type and mark whether it is required and shown in the table or the form.
- Mark one field as the title: the readable name of the record in relations and lists.
- 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).
Rules and limits
Section titled “Rules and limits”- 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.
For agents (MCP)
Section titled “For agents (MCP)”get_field_guide: types, options and exact format; withcollectionId, the current fields. Read it before changing fields.patch_schema_draftwithadd_fieldorupdate_field, thenplan_schema_draftanddeploy_schema_draft(see Schema and draft).export_schemashows the result.