Forum Discussion
Microsoft Forms (Require Number in Text Field)
Hello Everyone,
I'm sure this probably a really simple question but how do I get Microsoft Forms to require a number entered as a text answer? The reason i'm asking is because I want to make an order form for monitor replacement for my school district but i'm finding that since its a text box they can enter anything. I had 3 responses that had questions and notes tacked into them and want to limit that for the future. Thanks
2 Replies
There is now a way to do this - when you create the question or edit it, there is a set of three dots (...) at the bottom right corner of the question box (next to the "required" option), click on that and select "restrictions". This will give you a set of drop-down menus to select restrictions on the text than can be added by the person completing the form. The default restriction class is "number" and option "is number", which does what you want.
You can do other things like specify a maximum value for the number or a range, you can also specify the class to be text, email, URL or even put a limit on the length
This is also driving me nuts about ms forms. It's typical Microsoft.... create a solution that is based on excel, but don't provide a way to enter a number field. The only available field is a text field and when it submits the data to the excel sheet, it saves it as text, so it is incredibly difficult to even analyze the data later. Microsoft is very unorganized and their teams don't communicate with each other in their development, so I wouldn't expect any solutions anytime soon to such an obvious problem.
