A writers' community runs two virtual rooms that members book around the clock, from quiet co-writing sessions to public meetups. I built the system that takes a booking from "member picks a time" to "published community event" with one decision in the middle and no retyping anywhere.
For every meetup, a member emailed the community manager, and she did the rest by hand. Five steps, every event, and she was the only person who could do any of them.
Reschedules restarted the chain. Recurring events multiplied the calendar work. None of it was hard; all of it was constant.
TidyCal shows members only genuinely free slots, assigns one of the two rooms, creates the Zoom meeting, and holds the room calendar the moment the member confirms. Three of her five steps are gone before she even knows the booking exists, and private sessions never reach her at all.
One link, two rooms, 24/7. Zoom and the calendar hold happen the instant the member confirms.
The community post arrives pre-drafted from the member's own answers, with clash warnings.
Publish direct, or draft in Circle to preview first. Recurrence confirmed in one panel.
Room held for the series, confirmation emailed, every step stamped so nothing fires twice.
The community manager never sees a spreadsheet. The Library Desk is a review app I built on Airtable's interface extension SDK: a queue of pending bookings, a two-week room calendar, and buttons that map to decisions, not fields. What she sees in the editor is exactly what publishes.
Soonest first, each card carrying the facts and the quick decisions. The full review, with a rich-text editor and the Publish and Draft in Circle actions, lives one click deeper.
The two-week room picture, grouped by day: published, in review, and pending, all in one glance. The Pulse button opens monthly stats.
Each one polls on a schedule, does its one job, and stamps its own completion marker. Recovering from any failure is usually clearing a single field.
TidyCal to Airtable. Live bookings upsert by booking ID; cancellations fork on "was it published?", deleting quietly or flagging for human cleanup.
Approved bookings become Circle events. One branch creates fresh, the other publishes an existing draft in place, edits intact. Recurring events hold the same room calendar the booking started on.
Branded confirmations through Resend. The sent-marker means it can never send twice.
Inside Airtable: new bookings stamped for review, the reviewer notified, the post drafted by script.
The design choice I'd defend hardest: every field in the base has exactly one writer. That's why the whole thing re-runs every few minutes without stepping on anyone's work.