Saturday, March 8, 2014

How to Create Data Validation for Phone Numbers in Google Forms

I've always wanted to know more about the Data Validation setting in Google Forms, and yesterday, thanks to a participant question and a Google search, I learned how to make sure phone numbers in forms are entered in a consistent format, in this case, ###-###-####. 

Here's how . . .

Set up your "Phone Number" question in a form, then choose the Data Validation setting and Regular Expression. Insert the pattern below into the box and type your directions to the right.

Data Validation String for American Phone Numbers: ^[2-9]\d{2}-\d{3}-\d{4}$


If not being able to make sure your data is consistent in a Google Form has always bugged you too, well, now you know how to fix it!

Wrong . . .






Wrong . . .







Right!








Post a Comment