Overview | Installation | Credentials and Authentication | Create a Personal Access Token | Supplying your token | Setting a default base | Checking access | Finding your workspace ID | API Limitations | Monthly call quota | No API deletion of bases, tables, or fields on free tier | Checkbox fields | Computed and read-only fields | Walkthrough | Step 1 — Setup | Step 2 — Create a demo base | Step 3 — Read records | Step 4 — Write records | Step 5 — Upsert and sync | Step 6 — Join local data with an Airtable table | Step 7 — Attachments | Step 8 — Special types | Step 9 — Schema and metadata | Step 10 — Backup and restore | Step 11 — Monitor API usage | Step 12 — Teardown | Further resources

Overview | Schema inspection with air_schema() | Self-documenting bases with air_meta() | Pushing changes with air_meta_push() | Making a base self-documenting with air_meta_sync() | Full backup with air_dump() | Parameters | Output structure (JSON format) | What is included | What is NOT included | Restoring with air_restore() | What works | Restore limitations | Backup/restore workflow example | Re-linking after restore (advanced)

Overview | 1. Multi-select fields (air_multiselect) | Flattening to a character vector | Expanding back to a list-column | Round-tripping through write | 2. Linked records (air_links) | Flattening links | Joining to resolve linked records | Re-linking records after a restore | 3. Attachments (air_attachments) | Flattening attachment metadata | Downloading attachments with air_read_attachments() | Parallel downloads | Uploading attachments with air_write_attachments() | Diff-based sync with air_sync_attachments() | Stable preview URLs and the temporary-URL caveat | 4. Collaborator fields (air_collaborator / air_collaborators) | Flattening collaborators | Expanding strings back to collaborator list-columns | 5. Barcode fields (air_barcode) | 6. air_simplify() — the kitchen-sink flattener | When to use air_simplify() vs. the type-specific flatteners | See also

Introduction | Connecting | Exploring the connection | Reading data | Writing data | Multi-base mode | Limitations

Install | Connect | First query | Filter on the partition columns | When to use collect() | Inspect tables and columns | Disconnect | Where to next

Attaching multiple snapshots | Adding / removing snapshots at runtime | Cross-snapshot diff | Caveat: snapshots are not strictly additive | Worked examples: detecting specific kinds of revision | Backfills into a closed fiscal year | End-date revisions (no-cost extensions, early terminations) | Validating time-travel consistency | Disconnect

Basic usage | Schema-qualified queries across snapshots | Quoting digit-leading identifiers | Parameterised values | When to stay in dplyr