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!








5 comments:

Aaron Holverson said...

Thanks! This helped a lot!

Amy Mayer said...

Thanks for letting me know, Aaron! I wondered if I was the only person in the world who ever needed to know that. I guess it's just YOU and ME!

Theresa Neuser said...

Thank you, thank you, thank you!! This is awesome!

Leia said...

I think it's very usefulll just like Oort. The same thing here: we have a very interesting ibeacon little thing which is very powerfull.

c4d30238-11b3-11e4-aa4b-6be908944cef said...

Thank you very much for sharing this!