How to Build an Airtable Appointment Booking Form

Airtable is a good place to manage appointments, consultations, service requests, and follow-ups. You can track clients, available time slots, appointment status, payments, internal notes, and next steps in one database.

With miniExtensions, you can turn that Airtable base into a public booking form, a consultation request form, or a client portal where clients can view their own appointments and submit follow-up requests.

What You Can Build

This workflow works for:

• Consultation requests
• Appointment booking
• Sales discovery calls
• Coaching sessions
• Service appointments
• Intake calls
• Paid consultations
• Office-hour bookings
• Client follow-up requests

You can keep Airtable as the internal system and use miniExtensions for the client-facing forms and portals.

Recommended Airtable Setup

Create these Airtable tables:

• Clients
• Consultation Requests
• Appointments
• Appointment Slots
• Services
• Staff

Useful fields in Clients:

• Name
• Email
• Phone
• Company
• Client status
• Notes

Useful fields in Consultation Requests:

• Client name
• Email
• Phone
• Service requested
• Preferred date
• Preferred time
• Message
• Status
• Assigned staff
• Internal notes

Useful fields in Appointment Slots:

• Slot name
• Start time
• End time
• Staff member
• Service type
• Status
• Capacity
• Internal notes

Useful fields in Appointments:

• Client
• Appointment slot
• Service
• Appointment status
• Payment status
• Meeting link
• Notes
• Follow-up status

If clients will log in through a Portal, the appointment-facing tables should include a linked record field back to Clients.

Option 1: Simple Consultation Request Form

Use this when clients should request a consultation and your team will schedule it manually.

1. In miniExtensions, create a new Form.
2. Select the Airtable base that contains your booking tables.
3. Select the Consultation Requests table.
4. Add client-facing fields such as:
   • Name
   • Email
   • Phone
   • Service requested
   • Preferred date
   • Preferred time
   • Message
5. Hide internal fields such as:
   • Status
   • Assigned staff
   • Internal notes
   • Internal priority
6. Make key fields required, such as name, email, service requested, and message.
7. Customize the confirmation/success message so the client knows the request was received.
8. Use the Share menu to copy the form URL.
9. Add the form to your website, landing page, or email campaign.

This is the easiest setup when the client should submit details first and your team should confirm the exact appointment later.

Option 2: Booking Form With Calendar Slot Selection

Use this when clients should choose from available appointment slots.

1. In Airtable, create an Appointment Slots table.
2. Add start and end date/time fields to that table.
3. Add a status field, such as Available, Held, or Booked.
4. Create an Appointments table.
5. Add a linked record field from Appointments to Appointment Slots.
6. In miniExtensions, create a new Form.
7. Select the Appointments table.
8. Add fields such as:
   • Client name
   • Email
   • Phone
   • Service
   • Appointment slot
   • Notes
9. Click the Appointment slot linked record field in the form builder.
10. Open Records Finder Options.
11. Set Record finder mode to Calendar (Date Picker).
12. Select the calendar start date field from the linked Appointment Slots table.
13. Select the calendar end date field from the linked Appointment Slots table.
14. Show only useful slot details, such as time, staff member, service type, and availability.
15. Hide internal slot fields such as staff notes or internal capacity rules.
16. If needed, use an Airtable view to keep unavailable slots out of the options shown to clients.
17. Customize the form confirmation message.
18. Share the booking form URL.

The calendar view lets clients choose from available Airtable records instead of typing a date manually.

Option 3: Booking With Calendly

If your team already uses Calendly, miniExtensions can still capture the booking request in Airtable.

1. Create a miniExtensions Form on your consultation or appointment table.
2. Add the fields you want to collect before scheduling.
3. Add a checkbox field for scheduling through Calendly.
4. Open the checkbox field settings.
5. Enable the Calendly integration for that checkbox field. The checkbox will be checked in Airtable when an appointment is booked through Calendly.
6. Add or configure the Calendly scheduling link.
7. Hide Airtable-only fields from the public form.
8. Share the form link with clients.

This works well when Airtable should store the intake details, but Calendly should handle the scheduling calendar.

Optional: Add Payments for Paid Consultations

If clients need to pay before confirming an appointment, use miniExtensions’ Stripe workflow.

1. Set up the Stripe integration with Airtable.
2. Add payment-related fields to the appointment or request table, such as:
   • Price
   • Payment status
   • Stripe receipt URL
   • Success URL
   • Cancel URL
3. In the miniExtensions form settings, set the redirect URL after submission to the Stripe formula field generated by the integration.
4. Hide backend payment fields from the public form.
5. Test the full flow with Stripe test keys.
6. Confirm that the payment status updates in Airtable after payment.

For optional payments, use Airtable formulas or separate forms so only paid appointment types redirect to Stripe.

Optional: Add a Client Portal

Use a Portal when clients should log in to see their own appointments, requests, or follow-up items.

1. In Airtable, make sure Appointments has a linked record field to Clients, such as Client.
2. Create a new Portal in miniExtensions.
3. In the Portal create modal, select Appointments as the first data table.
4. Then select the linked user field on that table, such as Client.
5. In the Portal editor, go to Tables.
6. Configure the Appointments table child form.
7. Show client-facing fields such as:
   • Appointment date
   • Service
   • Appointment status
   • Meeting link
   • Payment status
   • Public notes
8. Hide internal fields such as:
   • Internal notes
   • Assigned staff notes
   • Private status
   • Admin-only fields
9. Add Consultation Requests if clients should see previous requests.
10. Add a Follow-up Requests table if clients should submit questions after an appointment.
11. Enable record creation for the follow-up request table.
12. Configure the follow-up form with fields like request type, message, and attachments.
13. There is no need to add the Client linked field to that child form to connect the request to the client. Records created from inside the Portal are automatically linked to the logged-in client.

How Portal Record Access Works

For Portal workflows, clients automatically see records linked to their client record. You do not need to add an extra filter that says “only show records for the logged-in client.”

Why This Works Well

Airtable stays your scheduling database. miniExtensions gives clients the front end: intake forms, calendar slot selection, payment redirects, and optional client portals.

Your team can manage statuses, staff assignments, notes, and follow-up inside Airtable, while clients get a simple booking experience without needing Airtable access.