We currently have a SharePoint foundation 2010 calendar that allows creation of entries via a custom form. That form allows users to create an event specific to our business, including setting a sales person for the event, a technician to do the work, etc. We currently have a list of salespeople and technicians manually coded into the form. We are looking to get the following behavior for this form:
If someone creates a new event and designates a salesperson or a technician, we would like that salesperson (or technician) to be subscribed to alerts for that event automatically. Just by having the salesperson (or technician) designated on an event which has been saved we want that to create the subscription without any additional steps by the user entering the event, or by the salesperson or technician. We don't want that salesperson or technician to get alerts for other events associated with other sales people or technicians, just their own (so they should not be getting alerts for every item in the calendar associated with another technician or salesperson).
What's the best way to do this?