Guide 1 - Form Settings

A - Form Title

Enter the name of the form here - if you leave this blank the Create Form Option will fail

B - Form Description

you can optionally add text for a description. Usually this is where you can explain to the user the purpose of the form, any special directions, or other helpful information.

1. Simply click and type in that box to add your description.
2. You can include web addresses in the description box and they will show as clickable links on the live form.

C - Update on Form Submit

The default for this is NO. You can set it to update every time a new form is submitted. This could prove useful if you want to maintain a dynamic list of options in response to the choices your uses have made.

D - Update every hour

The default for this is NO. You can set it to update the form every hour.

E - Confirmation Message

You can optionally add text for a confirmation message which will appear when the user has submitted the form. The default message is “Thank you for completing the form”. You can also add a link to a website or a document as the confirmation message.

F - Collect Email Y/N

The default for this is NO you can change it to YES to collect emails so that you can tie a user to a response, but only from your own domain

G - Create Destination Spreadsheet Y/N

The default for this is YES - it will create a spreadsheet to hold the responses. The URL for the responses spreadsheet will be pasted into cell K3 of the spreadsheet

H - Limit to 1 Response Y/N

The default for this is NO. If you change it to Yes the user will able to submit only one response

I - Options Separator

The character you want to use to separate the different options when entering choices for Multiple Choice, Checkbox, drop down list, Checkbox Grid questions

P - Custom Closed Message

You can put text in this cell which will be shown to your users if they try to open a form that you have closed.

Q - Start Date/Time

You can specify a date and time before which the form will be closed. If users try to open the form before this date/time they will see the custom closed message. If you set a date but not a time the form will open at midnight on that date. If you set an opening and/or closing date you should set the form to update on an hourly trigger. Please note that Google's triggers are not precise to the minute. If you set a start time the form will open the next time the trigger runs. That could be up to an hour after the start time you have specified.

R - Stop Date/Time

You can specify a date and time after which the form will be closed. The comments about start times above also apply to this field.

S - Max Responses

You can specify a maximum for the number of responses that you want to receive. After your form has received that many responses the form will be closed and any further users will see the custom closed message. If you want to add a maximum number of responses you also need to specify that the form should be updated on form submit. Please note that if other users have your form open at the point at which your form is closed then they will still be able to submit more responses so you may receive slightly more responses than you have specified.

T - Stop accepting responses

You can set this field to Yes and run an update to close your form. Please note that if other users have your form open at the point at which your form is closed then they will still be able to submit more responses so you may receive slightly more responses than you have specified.

U - Form open or closed status

This cell will show you if the form is currently open or closed. If it is closed then the message will appear in red. If it is open the text in the cell will say so and the cell will appear in green.

V - New page for each question

This was added to satisfy a user request. If you add the word PAGE here a new page will automatically be created for each question - without you having to add a new page item below every question in the spreadsheet,

W - Help

This link is added to every new sheet if you click on the link it will open this site.

Quiz Form Settings

For Quizzes some of the Form Settings can only be set using the Form Editor interface - When the form has been created open it in edit mode (click on the link in cell D3) then open the Form Settings Window by clicking on the cogwheel.