Independent fieldbook· Documentation-led researchEvidence & limitations ↗
THE INDEX / CHAPTER 01

The working
index.

Fifty pages organized around real tasks. Start with a tool, a question, or the part of the workflow you need to get right.

50 pages

CHOOSE AND PREPARE

Start here

References, selection and deployment planning.

01
Category hub

Collaborative Database Field Guide

Choose a collaborative database around your workflow, operating responsibilities and recovery needs.

02
Software profile

Baserow: Product Reference

A candidate for teams organizing shared work in structured tables. Evaluate the import path, edition and operating responsibilities before replacing an existing workspace.

03
Software profile

NocoDB: Product Reference

A spreadsheet-style platform with a self-hosted option. Start by identifying the edition, intended use and data connection your team needs.

04
Software profile

Grist: Product Reference

A spreadsheet-centered way to work with structured information. Its document model makes the distinction between a document backup and full installation recovery especially useful.

05
Selection guide

Airtable alternatives for self-hosting

Choose the database around the work you need to preserve. A familiar grid is only the starting point: your edition, data model and recovery process matter just as much.

06
Decision framework

Baserow vs NocoDB

Compare these tools against your actual data workflow, exact edition and ability to maintain it. This is a documentation-led evaluation framework; a deployment benchmark is not yet available.

07
Switching decision

Baserow vs Airtable

A self-hosted database is a change in responsibilities as well as software. Compare the workflow you already use with the edition you would actually run.

08
Deployment planning

Self-host Baserow

Prepare your Baserow deployment with a clear environment, data plan and recovery owner. This is a documentation-based guide, with official interface evidence where available; it is not an independently tested deployment.

09
Deployment planning

Self-host NocoDB

Prepare your NocoDB deployment with a clear environment, data plan and recovery owner. This is a documentation-based guide, with official interface evidence where available; it is not an independently tested deployment.

10
Practical checklist

An Airtable migration backup checklist

Before changing tools, identify the information and behavior you need to preserve. Use this checklist to plan a rehearsal; it is not a claim that a file export provides full application recovery.

PRODUCT WORKFLOWS

Baserow

Imports, relationships, access and the day-to-day work of keeping data useful.

01
Migration guide

Baserow Airtable Import: Check What Survives

Plan an Airtable-to-Baserow import, read the import report, rebuild unsupported behavior and verify the destination before cutover.

02
Workflow guide

Baserow CSV Import Without Duplicate Surprises

Map CSV fields, preserve identifiers and distinguish append from update when bringing recurring data into an existing Baserow table.

03
Workflow guide

Baserow Linked Records: Model Relationships

Build a Baserow relationship with stable identifiers, clear cardinality and checks that distinguish linked records from copied display text.

04
Workflow guide

Baserow Formulas: Validate the Business Rule

Translate a business calculation into a Baserow formula, check field references and validate edge cases before using the results operationally.

05
Technical reference

Baserow Lookup vs Rollup: Choose the Result

Distinguish displaying related values from aggregating them, then verify linked records and totals in a small Baserow example.

06
Technical reference

Baserow Database Tokens: Scope Each Integration

Choose database-token permissions for a Baserow integration and verify both allowed and denied operations without sharing account credentials.

07
Technical reference

Baserow API Pagination: Retrieve the Complete Set

Plan a complete Baserow API read with explicit pagination, stable identifiers, reconciliation and error handling instead of exporting only page one.

08
Workflow guide

Baserow Forms: Design and Verify an Intake Flow

Turn a Baserow table into a focused intake form, separate submitted fields from internal processing and check what an outside visitor can do.

09
Technical reference

Baserow Views: Separate Layout from Access

Use views to organize one Baserow table without mistaking a filter, hidden field or personal layout for an authorization boundary.

10
Workflow guide

Baserow Permissions: Build an Access Test Matrix

Translate team roles into Baserow access requirements, verify the intended edition and test allowed and denied actions with separate accounts.

11
Workflow guide

Baserow Backup and Restore: Define Recovery

Inventory a self-hosted Baserow installation, select the release-matched backup procedure and design a restoration rehearsal with explicit checks.

12
Workflow guide

Baserow Upgrade Checklist: Plan the Way Back

Prepare a version-aware Baserow upgrade with dependency checks, a recovery point, workflow acceptance tests and a realistic rollback decision.

PRODUCT WORKFLOWS

NocoDB

Imports, relationships, access and the day-to-day work of keeping data useful.

01
Technical reference

NocoDB Licensing: Match the Terms to Your Use

Understand current NocoDB licensing, distinguish internal use from providing access, and record the release and intended use before deployment.

02
Workflow guide

NocoDB Self-Hosted vs Cloud: Who Owns the Work?

Choose NocoDB hosting by operations, required features, recovery responsibility and access needs rather than assuming self-hosting removes all costs.

03
Technical reference

NocoDB Server Requirements: Plan and Verify Capacity

Distinguish official NocoDB minimums from production recommendations, then create a capacity rehearsal for your own workload and storage needs.

04
Technical reference

NocoDB Database Connections: Keep the Roles Separate

Distinguish NocoDB primary storage from external integrations and imported copies, then verify connector behavior with a separate test dataset.

05
Migration guide

NocoDB CSV Import: Preserve Types and Record Identity

Prepare a NocoDB CSV import, distinguish identifiers from display values, and validate dates, decimals and duplicates before accepting the result.

06
Workflow guide

NocoDB Links, Lookups and Rollups: Choose the Right Field

Model relationships in NocoDB, distinguish a lookup from an aggregate, and validate linked-record results with a small worked example.

07
Workflow guide

NocoDB Formulas: Validate Calculations Before Migration

Build a small NocoDB formula fixture, distinguish numbers from text and missing values, and reconcile results against explicit expected outputs.

08
Workflow guide

NocoDB Forms: Design Intake and Check Access

Plan a NocoDB intake form with a minimal field set, separate internal status from submitted data, and verify the shared experience before launch.

09
Technical reference

NocoDB API Tokens: Check Scope and Edition Limits

Distinguish NocoDB fine-grained and legacy tokens, understand Community scope limitations, and verify allowed and denied integration operations.

10
Technical reference

NocoDB API Pagination: Retrieve and Reconcile Every Page

Follow current NocoDB v3 record pagination correctly, distinguish base-list paging, and reconcile exported IDs without treating the first response as complete.

11
Workflow guide

NocoDB Backup and Restore: Define the Complete Recovery Set

Inventory NocoDB database, attachments and configuration, choose a consistent recovery point, and plan an isolated restore acceptance check.

12
Workflow guide

NocoDB Upgrades: Pin Versions and Preserve a Way Back

Prepare a NocoDB upgrade by recording storage layout, release changes and a recovery point, then verify the workflows that determine acceptance.

PRODUCT WORKFLOWS

Grist

Imports, relationships, access and the day-to-day work of keeping data useful.

01
Migration guide

Grist CSV and Excel Imports Without Silent Data Changes

Prepare CSV and Excel data for Grist, choose a merge key, inspect import previews and reconcile records before accepting an import.

02
Workflow guide

Grist Reference Columns: Link Records by Identity

Understand Grist reference columns, reference lists and display labels, with a customer/project example and checks for ambiguous matches.

03
Technical reference

Grist Formulas: Validate Calculations Before Reuse

Plan and validate Grist formula columns with Python-aware identifiers, boundary cases and a worked service-invoice calculation.

04
Workflow guide

Grist Summary Tables: Reconcile Groups and Totals

Choose meaningful group fields in Grist, distinguish sums from averages and reconcile a hypothetical project-status report.

05
Workflow guide

Grist Linked Widgets: Build a Clear Master–Detail Page

Plan Grist selection and filter links with a customer/project example, then check empty states and avoid confusing layout with security.

06
Technical reference

Grist Access Rules: Verify Who Can Read and Change Data

Plan a Grist permission matrix, distinguish filters from access controls and verify allowed and denied behavior using synthetic accounts.

07
Workflow guide

Grist Forms: Design and Verify a Submission Workflow

Build a Grist form around a clear destination table, test required fields and inspect the difference between previewing and publishing.

08
Technical reference

Grist REST API: Identify Records Before Automating Writes

Plan a Grist API integration using documented bearer authentication, table and column IDs, read-first checks and controlled update behavior.

09
Workflow guide

Grist Document Backups: Know What a .grist File Preserves

Distinguish a Grist document download from full installation recovery and plan a synthetic restore check with sharing and attachment boundaries.

10
Technical reference

Grist External Attachments: Keep Files and Records Recoverable

Understand the recovery boundary of external Grist attachments, prepare paired artifacts and reconcile files after restoring a document.

11
Technical reference

Grist Self-Hosting Storage: Inventory the Persistent State

Map Grist documents, home metadata, sessions and configured external services so an installation recovery plan covers more than one file.

12
Technical reference

Grist Authentication: Plan OIDC or SAML With an Access Check

Separate Grist sign-in from document authorization, check current edition requirements and validate identity-provider changes without guessing configuration.

ACROSS TOOLS

Migration & operations

Methods that connect the tools and the work.