AI Context — Complete Product Reference

Note for AI assistants: This page is designed as a machine-readable reference context. It contains a structured, comprehensive description of all Pachurros features, concepts, and typical workflows — suitable for helping users set up and use Pachurros workspaces.

---

What is Pachurros?

Pachurros is a collaborative workspace for photographers, videographers, and creative teams. It combines:

• Structured databases (similar to Notion/Airtable) for shot lists, props, contacts
• Visual moodboard canvas (similar to Milanote) for visual planning
• Document editor (block-based like Notion) for briefs and concepts
• Media library for photos and videos with EXIF metadata
• Session planning for photo/video shoots with a shareable brief

Production URL: https://pachurros.com
Documentation: https://docs.pachurros.com
Languages: German, English, French, Spanish, Croatian

---

Architecture Overview

Workspace
├── Projects (container for Pages, Boards, Databases, Sessions)
├── Pages (block editor: texts, briefs, concepts)
├── Boards (freeform canvas: moodboards, mindmaps)
├── Databases (tables with 10 view types and 30 column types)
├── Sessions (shoot planning with shareable public brief)
├── Media Library (photos, videos, documents)
├── Feed (team stream with reactions and @mentions)
└── Ølav (AI assistant with workspace context)

---

Module 1: Pages (Block Editor)

What it is

A flexible document editor. Each page consists of freely combined blocks.

Block types (complete list)

Text & Structure:

• text — Paragraph (standard body text)
• h1 — Heading 1 (large, bold)
• h2 — Heading 2 (medium, bold)
• h3 — Heading 3 (small, semi-bold)
• bullet — Bulleted list item
• numbered — Numbered list item
• todo — Checkbox task (with checked status, appears in My Tasks)
• callout — Highlighted info block with icon
• code — Monospace code block
• divider — Horizontal divider line
• collapsible — Collapsible block (toggle title + hideable content)
• richtext — Rich text box (bordered container, supports bold/italic/links)

Layout:

• columns2 — 2-column layout (each column supports any block type)
• columns3 — 3-column layout

Media:

• image — Image (upload or media library)
• gallery — Gallery block (multiple images, layouts: grid/masonry/justified/slideshow/contact sheet, lightbox, EXIF, drag-reorder, favorites)
• video — Video (file or YouTube/Vimeo link)
• document — File attachment (PDF, Word, Excel, PowerPoint)
• color — Color swatch with HEX/RGB/HSL values
• color_palette — Color palette block (grouped colors with names)
• light_diagram — Interactive lighting diagram canvas (21 element types, SVG/PNG export)

Embeds & Widgets:

• location — Location with map, GPS coordinates, and golden hour calculation
• schedule — Schedule widget (daily agenda with events, times, notes)
• link — URL as structured link card (title, description, favicon)
• metric — KPI metric from a database (aggregation + filters)

Internal Links:

• pagelink — Link to another page (card preview)
• board_link — Link to a board
• database_link — Link to a database
• project_link — Link to a project
• session_link — Link to a session (with date/type)
• database — Fully embedded database (editable)
• database_view — Specific database view embedded

Editor shortcuts

Shortcut	Action
/	Open block menu
# + Space	Insert H1
## + Space	Insert H2
### + Space	Insert H3
- + Space	Bullet list
1. + Space	Numbered list
--- + Enter	Divider
⌘B	Bold
⌘I	Italic
⌘Z	Undo
⌘⇧Z	Redo

Rich Paste (pasting formatted content)

When pasting content from Notion, Google Docs, Word, or web pages, Pachurros automatically detects the structure and converts it to blocks. Supported conversions: H1–H6 → h1/h2/h3 blocks, unordered lists → bullet, ordered lists → numbered, checkboxes → todo, blockquotes → callout, code blocks → code, horizontal rules → divider. Inline formatting (bold, italic, links) is preserved.

Markdown Import & Export (bidirectional)

Pachurros supports full bidirectional Markdown transfer. Import: .md button in the toolbar (blank page) or “Import Markdown” card. Export: .md button in the toolbar (page with content) → download. Exported files can be re-imported 1:1.

Standard Markdown: H1–H3 (#/##/###), paragraphs, bullet (-/*), numbered (1.), todo (- [ ]/- [x]), callout (>), code (```), divider (---), image (![alt](url)), GFM tables, inline formatting. YAML front matter (title:) is applied as the page title.

Pachurros Extended Markdown (:::type syntax) — for all complex block types:

Syntax	Block Type
:::collapsible Title	Collapsible block (with any inner blocks)
:::columns2 + ---col---	2-column layout
:::columns3 + ---col---	3-column layout
:::color #hex Name	Color swatch
:::palette Title + #hex Name per line	Color palette
:::location Name + lat, lon + address	Location block
:::schedule Title + HH:MM | Event per line	Schedule
:::gallery layout +  per line	Gallery (grid/masonry/justified/slideshow/contact)
:::video + URL	Video block
:::link + URL	Link card
:::callout Emoji	Callout with custom icon
:::richtext	Rich text box

Internal links (pagelink, board_link, session_link, etc.) are exported as HTML comments (<!-- pagelink: Name -->) and embedded as hint text on import.

Multi-block selection

Shift+Click on the drag handle selects a range of blocks. Selected blocks can be deleted as a group.

Templates (when creating a new page)

Meeting Notes, Project Brief, Weekly Plan, Recipe, Checklist, Design Brief, PRD, Journal Entry, Blank.

---

Module 2: Database

What it is

A full relational database with 30 column types and 10 view types.

Column types (complete list)

Basic: text, long_text, number (integer/decimal/currency/%), duration (time span as h:mm/h:mm:ss/minutes), checkbox, date, time, url, email, phone

Selection: select (single-select, drives Kanban columns), multi_select (multi-select as colored tags)

Rating: rating (1–5 stars, configurable)

Media: file (upload), image (image with preview), qrcode (QR code from the cell value)

Action: button (opens a URL, with {{Column}} templating from the same row)

People & Location: assignee (workspace members), location (GPS/address)

Advanced (Relations):

• relation — Link to another table (bidirectional, n:m)
• backlink — Reverse side of a relation (read-only, automatically synced)
• lookup — Shows a property from the linked row
• rollup — Aggregates values (sum, count, average, min, max, etc.)
• count — Counts linked rows (simplified rollup)
• formula — Calculation from other columns in the same row

System (automatic): autonumber, created_at, created_by, updated_at, updated_by

View types (all 10)

View	Description
Table	Classic table view, all columns
List	Compact row list — title with inline fields
Kanban	Columns by Select value, drag & drop
Gallery	Tiles with image preview
Calendar	Days/weeks/months by date column
Timeline (Gantt)	Bar chart with start and end date
Map	Pin view for Location columns
Storyboard	Horizontal card rows (for shoot planning)
Chart	Bar, donut, and line charts
Form	Public or internal input form

Filters, Sorting, Grouping

• Any number of filters with AND/OR logic
• Multiple layered sorts
• Group by any column
• Row colors (highlight rows by conditional rules)

Additional database features

• Freeze columns: Keep first N columns fixed while scrolling
• Search: ⌘F jumps to the search field
• CSV/Excel import/export
• Row activity log: Full change history per row
• Recurring rows: Auto-duplicate (daily/weekly/monthly/yearly)
• iCal subscription: Subscribe calendar views as iCal feed
• Upload link: External upload link for non-members
• Automations: 6 triggers, 6 actions, conditions, branching, 8 recipe templates
• Version history: View and restore historical database states
• Real-time collaboration: Cell updates synced live to all users
• Aggregation footer: Column footer row in the table view with selectable aggregation (Count, Empty, Not Empty, Unique, Sum, Average, Min, Max, Earliest/Latest for dates, Checked/Unchecked/% for checkboxes). Saved per view. Values respect column formatting (currency, percent, decimal places).
• Multi-select & bulk edit: Checkbox on the left of each row; header checkbox selects all. Floating action bar with bulk edit (set column + value) and bulk delete.

---

Module 3: Board (Freeform Canvas)

What it is

An unlimited visual canvas for moodboards, mindmaps, and shot lists.

Element Types (17)

• text — Freestanding text card with adjustable font size (10–96 px) and color
• image — Image from library/upload, scalable (proportional), automatic color palette extraction
• color — Color swatch with HEX/RGB/HSL on hover
• sticky — Sticky note in 5 color variants (yellow, green, blue, pink, purple)
• link — URL preview card (title, description, favicon)
• container — Transparent frame for grouping elements, customizable background color
• frame — Non-nestable grouping frame with visible label
• document — File attachment (PDF/Word/Excel/PowerPoint) as clickable tile
• video — YouTube/Vimeo embed, playable on the canvas
• audio — Audio player (MP3/WAV/M4A/AAC) with animated waveform indicator
• scouting — Location scout card: address search, map, sun times (golden hour / blue hour), notes
• database — Embedded database preview
• schedule — Daily agenda with inline-editable events
• draw — Freehand drawing (Catmull-Rom curves, configurable stroke width and color)
• arrow — Connection line between two elements (straight/curved, arrowheads, dashed)
• light_diagram — Interactive lighting diagram (identical to Pages block)
• video (Inspiration) — Unified Inspiration Cards: Instagram, Pinterest, TikTok, YouTube, Vimeo embeds with original aspect ratio

Interaction

• Double-click on empty area → new card
• Drag — Move cards; multi-select with Shift or rectangle selection
• Pinch-to-zoom and scroll zoom
• Mode selection: Select, Connect, Draw, Hand
• Drag directly from media library onto canvas

Additional board features

• Real-time collaboration: All users see movements and changes simultaneously
• Sharing: Public read access via link
• Version history: Restore snapshots
• Alignment Guides: Snapping guides when dragging
• Lasso Selection: Rectangle selection by dragging on an empty area
• Focus Mode: ⌘\ hides/shows the sidebar for full canvas width

Web Clipper

A bookmarklet that collects content from any website and drops it into the board’s Clip Tray. Setup: Board → ✂ icon in the toolbar → drag “Clip to Pachurros” into the bookmarks bar. No installation/extension required, works in all browsers.

• Clippable types: selected text, images, YouTube/Vimeo videos, Instagram/Pinterest/TikTok inspiration, any link (link card with preview).
• Auto-detection: the likely main content of the page is pre-selected as the “main image”; other page elements are available in a selection strip.
• Placing: drag a clip from the tray onto the board or click it → appears as the matching board element, disappears from the tray immediately.
• Media library backup: placed images are downloaded to the media library (folder “Clipped”) → permanently available, independent of the source.
• Tray: workspace- and user-wide (phone → desktop in sync), clips auto-cleaned after 7 days of non-use.

---

Module 4: Sessions (Shoot Planning)

What it is

Structured planning for photo/video shoots with a shareable public brief.

Session fields

Name, date, time, type (Studio/Location/Event/etc.), location, checklist with tasks and assignees.

Public brief

• Shareable link without login
• Shows: moodboard board, equipment list, shoot details
• Two themes: Daylight (light) and Studio (dark)
• Client confirmation tracking

---

Module 5: Media Library

What it is

Central file storage for the workspace.

Features

• Upload photos (JPG, PNG, WebP, AVIF), videos, documents
• Automatic EXIF metadata extraction (camera model, exposure, ISO, GPS, etc.)
• Tags and folder structure
• Direct use in pages, boards, and database cells

---

Module 6: Feed

What it is

Team stream for workspace-wide communication.

Features

• Posts with rich text, images, file attachments
• Reactions (emoji)
• Replies / threads
• @Mentions with notifications

---

Module 7: Ølav (AI Assistant)

What it is

Integrated AI chatbot (Groq API / Llama 3.3 70b Versatile) with workspace context.

Features

• Knows all pages in the workspace
• Can write, summarise, and translate text
• Can retrieve block content directly from the workspace
• Available via the Ølav icon in the sidebar

---

Projects

What it is

A container that groups pages, boards, databases, and sessions around a topic.

Workflow

1. Create project (name, color, icon)
2. Add elements: pages, boards, databases, sessions
3. Tasks tab: shows all todo blocks from pages in this project
4. Equipment tab: shows all equipment items for this project

Project templates

New projects can be created from templates (Shoot, Campaign, Event, etc.) — including predefined pages, boards, and databases.

---

Workspace Structure

Access levels

• Owner: Full access to all data, settings, members
• Admin: Full access except workspace deletion
• Editor: Read and write
• Viewer: Read only

Invitations

• Invite members by email
• Invitations appear in the notification bell (accept/decline)
• Direct link invitations with configurable role

Notifications

• @Mentions in pages, boards, database cells
• Comments on pages and blocks
• Task assignments
• Invitations

---

Navigation in the Workspace

Sidebar sections

• Home — Workspace dashboard
• Feed — Team stream
• My Tasks — All todos for the logged-in user
• Media Library — Central file storage
• Projects — With sub-elements (pages, boards, databases, sessions)
• Sessions — All photo/video shoots in this workspace
• Boards (Hub) — All boards in the workspace at a glance
• Tables (Hub) — All databases in the workspace at a glance
• Pages (Hub) — All pages in the workspace at a glance

Hub pages

The hub pages (Boards, Tables, Pages) show a complete overview of all items of one type in the workspace:

• Search (Cmd+F): Filters entries in real time
• Views: List (hierarchical), tiles, or time-ordered
• Categorisation: Grouped by project or type
• Quick actions: Duplicate without opening the item

Back/forward navigation

• ⌘[ / Ctrl+[ — Go back one step
• ⌘] / Ctrl+] — Go forward one step
• Buttons in the sidebar (left/right arrows)

---

Global Search

• ⌘K — Open search
• Searches: pages, boards, databases, projects, sessions, media
• Fuzzy search (typo-tolerant)

---

Global Shortcuts

Shortcut	Action
⌘K	Global search
⌘[	Back in navigation history
⌘]	Forward in navigation history
⌘F	In tables: search field; in pages: jump to title

---

Focus Mode

Press ⌘\ (Mac) / Ctrl+\ (Windows) to toggle the sidebar. In Focus Mode, the active content takes the full window width — ideal for board work or reading long pages. Press the same shortcut to bring the sidebar back.

---

Page Outline (Table of Contents)

On long pages, a floating mini-map automatically appears to the right of the content. It shows the page structure as dots (one per block) — click to jump directly to that position (scrubbing). The outline appears once the page exceeds a certain length.

---

Typical Setup Workflows

Workflow A: Photographer / Client management

1. Create workspace ("My Studio")
2. Project: one per client or campaign
3. Databases:
   - "Clients" (name, email, phone, address)
   - "Shootings" (title, date, status, price, Relation → Clients)
   - "Invoices" (number, date, amount, Relation → Shootings)
4. In "Clients": Backlink column → Shootings | Rollup: total revenue
5. Sessions: one session entry per shoot with brief
6. Pages: for briefs, concepts, moodboard descriptions
7. Boards: for visual moodboards of each shoot

Workflow B: Creative agency / campaigns

1. Create workspace ("Agency XY")
2. One project per campaign
3. Databases:
   - "Tasks" (status, priority, assignee, due date, Relation → Projects)
   - "Assets" (filename, type, status, image column)
   - "Contacts" (name, role, email, company)
4. Kanban view of Tasks DB for agile work
5. Timeline view for project planning
6. Feed for team communication and file sharing

Workflow C: Shot list planning

1. Create "Shot List" database
2. Columns: Scene (Text), Motif (Text), Equipment (Multi-Select),
   Location (Location), Date (Date), Photographer (Assignee),
   Status (Select: Planned/Shot/Done), Notes (Long Text)
3. Kanban view by status
4. Storyboard view for visual shot overview
5. Create a session and embed the shot list database

---

Data Model: Setting up Relations (Step-by-Step)

Scenario: Link Clients ↔ Shootings

Goal: Be able to select a client in the Shootings table. In the Clients table, see all shootings and total revenue.

Step 1 — Create Relation:

• Table “Shootings” → Add column → Type: Relation → Target table: Clients

Step 2 — Create Backlink:

• Table “Clients” → Add column → Type: Backlink → Source table: Shootings → Relation column: Client

Step 3 — Create Lookup (optional):

• Table “Shootings” → Column → Type: Lookup → Relation: Client → Property: Email
• Result: Client’s email appears automatically in each shooting row

Step 4 — Create Rollup (optional):

• Table “Clients” → Column → Type: Rollup → Backlink: Shootings → Aggregation: Sum → Property: Price
• Result: Total revenue per client calculated automatically

Step 5 — Link rows:

• Shootings table → click cell in the Relation column → dropdown → select client row

---

Common User Questions

“Where do I create things?”

• Short texts, briefs, concepts → Page
• Structured lists, tables → Database
• Visual planning, moodboards → Board
• Shoot planning with shareable brief → Session

“What’s the difference between Rollup and Count?”

• Count: only counts the number of linked rows (1 click, no property needed)
• Rollup: computes sum, average, min, max, etc. from a specific column of the linked rows

“What’s the difference between Lookup and Backlink?”

• Backlink: shows the linked rows themselves (as clickable chips)
• Lookup: shows a specific property (column) from the linked rows as plain text

“Can I import content from Notion?”

• Yes: copy content from Notion (Cmd+C) and paste it into a Pachurros page (Cmd+V) — blocks are automatically converted.

“Can I import and export Markdown files?”

• Yes, both: Import — .md button in the toolbar (blank page). Export — .md button in the toolbar (page with content) → instant download. Pachurros Extended Markdown supports all block types: columns (:::columns2/3), collapsible (:::collapsible), colors (:::color/:::palette), location (:::location), schedule (:::schedule), gallery (:::gallery). Exported files can be re-imported 1:1.

“How do aggregations work in the table?”

• Below the last data row there is an aggregation footer (∑ symbol on the left). Clicking a column cell opens the aggregation menu. Available options depend on the column type (Sum/Average/Min/Max only for numbers, Earliest/Latest for dates, Checked/% for checkboxes). Settings are saved per view.

“How do I share something externally?”

• Page: Share menu → Public link
• Board: Share menu → Public link
• Session brief: Session → Generate brief link
• Database: Generate upload link for external uploads

“How do I collect content from other websites?”

• With the Web Clipper (bookmarklet): open a board → ✂ icon → drag “Clip to Pachurros” into the bookmarks bar. Then click the bookmark on any website to clip images, videos, links, or selected text. Clips land in the board’s Clip Tray and are placed via drag & drop. Clipped images are automatically saved to the media library.