These directions describe how to make a new yearly Workshop Report form for the TLs to report to the RCs. In making this guide, next year's forms are now available at the following links:
Be sure to remove "Someone New".
- Steps:
- Copy the current form.
- Rename the Title.
- Edit it with revised names.
- Rename the file to match the next year.
- Click on the Title and rename
- Click on the names and revise.
- If there is a new name, add to the bottom of the list.
- Then drag to alphabetize.
- COPY TEMPLATE
- Locate: Template Workshop Report Form:
- File --> Make a copy
- Rename the Responses to match the Form name.
- Share with the same people.
- MODIFY THE RESPONSE FORM
- Arrange the names on the tabs in the same order as on the form including adding any new names.
- Add the following script to the A1 cell: =QUERY('Form Responses 1'!1:5702, "select * where C='Scripko' order by A DESC")
- Be sure to take out 'Scripko' and substitute the new person's name.
- Go to the script editor under the Tools menu.
- Find where the new person should be in the script.
- Copy the person's info above it and paste below.
- Modify the name and email for the new person.
- Be sure to remove any names no longer having a tab.
- SAVE.
- Rename the Form to: Form Responses 1 (This is the name of the first tab at the bottom.)
- Move email column to Column P.
- Add an empty column after A and I making column B & J empty.
6.1. Check the Script Project Name and edit it if desired.
6.2. Run the script.
- This is the way a Script run should work:
- Run --> Run function --> send Emails
- View --> Execution transcript
- Execution should be successful
6.3. Possible Issues
- When you are in the script code:
- Go to edit --> Current project's triggers
- Click "Click here to add one now."
- Set your script code.
