Student Feedback system - HTML form - part 3

Continuing from Student Feedback system - HTML form - part 2 we now look at the final function to return data from the form to the spreadsheet.

3. writeBack

Example completed student feedback

The code takes an input of data from the form which it then assigns to variables as we extract the required items. In deciding which data to write back to the row for the student feedback we evaluate the value of whoAmI (from getActiveUser) to tutor 1, tutor 2 or neither (in which case the whole row of data is written to as the assumption is an administrator). Depending on which option it is determines the array of values we assign from the form and to which columns ('setValues').

Student Feedback HTML Form.xlsx