Column Types
Every column has a type that determines how data is entered, stored, and displayed. Pachurros supports 15 types.
Basic types
Section titled “Basic types”Single-line text field. The default for names, titles, and short descriptions. Full-text search is available via the global search.
Long Text
Section titled “Long Text”Multi-line text field with line breaks. For longer descriptions, notes, and annotations.
Number
Section titled “Number”Numeric values — integers and decimals.
Formatting options:
- None (raw number)
- Currency (€, $, CHF, £, ¥)
- Percent
- Thousands separator
- Number of decimal places (0–5)
Checkbox
Section titled “Checkbox”Yes/No field. Displayed as a tick box. Controls checked/unchecked aggregations in the table row.
Date and optional time picker.
Date formats:
DD.MM.YYYY(European)MM/DD/YYYY(US)YYYY-MM-DD(ISO)D. MMMM YYYY(written out)- Relative (e.g. “Tomorrow”, “In 3 days”)
Date columns control the Calendar and Timeline views.
Link field. Displayed as a clickable link. Automatic protocol detection (https://).
Email address. Opens a mailto: link when clicked.
Phone number. Opens a tel: link on mobile devices.
Selection types
Section titled “Selection types”Select (Single select)
Section titled “Select (Single select)”A single choice from custom-defined options. Each option has its own color. The options of a Select field control the Kanban columns.
Creating an option: Click a Select cell → type a new value → Enter.
Multi-Select (Multiple select)
Section titled “Multi-Select (Multiple select)”Multiple options can be selected at once. Displayed as colored tags. Useful for categories, tags, and keywords.
Media & files
Section titled “Media & files”Upload one or more files or link media from the media library. Supports all common formats.
Image-specific file field. Shows a preview directly in the cell. Used as a thumbnail for the Gallery view and Storyboard.
People
Section titled “People”Assignee (Person)
Section titled “Assignee (Person)”Assign one or more workspace members (or custom people). Shows avatars. Great for responsibilities, shooting participants, and contacts.
Location
Section titled “Location”Location
Section titled “Location”Store an address or GPS coordinate. Displayed as a pin in the Map view. Supports address geocoding and manual coordinate input.
Advanced types
Section titled “Advanced types”Relation
Section titled “Relation”Link rows from another table (or the same table). Creates a bidirectional relationship.
Example: A “Shootings” table links to a “Models” table. Both sides see the connection.
→ More on relations, lookup & formula
Lookup
Section titled “Lookup”Displays values from a linked table based on a relation. Read-only — the value is pulled from the linked row.
→ More on relations, lookup & formula
Rollup
Section titled “Rollup”Aggregates values from a linked table (sum, average, count, min, max, and more).
→ More on relations, lookup & formula
Formula
Section titled “Formula”A calculated field with its own expression. Can reference other columns in the same row.
→ More on relations, lookup & formula
Changing a column type
Section titled “Changing a column type”Click the column name → Change type. Pachurros will attempt to preserve existing data when switching types.