Form Builder
Setup
How to setup Form Builder
Note: If you prefer watching videos, please check our videos at How it works?
In order to start Form Builder
Open a Form
Go to add-on select Form Builder
Click on Setup to start Form Builder
Click to Select the App that you want
The App can be Google Form or Google Sheet or Google Doc or Google Slide
Build Form from another Google Form
Consider you have an existing Google Forms. And you want to import few or all fields/ questions from that form into another form. This section covers how to do it.
Click on "Google Forms"
After clicking "Google Forms" Google Picker opens where you can choose any Form to build a new Form or add new fields to the existing one.
After selecting the form you can see the form name appearing just below the app buttons.
You can access the selected form by clicking on the Open in New icon
You can shuffle the questions by clicking shuffle icon.
Form Builder lists all fields and makes fields/questions available for you
Choose the position where the fields need to be imported.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
If you want more fields from other forms, you can click on Change Form Button and do the same steps again.
That's it, your Form is ready.
Note: There are some types in the Form API such as VIDEO. these are unsupported types in Form Builder so you can not import these fields.
Build a Quiz Form from another Quiz Form
Consider you have an existing Quiz Forms. And you want to import few or all fields/ questions from that form into another form. This section covers how to do it.
Click on "Google Forms"
After clicking "Google Forms" Google Picker opens where you can choose any Form to build a new Form or add new fields to the existing one.
Form Builder automatically check the selected form is a quiz or not .
If the selected form is Quiz then it will ask a user to convert the current working form to quiz form.
Click on CONVERT button to convert the current working form to quiz form.
If you do not want to convert the current working form to quiz just click on CANCEL button.
You can see the selected form name appearing just below the app buttons.
You can access the selected form by clicking on the Open in New icon
Form Builder lists all fields and makes fields/questions available for you.
You can shuffle the questions by clicking shuffle icon.
Quiz Fields properties are preconfigured such as points, feedback (general, correct answer and wrong answer) and URL links.
Choose the position where the fields need to be imported.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button.
If you want more fields from other forms, you can click on Change Form Button and do the same steps again.
That's it, your Quiz Form is ready.
Note: There are some types in the Form API such as VIDEO. these are unsupported types in Form Builder so you can not import these fields.
Build Form from Google Sheet
Consider you have the questions/fields for the form in a Google Sheet. And you want to build a Google Form using that data.
Click on "Google Sheets"
After clicking "Google Sheets" Google Picker opens where you can choose any Sheet to build a new Form or add new fields to the existing one.
After selecting the sheet you can see the sheet name just below the app buttons.
You can access the selected sheet by clicking on the Open in New icon
After choosing sheet, Form Builder will list all the tab name in Choose Tab drop-down, now you need to select the one of the tab name form drop-down.
There are 3 type of pattern i.e Questions, Question and Answer and Quiz
Below are the steps how to import from Questions, Question and Answers and Quiz
How to import from questions
Select the Questions pattern
Default range will be A1:K10 i.e first 9 rows of a selected tab
In questions pattern type every cell in a sheet is consider as question.
Form Builder lists all fields and makes fields available for you to import
You can change the range and hit GET button to refresh the list of fields/ questions
You can shuffle the questions by clicking shuffle icon.
The default type of each question is short answer in question pattern
If you want to change the type you can change in two ways
First method is by simply selecting from drop down.
Second method is by clicking setting icon.
This is the best method to change the type or configure the question.
Choose the position where the fields need to be imported.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
There are some types in the Form API such as VIDEO, FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
Sample sheet data
In questions every cell in a sheet is consider as question.
First row to be expected as header in a sheet.
So the default type of every question is short answer in questions pattern.
By default the first 9 values of column A cells will be selected excluding header . You can see in the above sample data.
How to set Configuration
Configuration example:
Example consider the question type is short answer and you want to change to multiple choice you can easily change its type or even its option values also can be easily change.
You can set options in 2 ways.
First method is by entering comma separated value. which is straightforward.
Second method is by giving range. enter the range and you will see the option below.
If any delimiter in a any cell check the delimiter checkbox and click save. your configuration is done.
If the question is fully configured then setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
That's it, your Form is ready.
How to Import from question and answer
Select the Question and Answers pattern
Default range will be A1:K10 i.e first 9 rows of a selected tab.
Select "Range include header" to apply Automatic Mapping. This will set fields configuration automatically.
You can also configure manual too by selected each columns as below steps
Select the Question at column from the drop-down.
If your sheet have descriptions column then select the descriptions column from the drop-down.
If your sheet have required column then select the required column from the drop-down.
If your sheet have types column then select the types column from the drop-down.
Select the Starting answer column from the drop-down .
Select the Ending answer column from the drop-down .
Select the Other at column from drop-down. this column is only applicable to option types fields(Multiple choice, Check box and Drop-down)
We can use delimiter only when one cell has multiple options with a separator (example: ",")."
You can refer the sample data below.
You can change the range and hit GET button to refresh the list of fields/ questions
Form Builder lists all fields and makes fields available for you to import
You can shuffle the questions by clicking shuffle icon.
The default type of each question is either short answer or multiple choice in question and answer pattern
If question has options then its type is multiple choice else short answer.
If you select the type column then specified type will to set to the questions.
Form Builder have an option to configure rapidly type (for example If you want drop down , in place of Multiple choice.
If you want to change the type you can change in two ways
First method is by simply selecting from drop down.
Second method is by clicking setting icon.
This is the best method to change the type or configure the question.
Choose the position where the fields need to be imported
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
There are some types in the Form API such as VIDEO, FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
That's it, your Form is ready.
Sample 1: sheet data
Form Builder automatically lists all fields. you just need to tell the Form Builder which column is what in sheet.
Select "Range include header" to apply Automatic Mapping. This will set fields configuration automatically.
In the above sample data, column B contains the all the questions.
You can see column C contains different types. if type is not matched then default type will be short answer.
Column D is staring column of answer.
Column F is ending column of answer.
Column G is required column.
If sheet have Type as Scale. It expect 4 comma separated value from answer started column of first cell. syntax is [lower-bound, upper-bound, lower-label,upper-label]. you can see the Rating question is type of scale it is having 4 comma separated values in one cell.
Lower-bound value is either 0 or 1 and upper-bound values will be between 3 to 10.
If sheet have Type as Grid(Multiple choice grid) or Checkbox Grid. it expect rows and column values.
Provide comma separated row value in first column of answer start cell and column values comes immediate next cell as above sample data
Sample 3: sheet data having multiple answers in one cell
It is also possible that one column have all options.
You can see the column B have multiple value separated by comma.
To import this format you need to check the delimiter and provide the delimiter.
In this sample data delimiter is "," and default delimiter is also ",".
You just need to check this delimiter and enter whatever delimiter you have in your sheet. Before clicking the GET button .
If you did not check the delimiter or enter wrong delimiter it will make only one option.
How to set Configuration
Configuration example:
Example consider question type is multiple choice and you want to change to Drop down you can easily change its type or even its option values also can be easily change.
You can change the type either in main GUI just by selecting any type from drop down or in configuration setup drop down.
Using configuration is best practice. you can see the all the configuration before import.
If the question is fully configured then setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
That's it, your Form is ready.
How to Import from Quiz
Select the Quiz from pattern
Default range will be A1:K10 i.e first 9 rows of a selected tab.
Select "Range include header" to apply Automatic Mapping. This will set fields configuration automatically.
You can also configure manual too by selected each columns as below steps
Select the Question at column from the drop-down.
If your sheet have descriptions column then select the descriptions column from the drop-down.
If your sheet have required column then select the required column from the drop-down.
If your sheet have types column then select the types column from the drop-down.
Select the Starting answer column from the drop-down .
Select the Ending answer column from the drop-down .
Select the Other at column from drop-down. this column is only applicable to option types fields(Multiple choice, Check box and Drop-down)
You can use delimiter only when one cell has multiple options with a separator (example: ",")."
You can refer the sample data.
Form Builder lists all fields. you just need to tell the Form Builder which column is what in sheet.
For example type column. In the sample data type column is present at Column B. Like this you need to configure however you needed such as points, correct answer etc.
If you want to set advance properties such as correct answer feedback, incorrect answer feedback, correct answer URL and incorrect answer URL.
Click on advance button to set these properties and select the appropriate column.
click on GET button to lists all fields.
Form Builder lists all fields and makes fields available for you to import
The default type of each question is either short answer or multiple choice in quiz pattern.
If question has options then its type is multiple choice else short answer.
If you selected the type column then specified type will to set to the questions.
Form Builder have an option to configure rapidly type (for example If you want drop down , in place of Multiple choice.
You can shuffle the questions by clicking shuffle icon.
You can change the range and hit GET button to refresh the list of fields/ questions
If you want to change the type you can change in two ways
First method is by simply selecting from drop down.
Second method is by clicking setting icon.
This is the best method to change the type or configure the question.
Choose the position where the fields need to be imported
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields. This action cannot be reverted.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
There are some types in the Form API such as VIDEO, FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
That's it, your Quiz Form is ready.
How to set Configuration
Configuration example:
Example consider question type is multiple choice and you want to change to Drop down you can easily change its type or even its option values also can be easily change.
You can change the type either in main GUI just by selecting any type from drop down or in configuration setup drop down.
Using configuration is best practice. you can see the all the configuration before import.
If the question is fully configured then setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
Sample 1: quiz sheet data
Form Builder automatically lists all fields. you just need to tell the Form Builder which column is what in sheet.
Form Builder supports Automatic Mapping. which means the header are automatically mapped inside add-on. please check the Automatic Mapping feature.
In the above sample data column A contains the all the questions.
You can see column B contains different types. if type is not matched then default type will be short answer.
Column C is staring column of answer.
Column F is ending column of answer.
Like this you need to configure however you needed such as points, correct answer etc.
If you have multiple correct answers in a sheet put "," comma between correct answer.
If you have multiple correct URL links or incorrect URL links in sheet put "," comma between URL links.
"," comma is default delimiter or separator in correct answer and URL links.
If sheet have Type as Scale. It expect 4 comma separated value from answer started column of first cell. syntax is [lower-bound, upper-bound, lower-label,upper-label]. you can see the 8th question is type of scale it is having 4 comma separated values in one cell.
Lower-bound value is either 0 or 1 and upper-bound values will be between 3 to 10.
Build Form from Google Docs
Consider you have the questions/fields for the form in a Google Docs. And you want to build a Google Form using that data.
Click on "Google Docs"
After clicking "Google Docs" Google Picker opens where you can choose any Google Docs to build a new Form or add new fields to the existing one.
After selecting the Document you can see the docs name appearing just below the app button.
You can access the selected Document by clicking on the Open in New icon
Form Builder lists all fields and makes fields/questions available for you
You can shuffle the questions by clicking shuffle icon.
Choose the position where the fields need to be imported.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields. This action cannot be reverted.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
You can configure the question i.e its type, option values by clicking setting icon.
How to set Configuration
Configuration example:
Example if question type is multiple choice and you want to change to drop down you can easily change its type or even its option values also can be easily change.
If the question is fully configured then setting icon color will change.
Example of fully configured if the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields from other document, you can click on Google Docs Button and do the same steps again.
That's it, your Form is ready.
Sample Document
Sample document has 3 question and each question have a list of bullet values
If a question have text and followed by bullet values then form builder automatically make as questions option and its type is set to be multiple choice.
If the question does not have any bullet values then its type is set as short answer.
You can set required property by making question as bold font
If question is heading 1 style then it is consider section type
Form builder also support Image type.
Build Form from Google Slides
Consider you have the questions/fields for the form in a Google Slides. And you want to build a Google Form using that data.
Click on "Google Slides"
After clicking "Google Slides" Google Picker opens where you can choose any Google Slides to build a new Form or add new fields to the existing one.
After selecting the Slide you can see the slide name appearing just below the app button.
You can access the selected Slide by clicking on the Open in New icon
Form Builder lists all fields and makes fields/questions available for you
You can shuffle the questions by clicking shuffle icon.
Choose the position where the fields need to be imported.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields. This action cannot be reverted.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
You can configure the question i.e its type, option values by clicking setting icon.
Configuration example
Example if question type is multiple choice and you want to change to drop down you can easily change its type or even its option values also can change easily.
if the question is fully configured then setting icon color will change.
example if the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields from other document, you can click on Google Slides icon button and do the same steps again.
That's it, your Form is ready.
Sample Slide
A sample slide has 3 question and each question have a list of bullet values
If a question have followed by bullet values then form builder automatically make them as questions option and its type is set to be multiple choice.
If the question does not have any bullet values then its type is set as short answer.
Form builder also support Image type.
Enjoy simplified Google Form Building !