Prompt
How do I add booking links and reminder emails to my app?
Latest observation
Nov 21, 2026
OpenAI APIWeb search: off
To add booking links and reminder emails to your app, you usually need two pieces:
- A booking flow that creates an appointment and generates a unique link
- An email scheduler that sends reminders before the appointment
Here’s a practical way to build it.
1) Add booking links
A booking link is typically a URL that points to a page where a user can confirm, reschedule, or join an appointment.
Common pattern
- Create an appointment in your database
- Generate a unique token or ID
- Build a link like:
https://yourapp.com/bookings/abc123
or, for meeting join links:
https://yourapp.com/meetings/abc123
What to store
In your appointments table/model, store:
iduser_idstart_timeend_timestatusbooking_tokenorslugemailcreated_at
Example flow
- User selects a time slot
- App creates appointment
- App generates a unique booking URL
- App shows or emails that link to the user
Example in pseudocode
const token = generateUniqueToken();
const appointment = await db.appointments.create({
userId,
startTime,
endTime,
bookingToken: token
});
const link = `https://yourapp.com/bookings/${token}`;
2) Add reminder emails
Reminder emails are usually sent automatically before the appointment time, such as:
- 24 hours before
- 1 hour before
- 15 minutes before
You need:
- An email service: SendGrid, Mailgun, Amazon SES, Postmark, Resend, etc.
- A background job system: cron, queue, or scheduled worker
3) Use a background scheduler
You should not send reminder emails directly in the web request. Instead, schedule a job.
Options
- Cron job: runs every minute and checks upcoming appointments
- Job queue: enqueue a reminder job when the appointment is created
- Cloud scheduler: e.g. AWS EventBridge, GCP Cloud Scheduler
Simple cron approach
Every minute:
- Query appointments happening soon
- Check whether reminder email has already been sent
- Send if needed
- Mark reminder as sent
Example logic
const upcoming = await db.appointments.findMany({
where: {
startTime: {
gte: nowPlus24HoursMinusWindow,
lte: nowPlus24HoursPlusWindow
},
reminderSent: false
}
});
4) Email template example
Subject: Reminder for your upcoming appointment
Hi {{name}},
This is a reminder that your appointment is scheduled for
{{startTime}}.
Join or manage your booking here:
{{bookingLink}}
Thanks,
Your App
5) Recommended implementation approach
If your app is small
- Generate booking links with a unique token
- Use a cron job every minute
- Send reminders with an email provider
If your app is larger
- Use a queue like BullMQ, Celery, Sidekiq, or SQS
- Schedule reminder jobs at creation time
- Add retry logic and logging
6) Important considerations
Prevent duplicate reminders
Add fields like:
reminder_24h_sent_atreminder_1h_sent_at
or a separate reminders table.
Time zones
Store times in UTC and convert for display. This avoids confusion.
Security
- Use random, unguessable tokens
- Expire links if needed
- Verify the user before allowing changes
Deliverability
- Set up SPF, DKIM, and DMARC for your email domain
- Use a reputable email provider
7) Minimal architecture
- Frontend: booking page and link display
- Backend: create appointment + generate token
- DB: store appointment and reminder status
- Email service: send emails
- Scheduler: send reminders at the right time
8) Example stack
If you’re using:
- Node.js: Express + Prisma + BullMQ + SendGrid/Resend
- Python: FastAPI/Django + Celery + SES/SendGrid
- Ruby: Rails + ActiveJob + Sidekiq + Postmark
If you want, I can give you a step-by-step implementation for your specific stack, like React + Node, Next.js, Django, or Rails.