I am stuck. I’m trying to build a solution within ActiveCampaign (no n8n or Zapier). I need to send a SMS, one hour in advance of the appointment time. NOTE: the appointment time is a custom field that is stored on the contact record in ActiveCampaign.
Hi there!
The challenge here is that ActiveCampaign automations can’t natively trigger based on a custom field date/time - they need a specific event or action to start.
If your appointments are being created through a form, calendar booking, or another system, you could trigger the automation when the appointment is created, then use a Wait action to pause until 1 hour before the appointment time.