Auto-Fill Appointment Dates in a Contract

If your business sends a contract right after a client books an appointment — a consultation, a session, an installation date — you can have the booked date and time automatically written into the contract instead of typing it in yourself every time.

Step 1: Create a custom field to hold the date

Go to your custom fields settings and create a field to store the booking date — for example, "Session Date." You can attach this to either the contact or the opportunity, depending on how you track the deal.

Step 2: Reference it in your contract template

In your document template, insert the custom field as a merge variable wherever the date should appear, referencing either the contact or the opportunity version of the field depending on what you set up in step 1.

Step 3: Build the workflow

  1. Create a new workflow with the trigger Customer Booked Appointment.
  2. Add an Update Contact/Opportunity Field action that copies the appointment's start time into the custom field you created.
  3. Immediately after that, add a Send Contract (or Send Documents & Contracts) action, using the contract template from step 2.

The one rule that matters

The field-update action must come before the send-contract action in the workflow. If the order is reversed, the contract will go out before the date has actually been written into the field, and it'll be blank or outdated.

Which method to use

Use the contact-field version for simple, one-off bookings. Use the opportunity-field version if the appointment is tied to a deal moving through a pipeline.

Was this article helpful?