Hello,
The process I am trying to create is as such:
I need a way for two different levels of employees to be able to sign up to conduct training classes. The classes are mostly different for each employee level, but some overlap to both levels. I have started with an annual calendar by day template and entered a few of the available trainings for testing. I am not sure if this is the best option, but I would like ALL training classes housed on one master sheet. I have the following issues I cannot figure out.
1) I would like the sign up form to only display available training classes. Meaning, once someone has submitted a form to sign up, that class would no longer populate anytime the form is opened again after that.
2) There are different classes available for the two different levels, but some overlap. I believe conditional logic on the form can help, but I don't believe conditional logic can go two layers. Meaning, I have two helper columns that are checkboxes categorizing each individual training class in the different levels. The forms cannot use logic to say that "if you are at this level, look at associated checkbox column, and return the training listed in another column on the same row." I COULD just have two separate forms for the different levels, but that is not ideal and would like to avoid it if possible.
3) The submitted form will populate a new line on the calendar sheet, which is not where I want the information. I really only want the last name and first name to populate on the row of the training class selected. I am not sure what to do.....
Please see the screenshots below to view the form setup I have started and the annual calendar sheet setup. For now the form fields helper text has questions in bold that explain what I envision for the workflow. This is DEFINITELY in it's infancy and I haven't made much progress yet. Any help/pointers/suggestions are extremely appreciated. :)
Thank you!
Ryan S.
