High level requirement:
To generate 2 forms from spreadsheet data that have random questions and selections. To send forms to users to complete, and then to assessors to evaluate. To maintain spreadsheets with status and event record details of the first round questions/answers, and an assessment event record. All user records, question records, assessments need to have a unique code for its usage.
1. At least 1 year experience with google apps script.
3. Excellent written english.
Specific workflow requirements:
1. Create an 'on the fly' form using question data from a questions spreadsheet (QS1). 10 Questions are to be created. The questions need to be in a random order, and each of the selections need to be in a random order too.
2. Email form to user to complete. User details are in a user spreadsheet (US). Name and email are to be used. Transfer the question code in the form.
3. Create a record in...