Step 1: Setup the Form & Spreadsheet

Step 1 involves creating and setting up the Google Form and Spreadsheet.

The form will be used by your faculty and staff to submit technical (or other)

requests.

The spreadsheet will be used by you to respond to and organize the

requests.

For this workshop, a spreadsheet and form has already been created for you.

UPDATED JULY 6, 2017

A1. Visit this Google spreadsheet, MAKE A COPY - Help Desk Form Sample (responses) and Make a copy.

A2. Visit the Google form Tech Request Help Desk Form and Make a copy.

The form will come with a brand new spreadsheet. You will need to manually connect the spreadsheet you copied in A1 or you can set up the extra columns and copy/paste the script in manually.

B. For this workshop, please DO NOT change anything on the form and the spreadsheet, or the script will not work properly. After the workshop, you are more than welcome to explore the form, spreadsheet, and script and change things to serve your own purpose.

Please proceed to step 2.