I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. The thought, being any of the staff could add jobs that need to be taken, by using the form, and students could view a sheet for any openings and put their names down for any they wanted.
Normally, I would just give them access to the results sheet.
However, there are 3 different categories of student employees, and some jobs may require any combination of numbers of students in each category. On the form I have a simple dropdown of amounts for each type: # Cat1, # cat 2, # cat3.
What I would like to do is actually create a new Row with all of the same data from the form (Date, Start time, End time, Job Type, Location), as many times as needed for each Category.
Date |**Category*|**Qty*| Start |End |Job Type |Location 10/10/15|Cat 3 |3 | 10:00 AM |11:00 AM |Set-up |Library 10/10/15|Cat 3 |3 | 10:00 AM |11:00 AM |Set-up |Library 10/10/15|Cat 3 |3 | 10:00 AM |11:00 AM |Set-up |Library 10/10/15|Cat 2 |1 | 10:00 AM |11:00 AM |Set-up |Library 10/10/15|Cat 1 |2 | 10:00 AM |11:00 AM |Set-up |Library 10/10/15|Cat 1 |2 | 10:00 AM |11:00 AM |Set-up |Library
I would then like to add a column for student name, in which they could add their name to a job they were taking.
I plan to execute a script that will then check each morning for any unfilled jobs for that day, and generate an email to the Staff notifying us of the vacancy.
So what would I need to do to generate this new output?