Airtable-Based Pharmacy Ops System

We are looking for an experienced Airtable systems builder (not a beginner) who has built internal operating systems, CRMs, or multi-step automation workflows that integrate billing and payments.

I need an end-to-end internal operating system for CRAFTD Rx built with Airtable at its core. Today our team operates across QuickBooks, spreadsheets, GoFormz and Spruce, and none of these systems communicate with each other. The goal is to replace this with one cohesive, scalable workspace that can be rolled out in phases over the next four to six weeks.

PHASE 1 (first 2–3 weeks) The first milestone will focus on building the core order submission and routing system: • Rep-facing order submission interface within Airtable • Order routing logic (pharmacy selection based on pricing, availability, or predefined rules)

PHASE 2 (immediately following Phase 1) Once the core workflow is validated, we will expand into: • Multi-vendor product catalog built in Airtable (scalable and easy to maintain) • Rep dashboard (Airtable interface and/or Retool for more advanced views)

TECH STACK Airtable will serve as the primary system of record and interface. Retool (or similar) for dashboards if needed. Make or Zapier for automation and orchestration. QuickBooks and Stripe for billing and payments.

If you recommend alternative no-code or low-code tools that improve scalability or speed, I am open to suggestions.

MUST-HAVE EXPERIENCE • Airtable relational database design (at scale) • QuickBooks API integrations (invoicing and payment syncing) • Stripe integrations, specifically ACH workflows • Experience building internal tools or operational systems (not just websites)

WHAT I’D LIKE TO SEE FROM YOU

1. Examples of internal systems or tools you have built that involve multi-step workflows (orders, payments, tracking, etc.)
2. Details on your QuickBooks and Stripe integration experience, including how you handled syncing, errors, or edge cases
3. A brief explanation of how you would structure a scalable multi-vendor product cataAirtable (linked tables, automations, permissions, etc.)

SCREENING QUESTIONS (please answer)

1. Describe a system you built that handled orders, payments, and tracking. What tools did you use?
2. How would you design a multi-vendor product cataAirtable so pricing and availability stay flexible?
3. How would you ensure QuickBooks and Stripe remain fully in sync without manual intervention?

We are moving quickly and plan to hire within a few days. Looking for someone who can start immediately, communicate clearly, and execute efficiently without heavy oversight. Budget: USD 10000–20000 Skills: PHP, Software Architecture, MySQL, Software Development, Stripe, Airtable, Automation, API Integration