Client Onboarding in Airtable: Build a Tracker (and When to Outgrow It)

TLDR: Airtable is a real step up from a spreadsheet for the internal side of client onboarding. Build three linked tables (Clients, Tasks, and Documents), add single-select statuses, a rollup for percent complete, Kanban and filtered views, an intake form, and an automation for reminders. Where it still falls short is the client-facing half: there is no single magic-link portal, form attachments are a weak way to collect sensitive files, and giving each client a private, guided view means paid Interface seats and manual setup. Most service businesses run an Airtable base happily until roughly five to eight new clients a month, then move to purpose-built onboarding software.

Airtable is where a lot of service businesses land after a spreadsheet stops keeping up with client onboarding. It makes sense. Airtable looks like a spreadsheet, so the learning curve is gentle, but it works like a database, so it fixes the two things that break a sheet fastest: real relationships between records and views that reshape the same data for different jobs. For the internal half of onboarding, an Airtable client onboarding template is a genuine upgrade.

This guide gives you the actual base to build, the specific fields, formulas, views, form, and automation to copy, a starter checklist of what the tracker should contain, and an honest map of where Airtable stops being the right tool. You will know exactly what to build and exactly when to switch.

Why Airtable beats a plain spreadsheet for onboarding

Before you build anything, it helps to name what Airtable actually fixes, because it also tells you where the remaining cracks will be.

• Linked records instead of name matching. In a spreadsheet you join tabs by typing a client name identically in two places and hoping. In Airtable, a Task record links to a Client record, so the relationship is real. Rename a client once and everything updates.
• Views reshape the same data. One table can be a grid for editing, a Kanban board for status, a calendar for due dates, and a filtered view that shows one client. You are not copying data to see it a different way.
• Rollups and lookups do real math across tables. A rollup on the Clients table can count finished tasks living in the Tasks table, which is how you get true percent complete without brittle formulas.
• Forms and automations are built in. Airtable Forms collect intake into a table directly, and Automations can email a reminder when a task goes overdue.

Every one of those is a real improvement over a sheet. The catch is the same catch a spreadsheet has, just pushed further out: all four describe the internal experience. Client onboarding has a second half, the client-facing half, and Airtable was designed as an internal database, not a client portal. Hold that thought. First, let’s build the part Airtable does well.

How to build a client onboarding tracker in Airtable

A good onboarding base is three linked tables and a handful of well-chosen fields. That is the whole architecture. Here is how the pieces fit together.

Step 1: Build the Clients table

Create a table called Clients with one record per client. Useful fields: client name (the primary field), main contact, email, engagement type (single select: project or retainer), start date, onboarding status (single select: Not started, In progress, Done), and a percent-complete field you will add as a rollup in Step 5. This is your command center. Every client’s status should be readable at a glance from this one table.

Step 2: Build the Tasks table with a linked field

Create a Tasks table. Each record is one task for one client. Fields: a Client field of type Link to another record pointing at the Clients table, plus Task, Owner (a collaborator or single select), Status, Due date, and a “Who” single select marking whether the task is on you or the client. The linked Client field is the whole point of using Airtable over a sheet. There is no retyping names and no broken join. Pick the client once from a dropdown and the relationship is real in both directions.

Step 3: Use single-select fields for status

On both the Tasks and Documents tables, make Status a single select field, not free text. For tasks, use Not started, In progress, Blocked, and Done, and give each a color. Single selects stop the “done” vs “complete” vs “finished” mess that quietly breaks every rollup and view filter you build later. Consistent status values are the foundation of a tracker that actually adds up.

Step 4: Build the Documents table

Create a Documents table, one record per file you need: signed agreement, W-9, ID, brand assets, platform access, and so on. Fields: a linked Client field, File (an attachment field), Status (single select: Requested, Received, Approved), and a “Received on” date. This is how you replace “did they send the logo yet?” with a view you can scan. It is also, as you will see below, the table that exposes the biggest weakness of running onboarding in Airtable.

Step 5: Add a rollup for percent complete

This is where a database becomes a tracker. On the Clients table, add a rollup field that looks at the linked Tasks and computes progress. Set the linked field to Tasks, the field to roll up to Status, and use an aggregation formula that counts Done against the total:

ROUND(COUNTALL(values) > 0, 2) gets you started, but the clean version uses two rollups: one counting all linked tasks and one counting Done tasks, then a formula field dividing them. In a single rollup you can also use:

ARRAYCOMPACT(FILTER(values, CONCATENATE(values) = "Done"))

Most teams find it simplest to create two rollups (total tasks and done tasks) and one formula field: IF({Total Tasks} = 0, 0, {Done Tasks} / {Total Tasks}), formatted as a percent. That reads: of all tasks belonging to this client, what share are Done. Now you have a live progress bar per client. If you want a deeper, tool-agnostic view of what to measure, the guide on client onboarding progress tracking goes further.

Step 6: Build the views that make it scannable

One table, several views, each for a different job:

• A grouped grid on the Tasks table, grouped by Client, so you can edit fast and see everything.
• A Kanban on the Tasks table by Status, so work moves left to right as it gets done.
• A calendar on Due date, so nothing overdue hides.
• Filtered views per client (filter where Client is X), so you can pull up one engagement cleanly. This is also the closest Airtable gets to a per-client view, and Step 8 covers why that is not the same as a client portal.

Step 7: Add an intake form

Use Airtable Forms to collect the client’s business details, goals, key contacts, and preferences straight into a table. Send the form link after signing and the responses land as records automatically. This covers the questionnaire side of intake well. For what to actually ask, the new client onboarding questionnaire template gives you a starting set of questions.

Step 8: Automate one reminder

Use Automations to reduce manual chasing. A practical first automation: when a Task’s Due date passes and Status is not Done, send an email. You can send it to yourself (reliable) or attempt to send it to the client (possible, but this is where Airtable starts straining, since it has no concept of a single client-facing portal to send them to). Start with an internal nudge so nothing slips, then read the limits section before you lean on Airtable to chase clients for you.

What your onboarding tracker should contain

Structure is empty until you fill it with the right steps. Use this as your starting checklist for the Tasks and Documents tables. It maps to the phases most service businesses actually run.

If you want a tool-agnostic version you can adapt, the client onboarding checklist for service businesses covers each of these phases in more depth.

Where Airtable stops being the right tool

Here is the part most template roundups skip. Airtable is excellent at the internal half of onboarding, tracking and organizing what needs to happen, and still weak at the client-facing half, actually getting clients to do their part smoothly and safely. Airtable fixed the spreadsheet’s internal problems. It did not turn into a client portal, because that was never what it was built to be.

Three specific breakdowns show up for almost everyone:

There is no single client portal. A client does not get one link that opens a clean, guided view of only their tasks and documents in order. The closest Airtable offers is a filtered view or an Interface, both of which take setup per client and, for a private per-client experience, paid seats. So instead of one place, the client juggles a form link, maybe a shared view, and your emails. The whole promise of a portal is one door, and Airtable has many.

Document collection is a soft spot. Airtable Forms can accept attachments, which feels like a solution until you look closely. There is no per-client required-file logic, no expiring or revocable per-file link, and no clean audit trail of who uploaded what and when. Sensitive files like tax IDs and financial records flowing through a form into an attachment field is a security posture you probably do not want. For that specific problem, see how to collect documents from clients securely.

Reminders still mostly land on you. Automations can flag your overdue records and email you reliably. Automatically and politely nudging a client about the three things they still owe, in a way tied to their own portal progress, is not what Airtable was built for. So the follow-up drifts back to manual, which is the exact chore the base was supposed to reduce. If chasing is your main pain, stop chasing clients for documents covers how to automate it away.

Airtable vs purpose-built onboarding software

The pattern is clear. Airtable wins on internal structure and flexibility, and it beats a spreadsheet decisively there. Purpose-built tools win on everything that touches the client. Which side matters more depends entirely on volume.

When to graduate from an Airtable base

You do not need to abandon Airtable the day you build it. Because Airtable is more capable than a spreadsheet, the tipping point comes a little later, usually somewhere between five and eight new clients a month. The right move is to run the base until the client-facing manual work outweighs the flexibility. Watch for these signals:

• You are sending manual follow-up emails because there is no client portal to nudge people through.
• Documents arrive through forms with no required-file logic, and you rebuild a complete set by hand.
• You duplicate the base or rebuild filtered views and forms for every new engagement.
• You are paying for Interface seats mostly to give clients a private view, and it is still fiddly.
• Clients stall because a form plus a shared view feels like homework, not a guided experience.

When two or three of those are true every week, the flexibility Airtable gave you is now costing you more time than a purpose-built tool would. That is the moment to graduate. If you want the numbers behind the decision, the client onboarding metrics and KPIs to track show you how to measure whether onboarding is actually slowing down, and the roundup of the best client onboarding tools compares your options.

Purpose-built tools like OnboardMap replace the client-facing half that Airtable cannot cover. You describe what you need in one sentence, it builds the onboarding (checklist, intake forms, and document requests), and each client gets one magic link, no login. It then tracks every step, reads uploaded files, and sends the reminders automatically so the chasing stops being your job. You can keep Airtable as your internal database and let the onboarding tool own the client experience. If you are weighing that switch, the head-to-head on OnboardMap versus spreadsheets frames the same trade one tier down, and you can start free at app.onboardmap.com/signup.

The bottom line

Airtable is a genuinely good place to build your client onboarding tracker once a spreadsheet stops keeping up, and the three-table structure in this guide, with linked records, single-select statuses, a rollup for percent complete, the right views, a form, and one automation, will serve you well. Just build it with clear eyes. Airtable owns the internal side of onboarding and is still weak on the client-facing side, so plan to move to purpose-built software once the volume of client-facing chasing makes the trade no longer worth it. Build the base today, watch for the switch signals, and upgrade when they show up.

Frequently asked questions

Can you use Airtable for client onboarding? Yes. Airtable is a strong internal onboarding tracker. Build three linked tables (Clients, Tasks, and Documents), use single-select statuses, add a rollup formula for percent complete per client, and create Kanban and filtered views to see progress at a glance. Airtable Forms handle intake and Automations can send reminders. Where it falls short is the client-facing side: there is no single magic-link portal, and secure document collection and per-client private views need workarounds or paid seats.

How do I build a client onboarding template in Airtable? Create a Clients table with one row per client, a Tasks table linked to Clients with a single-select Status field, and a Documents table linked to Clients that tracks each requested file as Requested, Received, or Approved. Add a rollup on the Clients table that counts Done tasks against total tasks for percent complete, then build a grouped grid view, a Kanban by status, and filtered views per client. Add an Airtable Form for intake and an Automation to email reminders.

Is Airtable secure enough for collecting client documents? Airtable encrypts data in transit and at rest, which covers the basics. It is not built for client-facing document intake. Form attachments have no required-file logic per client, no expiring or revocable per-file links, and no clean audit trail of who uploaded what and when. For sensitive files like tax IDs, financial records, or signed agreements, a tool with expiring, revocable links, an audit log, and files kept out of email is the safer choice.

When should I move from an Airtable base to onboarding software? Move when the client-facing manual work outweighs the flexibility, usually somewhere between five and eight new clients a month. The clearest signals are chasing clients for documents by hand, rebuilding shared forms and filtered views for every engagement, paying for Interface seats just to give clients a private view, and clients stalling because the experience feels like homework.