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.
A - Delete?
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.
B - Update?
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.
C - Item ID
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.
D - Question Type
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) .
E - Question
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
F - Question Help Text
You can optionally add additional directions or clarification for the question.
G - Required Question Y/N
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
H - URL of image or YouTube Video
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.
I - Choices
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.
J - Other Option Y/N
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.
K - Correct option(s)
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.
L - Scale Questions - Lower Bound
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.
M - Scale Questions - Upper Bound
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
N - Scale Questions - Lower Bound Label
For Scale questions you can leave this blank or enter text to explain the lower boundary to the respondent.
O - Scale Questions - Upper Bound Label
For Scale questions you can leave this blank or text to explain the upper boundary to the respondent.
P - Grid Questions - Grid Rows
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.
Q - Grid Questions - Grid Columns
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.
R - Validation Type
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'
S, T, U - Validation Rule
For each Validation type below you can choose from the following validation rules.
F - Validation Error Message
This is the message you will display to the user if they do not choose a valid option.
W - Points
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.
X, Y, Z - Feedback for correct answers
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)
AA, AB, AC - Feedback for in-correct answers
As above but for feedback which will appear if the question is answered in-correctly.
AD, AE, AF - Feedback for non-automarked questions
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
1 - Short Text type
For the Text type question, you simply type in a question and the user gets a one-line text box to enter their response.
2 -Paragraph Text type
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.
3 - Multiple Choice type, 4 - Checkboxes type, 5 - Drop Checkboxes type
- For these questions, type in your question.
- Then, in the choices column, enter in as many options as you wish for the answer choices. The options must be separated by the Separator you have specified in the form settings
6 - Scale type
- For the Scale type question you must type in your question in the Question column
- Then you enter the starting point (0 or 1) and the ending point (between 2 and 10) for your scale
- Optionally, you can also enter labels for the endpoints of your scale such as “Dislike most” and “Like most”
- The user will be presented with a scale of values on which to place their response.
7 - Grid type
- For the Grid and CheckboxGrid type question, type in your overall question and directions that will apply to each question in the grid.
- Then in columns P enter as many row headings as you wish for the grid, each row will be a separate question or statement. The headings must be separated by commas.
- Then in column Q enter Column headings to provide descriptive labels for each column. If you enter too many column headings they will be accepted but not all may be displayed. The number displayed is dependent on the length of the text in the rows and the text in the column headings.
- When the user completes the question, they will be presented with a grid of rows and columns and will need to click a single cell to place their response for each row.
- You can also use the Options menu from the sidebar to set the Row and Column headings
8 - Date Question type
- the user will simply choose a date from a drop down calendar..
9 - Date/Time Question type
- the user will choose a date from a drop down calendar.
- They can then enter a time - with a 24 hour clock
10 - Time Question type
- the user will enter a time - with a 24 hour clock.
11 - Duration Question type
- the user will enter a length of time they will be able to enter the number of hours, number of minutes and number of seconds.
Inserting images and Videos
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.
Section and page breaks
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.