I have a scenario that listens to our Cognito Forms database. We have a form that collects dates on which contractors are available for work. When a contractor submits their availability (entry created in Cognito) I would like to add those events to a calendar that is specific to the contractor.
So far, I have a scenario working that adds a contractor’s multiple dates to a master calendar - great!
What I’d like to do to improve this further, is to create these events on a calendar that is tied to a single contractor. So I need to check if the Calendar exists, and if it does, proceed to add the events to it. However, if it does NOT exist, then create that calendar and then add the events to it. I had this sort of working, in that it would create the new calendar and add an event, then it would create another calendar of the same name and add the second event to that calendar. So, not quite right.
I’m not sure how exactly, to construct my scenario/flow to achieve this (i.e. what modules to use, filters or error controls etc.) - I would appreciate any advice or pointers on how to achieve this.