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.
![](https://media.screensteps.com/image_assets/assets/001/538/729/original/b6dd7eca-afdf-4465-ab3a-32b386a62132.png)
- 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.
![](https://media.screensteps.com/image_assets/assets/001/538/728/original/197045cc-bb91-4429-ac3f-120c6db69668.png)
- COPY TEMPLATE
- Locate: Template Workshop Report Form:
- File --> Make a copy
- Rename the Responses to match the Form name.
- Share with the same people.
![](https://media.screensteps.com/image_assets/assets/001/539/114/original/9e16c734-2b91-43dd-ab30-58d89b47d1a0.png)
- 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.
![](https://media.screensteps.com/image_assets/assets/001/539/045/original/23b5bd78-78e9-475f-ac52-e2f6a1960e99.png)
- 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.
![](https://media.screensteps.com/image_assets/assets/001/538/381/original/a6006b06-da1c-4aa7-931e-2fe7af4dddf0.png)
![](https://media.screensteps.com/image_assets/assets/001/539/050/original/66c8892c-30bc-40a0-a11b-8b93f030f30a.png)
- 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.
![](https://media.screensteps.com/image_assets/assets/001/539/113/original/8c4e8714-413d-4cab-876c-15f8cd5194db.png)
- 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.
![](https://media.screensteps.com/image_assets/assets/001/539/048/original/3b9d0e92-1686-45d5-b6ef-22a0e98a7e83.png)
![](https://media.screensteps.com/image_assets/assets/001/539/049/original/4e024b26-281d-42f0-ab43-9b55490c0f8b.png)