Hi everybody,
Every month at work, I need to create a calendar where I have to distribute a daily sentry task to multiple divisions. Basically I built a form that look like this to do that
Basically here's what I need and what I've done:
Needs:
- A form that the person in charge (SSE) would use to populate a calendar with the different Troupe's shifts so they can go back in the event after to put a name in it.
-
- I've created a Calendar named Salle de Garde QGET
- I created a form so he could assign which dates are assigned to whom
-
- Now here comes the fun part, I need a workflow that would automatically create the shifts in the calendar based out of this form.
- I figured that I would need those variables
- A collection variable for each troupe's dates:
- Dates Tp A
- Dates Tp B
- Dates Tp C
- Dates Tp Soutien
- The time for the beginning and the end of the shift will always have the same Hours (0900 to 0900 the nex day) so:
- Start Time
- End Time
- The month that we are planing
- Month
- A collection variable for each troupe's dates:
- So now what commands should I use and how should I build my work flow to go thru all the dates, by troupes and create shifts with the right dates and time that would highlight the Tp in charge?
- I assume that I would need to start with a loop that goes thru the dates to extract all of them and put them in a collection variable, wich I don't remember how to do.
- After that I would need an other loop to create the events based out of each variables.
- I figured that I would need those variables
Thanks you very much for your time and help with this matter. It is much appreciated.