What a completion record looks like

Completion record

Name

Sample learner

Course

Airtable Foundations — build a base your colleagues can use

Completed

8 November 2026

Project

View the dashboard →

Skills demonstrated

Load a comma-separated export into a new table and check that everything arrived · Read the type Airtable gave each field and change it to what the data actually is · Find the rows an export brought in that are not records — a closing note, an order recorded twice — by counting rather than by reading · Bring a column to one spelling per thing, and hold it there with a field type that only accepts the list · Model a second table and link it to the first, and prove from the record counts that every name matched · Get a total and a count per record without writing anything · Save a view for a particular reader and share it as a link, knowing exactly who can open it

What was built

An Airtable base holding an orders table and a clients table, joined by a link you made, carrying a per-client order count and two per-client rollups you can each explain, with the export's junk rows and repeated order gone, one spelling for every product and every channel, and a saved view shared by link — the link being the thing your completion record points at.

The 6 sessions, and when each was completed on their own

Each session was completed twice: once with step-by-step guidance on one company’s data, then on a second company’s data from a brief, with guidance only when asked. Every check passed on both. Alongrail records the sessions, the checks and the dates; the dashboard itself is the learner’s own, hosted where they chose.