Column Types
Every column has a type that determines how data is entered, stored, and displayed. Pachurros supports 30 types.
Basic Types
Section titled “Basic Types”Single-line text field. Default for names, titles, short descriptions. Full-text search via global search.
Long Text
Section titled “Long Text”Multi-line text field. Ideal for notes, descriptions, or longer passages.
Number
Section titled “Number”Numeric values — integers and decimals.
Formatting options:
- None (raw number)
- Currency (€, $, CHF, £, ¥)
- Percentage
- Thousands separator
- Decimal places (0–5)
Duration
Section titled “Duration”A time span (e.g. effort, shoot time, editing time). Stored internally in minutes — pick the display format in the column’s config panel:
- h:mm — hours and minutes (e.g.
1:30) - h:mm:ss — with seconds (e.g.
1:30:00) - Minutes — as a plain minute count (e.g.
90 min)
Enter the value in minutes; sum/average aggregations are supported.
Checkbox
Section titled “Checkbox”Yes/No field. Shown as a tick box. Drives checked/unchecked aggregations in the table footer.
Date and optional time picker.
Date formats:
DD.MM.YYYY(German)MM/DD/YYYY(US)YYYY-MM-DD(ISO)D MMMM YYYY(long form)- Relative (e.g. “Tomorrow”, “In 3 days”)
Date columns drive the Calendar and Timeline views.
Time field (no date). For pure time values like production times, briefing start, sunset.
Display formats:
HH:MM(24-hour, e.g. 14:30)H:MM(no leading zero)HH:MMwith suffixhh:MM a(12-hour with am/pm)
The time picker closes automatically when you click outside the cell.
Link field. Displayed as a clickable link. Automatic protocol detection (https://).
Email address. Displayed as a clickable mailto: link.
Phone number. Directly callable on mobile devices.
Rating
Section titled “Rating”Stars-based rating from 1 to 5 (default). Hovering over the stars shows a preview before you click. Clicking the same star count resets the rating.
Configuration options:
- Maximum number of stars (1–10)
- Symbol (star, heart, thumb, …)
Selection Types
Section titled “Selection Types”Select (Single choice)
Section titled “Select (Single choice)”One choice from a set of self-defined options. Each option has its own colour. The options of a Select field drive the Kanban columns.
Creating an option: Click a Select cell → type a new value → Enter.
Multi-Select (Multiple choice)
Section titled “Multi-Select (Multiple choice)”Multiple options selectable at once. Shown as coloured tags. Great for categories, tags, 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 thumbnail in the Gallery and Storyboard views.
QR Code
Section titled “QR Code”Automatically generates a QR code from the cell value (e.g. a URL, order or asset code). In edit mode you type the text; otherwise the QR code is shown. Also renders in shared tables and page embeds.
Action
Section titled “Action”Button
Section titled “Button”A clickable button in every row that opens a URL. In the config panel you set:
- Label — the button text (e.g. “Open”, “Call”, “Brief”)
- URL — the target, with placeholders from other columns:
{{ColumnName}}is replaced by that row’s value
Example: URL https://maps.google.com/?q={{Location}} opens the map for each row’s location. The button is read-only (no cell value of its own) and visible in shared tables.
People
Section titled “People”Assignee
Section titled “Assignee”Assign one or more workspace members (or custom people). Shows avatars. Good for responsibilities, shoot participants, contacts.
Location
Section titled “Location”Location
Section titled “Location”Store an address or GPS coordinate. Shown as a pin in the Map view. Supports address geocoding and manual coordinate entry.
Advanced Types
Section titled “Advanced Types”Relation
Section titled “Relation”Link rows from another table (or the same one). Creates a bidirectional relationship.
Example: A “Shoots” table links to a “Models” table. Both sides see the link.
→ More on Relations, Lookup & Formula
Backlink
Section titled “Backlink”Automatically shows all rows that point to this row. Created automatically in the target table when a relation is set up. Read-only.
Lookup
Section titled “Lookup”Shows 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”Calculated field with its own expression. Can access other columns in the row.
→ More on Relations, Lookup & Formula
Automatically counts how many rows are linked via a relation. Read-only.
System Types (automatically filled)
Section titled “System Types (automatically filled)”These columns are automatically populated by Pachurros and are read-only.
| Type | Contents |
|---|---|
| Autonumber | Sequential unique row number |
| Created at | Date and time of row creation |
| Created by | Name of the user who created the row |
| Modified at | Date and time of the last edit |
| Modified by | Name of the user who last edited the row |
Changing a column type
Section titled “Changing a column type”Click the column name → Change type. Pachurros tries to preserve existing data when switching types.