Help with Automations and Notifications

Hi Brittany, yeah this is doable.

For this, I would first create a new field called Google Calendar ID or some such

I’d then make an automation that would trigger if the record’s Project Installation Date value was not empty AND the Google Calendar ID was empty, and I would make the automation:

1. Create a new Google Calendar event
2. Update the Google Calendar ID field of the original record with the ID generated from the previous step

For this, I would make two formula fields

1. The field 2 weeks before end date would be to calculate when the exact date of 2 weeks before the term ends with the DATETIME_ADD() formula
2. The field Send email would be to check whether the present date is equals to the value from the previous field with the formula `TODAY() = {2 weeks before end date}

The field Send email would be used as the automation trigger, and the action would be to email the client

Do note the following limitation outlined here

If we can’t send emails, then I’d set up the action to be to message me on Slack or make a calendar event for me to notify the client or something

Let me know if you’ve got any questions!