Built the three-tier partner onboarding system and the partner-facing dashboard from the ground up — one workflow stitched together from WordPress, Airtable, and Zapier.
FourCorners had three different partner relationships, three different data shapes, and zero glue between them — every new partner meant manual data entry and a back-and-forth chain of emails.
Network Partners, ATM Owners, and Site Partners each had different obligations, different training, and different data the team needed to capture. The existing process was: partner emails the team, team replies with a PDF, partner fills it out and emails it back, someone re-types it into Airtable. Same dance for every new site.
The team also needed partners to be able to check their own inventory and terminal data without pinging the operations team every time — but they couldn't get raw Airtable access, because that would let them see everyone else's data too.
One front door, three branching flows, and Airtable as the single source of truth that the rest of the stack reads from.
┌─ Partner clicks "Sign up"
│
â–¼
┌─────────────────────â”
│ WordPress + OTP │ Email verification
└─────────┬───────────┘
│
┌────────┼────────â”
â–¼ â–¼ â–¼
Network ATM Site
Partner Owner Partner
Form Form Form
│ │ │
└────────┼────────┘
â–¼
┌─────────────────────â”
│ Zapier dispatcher │ routes by partner_type
└─────────┬───────────┘
â–¼
┌─────────────────────â”
│ Airtable (source │ customer_code auto-generated
│ of truth) │ records linked across tables
└─────────┬───────────┘
│
┌────────┴────────â”
â–¼ â–¼
Partner LearnDash
Dashboard training
(filtered (gates
views) activation)
The ops team stopped re-typing form data. Partners can self-serve their own inventory and terminal data without an email thread. The vendor cost comparison I wrote became the document the company used to lock in the DOOH stack, and the SOPs became the playbook for every site rollout.
The unsexy parts — the customer-code generator, the Zapier dispatcher, the OTP step — are what made the whole thing actually work. Anyone can plug a form into Airtable. Making sure the right partner sees the right data, that training has to be completed before activation, that records link cleanly across tables, that's where the actual value sat.
Also: writing the SOPs as I built was a much better use of time than building first and documenting later. The doc was the spec.