This page shows images of the sheet headers created when you create a sheet using the Form Maker Add-on. This section concentrates on row 5 of the new sheet which contains the headings for the data you will enter for your new form. You will enter your data in rows 6, 7, 8 etc.
In the images on this page the headers have been labelled and then, below the image there is an explanation for each of those labels.
Put a Y in this column against any question you want to delete. You can label all the questions you want to delete then choose delete from the sidebar menu.
Put a Y in this column if you want to update the question. When you choose update from the sidebar menu the question will be updated and the Y replaced with a message stating when the question was last updated. If you have set the options for the form to be updated on Form Submit or Hourly then those questions which have an updated message will be updated - all other questions will be ignored.
Please note you can change all the details of a question except for the question type. If you do want to change the question type for a question you will have to delete the existing question and add a row to add the question again - with the new question type.
When the question is created an Item ID number will be entered in this column. If it can't be created an error message will appear here.
you can choose from ten different types of questions. Or you can enter page or section headers or YouTube videos or images. (This is explained in more detail below) .
Add the text of the question, or captions for videos and images. You can also add here Page and/or section headers if you have selected a Page or Section Heading type for this row
You can optionally add additional directions or clarification for the question.
If you put Yes in this column the question will be required. If you enter No or leave blank it will not be a required question
If, for the question type, you choose video you can enter the URL of a YouTube video here. If you chose Image you can enter the URL of an image which is publicly available on the internet. You cannot add images stored on your computer or on your Google Drive. However once you have created the form you can edit it using the standard forms interface and change the image to one you upload from your PC or select from your drive.
For Multiple Choice, Checkbox and Drop Down List questions you must put the option choices for the question in Column F. The choices MUST be separated by a the question separator you entered in the form headings. You can use the Options sidebar menu to enter up to 1,000 choices - click here for more details.
If you enter Yes in this column the user will be allowed to add and choose a write-in choice for the question. This is only available for Multiple Choice and Checkbox questions.
For Multiple choice, Drop down list and Checkbox questions you can specify which of the options (those you set in column F) is correct. You need to set the correct options if you want these question types to be auto-marked. Please Note a correct answer must be an exact match to one of the options eg if one of the options is Apple (with a capital A) and you set the correct answer as apple (without the capital a) apple will be ignored and the question will not be auto-marked.
You cannot enter a correct value for short text questions. Google's API dopes not yet allow that. We recommend that for those questions you enter the correct value(s) for short text questions in the feedback section of the sheet. That will make it a little easier to add the correct value(s) in the form editor.
For Scale questions you can leave this blank or enter 0 or 1 - this will be the lower end of the scale that the user can choose.
For Scale questions you can leave this blank or enter a number between 3 and 10 - this will be the top end of the scale that the user can choose
For Scale questions you can leave this blank or enter text to explain the lower boundary to the respondent.
For Scale questions you can leave this blank or text to explain the upper boundary to the respondent.
For Grid and checkboxgrid questions enter the Row headings in Column L. The options must be separated by your chosen separator. You can use the Options sidebar menu to enter these choices.
For Grid and Checkboxgrid questions enter the Column headings in Column M. The headings must be separated by your chosen separator. You can use the Options sidebar menu to enter these choices.
Validation is only available for Short Text, Paragraph, Checkbox, Grid and CheckboxGrid Questions. The type of validation available varies with the type of question.
For Short Text Questions the Validation Types available are: 'Number', 'Text', 'Length','Regular Expression'
Paragraph Text Questions the Validation Types available are: 'Length','Regular Expression'
Grid & Checkbox Grid Type Questions the Validation Types available is just: 'Limit to one response per column'
Checkbox Type Questions the Validation Types available are: 'Select At least', 'Select at most', 'Select Exactly'
For each Validation type below you can choose from the following validation rules.
This is the message you will display to the user if they do not choose a valid option.
Here you set the number of points you want to award for the question. Only Multiple Choice, Drop Down List and Checkbox type questions will be automatically marked - and assigned the points you set here (if they are answered correctly). Also, short text, paragraph text, scale and date/time questions can be marked manually and awarded the points you set here.
If any questions are given a points value then the form will be setup as a quiz. If you do not add any points the form will be treated as a simple data-entry form and the correct answers and feedback values will be ignored.
For questions which can be marked automatically you also have the option to set-up feedback here. That includes Text (ie what you want to say if the question is answered correctly) a Link - a hyperlink to further information and Link Text (ie how the link will appear)
As above but for feedback which will appear if the question is answered in-correctly.
Here you can set the feedback for those questions which can be marked manually
In the question types column you can choose one of various options to add questions or layout items to your form.
Short Text, Paragraph Text, Multiple Choice, Drop Down List, Checkboxes, CheckboxGrid Scale, Grid, Date, Date Time, Duration and Time
Section Header, New Page, Image, Video
For the Text type question, you simply type in a question and the user gets a one-line text box to enter their response.
For the Paragraph type question you type in a question the user gets a multi-line text box to enter their response.
This type of question is well suited for open-ended or essay type responses.
You can insert pictures in your form. These are especially useful for quizzes to show the user maps, charts, and other images related to the questions.
For Image and Video Types the question and Question help Text columns will be the heading and subheading for the image or video.
If your form has a lot of questions you may want to break it up with section breaks or page breaks, and provide additional structure and information to the user.
The Question and Question Help Text columns will be the heading and description for the section or page.
If you choose Shuffle Question Order the sections and pages are not shuffled. The items within the section will be shuffled. This is useful for keeping images/videos together with the questions about them.