My company does work for live events and we are trying to create internal notifications that are driven by our "event start date." Ideally, we would have reminder emails triggered by our "event start date" deal property (ie. email sent 90 days before, email sent 15 days before, email sent 5 days after, etc.).
To do this we had created a workflow that copies the "event start date" deal property to the "close date" contact property, but some contacts have multiple deals because they do more than one event a year and sometimes multiple in a few days timespan. The problem is the second event would be added and once it met the criteria, it would reset the contact workflow and the first event reminders won't be triggered now.
Does anyone have ideas on how to do this?