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 . . .



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!

Anonymous 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.

Anonymous said...

Thank you very much for sharing this!

ravindra jadeja said...

Opti Farms Keto supports healthy immunity and drives to reduce overweight size
of the body by eliminating bad cholesterol level. It improves ketosis that restricts
fat accumulation inside the body and makes best utilized as energy boost. The supplement
is one of the best selling product over the internet that makes you slim and stylish
Opti Farms Keto


Are You In Need Of A Private Or Business Loans At 2% Rate For Various
Purposes? If Yes; Contact us: +1 (786) 598-8751

*Full Name:_________



*loan amount:_________

*Loan duration:_________


*Purpose of loan:_________

*Monthly Income:__________


*Next of kin:_________

*Email :_________

Thanks and best regards