A Number question is a short-answer, open-text field with validation that ensures entries are numbers.
When To Use It
Use Number questions to collect number responses from your respondents. For example, age or street number.
Validation Options
On the Validation tab, you can choose from a number of different validation options including:
- Force Whole Number
- Force Positive Numbers
- Max Character Count
- Min and/or Max values
Survey Taking
On a desktop and most laptops, the Number question type looks like so.
When optimized for mobile devices the Number question type looks very similar.
By default, survey questions show one at a time on mobile devices to prevent the need for scrolling on smaller screens. You can turn off this one-at-a-time interaction if you wish.
Reporting
Standard Report
In the Standard Report, Number questions report as a Histogram.
See additional compatible chart types
Within the Standard Report there are various chart types available for visualizing your data. The below grid shows which of the chart types Number questions are compatible with.
See what other report types are compatible
The below grid shows which of the report types Number questions are compatible with. If you plan to do some specific analysis within SurveyGizmo this report compatibility chart should help you choose the right question types!
Report Type | Compatible |
---|---|
Standard | |
Legacy Summary | |
TURF | |
Profile | |
Crosstab | |
Comparison | (not available as source question) |
Legacy Summary Report
Number questions report as an Appendix element in the Legacy Summary Report.
Exporting
In the CSV/Excel export, the data is displayed in a single column within the spreadsheet.
A Note on Exporting
If you are collecting numbers that contain more than 15 digits, you will run into the following Microsoft Excel limitation:
If a respondent entered 1234567891011121314 into the Number question, you are likely to see it displayed as follows in Excel: 1.23457E+18 or 1234567891011120000. Note the four zeros at the end.
You can work around this Microsoft Excel limitation within Excel. To do so follow the below steps.
Note: Depending on your version of Microsoft Excel, the steps for this may vary.
- Within Excel, click File > Import.
- On the next screen, select CSV file as the type of file you want to import.
- Select your SurveyGizmo export file when prompted. You will then be taken to the Text Import Wizard.
- On Step 1 of the Import Wizard, select Delimited from the available options. Click Next.
- On the next screen, confirm the Delimiters that you want to use. Tab and Comma will likely be selected by default. Unless you have a need to change this, click Next.
- On the last step of the wizard, locate the column that contains your 15+ digit number and click on this column to select it.
- Once selected, change the Column data format to Text.
- Click Finish to complete the import process. You will be asked to indicate whether you want to import into your existing sheet or a brand new spreadsheet.
- Once selected, change the Column data format to Text.
- Now the 15+ number entered by your respondent will show in full.
Consideration Before Using the Number Question
The validation that is applied to the Number question by default allows for things like $,%, etc. If you wish to only allow survey respondents to record strictly numbers you'll need to instead use a Textbox Question with Regex Validation. Check out our Validating Textbox Answer Formats to learn more!
Admin
— Dave Domagalski on 04/07/2017
@Zahra: Thank you for your question!
You are in the right place! The Number Question Type described in this article will only allow numerical answers to be submitted.
A non-numerical entry will notify your respondents that a number is required.
I hope this helps clarify!
David
Documentation Specialist
SurveyGizmo Customer Experience
— Zahra89najan on 04/07/2017
Hello,
How to strict a text box to numbers only, eg when respondents put alphabet key, it won't appear in text box? Thanks in advance
Admin
— Bri Hillmer on 08/14/2015
@Susan: Thanks for taking a look at our documentation! This can definitely be achieved within SurveyGizmo though you would need to use our Custom Scripting language. Here is a great scripting resource for doing math within custom scripts:
http://script.surveygizmo.com/help/article/link/working-example-user-defined-functions
I hope this helps!
Bri
Documentation Coordinator/Survey Sorceress
SurveyGizmo Customer Support
— Susan on 08/13/2015
Can SurveyGizmo do math? We are a business coaching company and help clients increase their revenue. We want to include survey questions asking clients about revenue growth as a result of working with us. We can have them enter their average monthly revenue for the 6 months prior to working with us. Then we can have them enter their average monthly revenue for 6 months after working with us.
Can Survey Gizmo do the math for us to determine the percentage?
1.) Subtract past revenue from current revenue.
2.) Divide the total revenue growth by the revenue from the previous year
3.) Multiply the result by 100 to calculate the total revenue growth as a percentage