Guide 1 - Form Settings
This page shows images of the sheet headers created when you create a sheet using the Form Maker Add-on. The information you enter in these fields will be the settings of the form you create using the add-on. In the images on this page the data entry fields have been labelled and then, below the image there is an explanation for each of those labels.
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.
- Simply click and type in that box to add your description.
- 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
J - Publish Summary Y/N
The default for this is YES. - this will allow users to see a summary, in graphs and charts, of the responses from other participants.
K - Show Progress Bar Y/N
The default for this is NO. This option is useful for multi-page forms so that respondents can see how close they are to completing the form.
L - Shuffle Questions Y/N
The default for this is NO. If you set this to Yes the order of the questions will be re-arranged for each respondent so that the order is different for each user. Please note the order will only be re-arranged within section/page headings. So if you want to shuffle questions which relate to images or videos you have added to the form you can do so but you must use page or section heading to separate those questions and the image or video from all the other questions.
M - Show link to respond again Y/N
The default for this is NO. If you set this to yes the users will be given a link to answer the questions again
N - Image and video alignment
The default for this is Center. This will be the default for all the images and videos you add to the form.
O - Allow users to edit response
The default for this is YES. When the users submit their responses they will be given a link to change their answers.
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.
There are 3 tabs in the Settings window - the image shows the Quizzes tab.
In there you can choose to release marks immediately or after manual review.
You can also set choices about what the respondent can see - when you open the window if you click on the question marks you will get more information about each option.
On the GENERAL tab you can also specify if you want to restrict the form to your domain.