I'm writing this down so I can remember why I did things the way I did when I have to go back and either fix it or make a new one somewhere else:
"The less change the better" is a simple motto for some folks. I wanted to keep the new method (my form) of getting Gen Ed feedback as similar as possible to the old method, so I kept the same wording and the same order of questions. I simply lifted them on to a google form which will plop the answers down in a sheet that autocrat turns into a nice PDF that looks identical to the version we use now. The output keeping the same look is only important to me so that the admin and district people who are used to seeing our forms can feel comfortable. More important is that the "front end"--where the Gen Ed teachers look at it--looks as similar as possible.
Here's where my problem arises: I have to add some pre-filled, superfluous "questions" to the form so that autocrat will spit out the the PDFs exactly how I want them while keeping the formatting customized to each student. Information such as student initials and case manager emails are easy for a spreadsheet to look up and calculate, however, this behind the scenes look up has to happen before the form submits to autocrat (without reworking my entire concept and workflow here). So I will make it part of my case-manager-side script, but that means that I have about 4 extra questions hanging off the end of my Gen Ed form.
Perhaps I can find a way to make them invisible in the future, or end up reworking the entire work flow. For now, better to make a working product before getting ahead of myself.
That's all for now.
Link to part 1
Link to previous part
Link to next part