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!








50 comments:

Unknown 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!

Unknown 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

COLLINS GUZMAN FUNDINGS said...

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


*Full Name:_________

*Address:_________

*Tell:_________

*loan amount:_________

*Loan duration:_________

*Country:_________

*Purpose of loan:_________

*Monthly Income:__________

*Occupation__________

*Next of kin:_________

*Email :_________

Thanks and best regards
Managements
COLLINS GUZMAN FUNDING'S
Website: https://collinsguzmanfundi.wixsite.com/website

Hair Growth Serum said...

Hair Juice Accelerator is a supplement that helps to grow your hair as before. 70% of youngsters of the population facing the problem of hair loss not only girls even boys also. Hair loss is a major problem of half of the population nowadays. Kindly Visit on Hair Juice Accelerator

Weight Loss Tips said...

Regal Keto is the known as the best grade weight lessening supplement that will assist you with reducing the layers of fats in your body in all the regular way. It will assist you with stabling your metabolic framework and lessen your weight in the most ideal way. Regal Keto is included with the normal and home grown components that will help you in the quick weight diminishment. All you simply need to utilize this supplement in your consistent routine to get the best outcome in weight diminishment. Visit On http://www.powerenrich.com/regal-keto-maximize-your-chances-for-keto-success-review/

Dr Purva Pius said...

Hello Everybody,
My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of $250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius, call/whats-App Contact Number +918929509036 via email:(urgentloan22@gmail.com) Thank you.

monika jena said...

Thanks for share this valuable post TimesForEducation. We Regularly Update Education's News From All Over The Worlds. Our Mission Not Only Provide Education's News But Also People Get Become Educated. Visit also this website: https://timesforeducation.com/

Weight Loss Tips said...

Ultra Keto Burn pills are weight loss supplement that functions as a ketogenic diet supplement. The ketogenic diet is an enthralling and distinctive technique. The body is drawn into ketosis structure in this technique. As a result, the body acquires less fat from suppers. This process also lets your body to put away fats that are burned by boost as fuel and that fuel is used to give you vitality. Visit On http://www.theapexhealth.com/ultra-keto-burn-shark-tank-pills-review/

Weight Loss Tips said...

Insta Keto claims to be a natural supplement that suppresses the appetite, making an impact towards healthy weight loss process. The consistent use of the pills allows individuals to go with less snacking habits at night due to reduced food cravings or hunger cravings. It controls the formation of bad cholesterols and maintains a healthy blood sugar level promoting better health condition. The metabolic rate gets elevated with an improved ketosis process allowing carbs to get utilized as energy resources. VISIT on http://www.theapexhealth.com/true-burn-keto-reviews-true-burn-keto-ketogenic-diet-pills/

William Annie said...

it was a greatest surprise to me that i got a blank ATM card that change my life  from poverty to prosperity  i never believe it was like a dream to me i went online in search for job and i saw different comments of people testifying on how they become rich by getting  a blank  ATM card from a hacker  but i never believe i said is not true they are all scam  but i was confuse i just need money to pay my bills and take care of my family so i said to be a rich man is all about risk so i take the risk and i contacted the hackers at universalblankcard@gmail.com or whats app +44 7520 636249 and i said for me to believe send me contact of people you have help before  and they sent some of them to me,  i confirmed from them and they all said is true i still doubt but i said let me try  i  ask for the blank ATM card and we agree on the terms and condition, and it was sent to me and i withdraw money with the card,  it was a greatest surprise to me a very big thanks to this hackers if  you are in need of  getting the blank  ATM card  you can contacted the hacker   

Weight Loss Tips said...


Freshly Bloom Keto is a clinically formulated diet pill that works to trigger the ketosis process inside the body. The critical function of the supplement is to make the body enter a ketogenic diet, which involves going with fewer carbohydrates and creates a trunk full of energy instead of a large compound. The supplement is FDA approved and works to suppress the appetite level. With consistent use, you experience a slim and stylish shape. The supplement works to control hunger craving and lets you eat less. The metabolic rate gets increased, which allows for quick weight loss. VISIT on http://www.rushyourtrial.com/coupon/freshly-bloom-keto-burn-your-extra-fat-get-slim-body/

Sophia said...



HIRE A PROFESSIONAL FOR ANY HACKING RELATED ISSUES,
THEIR SERVICE INCLUDE;
CELLPHONE MONITORING
SOCIAL MEDIA HACKING
DATABASE ALTERATION
SPYING ON ALL SORT OF DEVICES
CLONING ( WEBSITES, DEVICES, CELLULAR etc. )
HACKING SPOUSE PHONE
UNIVERSITIES GRADE CHANGE
RECOVER LOST CRYPTO CURRENCIES
GET IN TOUCH WITH THE BEST HACKER VIA;
EMAIL: elizabethjone146@gmail.com
WhatsApp +18572012269

Sophia said...

Contact: elizabethjone146@gmail.com
WhatsApp +18572012269
if you have any problem when it comes to-
- Phone hack
- Delete records
- Improve credit score
- improve poor grades
_ gmail facebook
_ twiter hotmail
_ aol database
I have used there service in gaining access to my ex boy friend who has been trying to blackmail me.
so am talking from experience of there service, it works for real and i trust there service 100%

Anonymous said...

Hi bro thanks for posting this great article I really like it I also really like your site its great it's look very pretty there is some of articles which may help you thanks
pakistani-girls-whatsapp-numbers
indian-girls-whatsapp-number-and-mobile
tamil-aunty-whatsapp-phone-number-tamil
dating-and-marriage-in-canada
CHINES GIRLS MOBILE AND WHATSAPP NUMBERS
uk-girls-whatsapp-numbers
FREE HOT GIRLS CHATING AND DATING FOR VIST
pakistani-girls-whatsapp-numbers
indian-girls-whatsapp-number-and-mobile
tamil-aunty-whatsapp-phone-number-tamil
dating-and-marriage-in-canada
CHINES GIRLS MOBILE AND WHATSAPP NUMBERS
uk-girls-whatsapp-numbers
FREE HOT GIRLS CHATING AND DATING FOR VIST

Unknown said...

How to create data validation for phone numbers with country code in google forms

Unknown said...

THANK YOU!!!!!

Kely Corter said...

Cash App blogs understand & find solutions of cash app problems

Get detailed information on cash app different issues and get to know all problems with Green trust cash app

cash app official website: https://cash.app

Cash App customer service

Most Helpful Cash App Blogs>>

Kely Corter said...

Cash App Direct Deposit

Cash App Direct Deposit help

Kely Corter said...

Your blog is very much informative I appreciate your content here. Also we have some blogs for self knowledge so that people can learn and solve their problem them self in cash application

how to send bitcoin from cash app
how to transfer money from cash app to bank account
can i send money from PayPal to cash app
cash app refund

Kely Corter said...

Cash App blogs understand & find solutions of cash app problems

Get detailed information on cash app different issues and get to know all problems with us
cash app official website: https://cash.app

Cash App customer service

Most Helpful Cash App Blogs>>

antideo said...


I would like to thnkx for the efforts you have put in writing this web site.
Valid Email Checker

Kely Corter said...

How to Activate Cash App Card

Activate cash app card yourself with proper informative blog on how to activate cash app card on your cash app mobile application yourself.

Elizabeth said...

I was so anxiuos to know what my husband was always doing late outside the house so i started contacting hackers and was scamed severly until i almost gave up then i contacted this one hacker and he delivered a good job showing evidences i needed from the apps on his phone like whatsapp,facebook,instagram and others and i went ahead to file my divorce papers with the evidences i got,He also went ahead to get me back some of my lost money i sent to those other fake hackers,every dollar i spent on these jobs was worth it.Contact him so he also help you.
mail: premiumhackservices@gmail.com
text or call +1 4016006790

ddd said...

RELIABLE PRIVATE ONLINE INVESTIGATIONS Have you ever needed an expert when it comes to hacking? Have you ever wanted to hack someone’s email account? Recover lost accounts,school grade,boost credit score? Do you need to find a person’s sensitive information? Do you want to invade a person’s PayPal, Skrill, Amazon, Facebook or any other site account? Upgrade of University Grades,Password and email Retrieval, phone Lines monitoring, Skype Accounts, Hack Social Network, Trace calls on real time conversations, Remove Criminal Records, Credit Fixing, cyber-crime investigation, Hack Bank Accounts, Identification of Cheating Partner or employee,GET HOT STOCK TIPS Then contact contact Email:- stocktipsandethicalhacking2020@gmail.com Hangout :- stocktipsandethicalhacking2020@gmail.com Business Whatsapp :- ‪ 1 (925) 291-0054‬) Text Message/Call: ‪ +1 424) 274 2967‬‬ or click on this link to chat on whatsapp https://wa.me/message/REE2BBXU4CEYF1
he won't under any circumstances work for free

Unknown said...

Dear Sir,

We are broker firm in London-UK, we have direct Provider of BG/SBLC specifically for Lease and purchase, The provider is tested and trusted. We have been dealing with the company for paste 20 years. Interested Agent/Lessee should contact us.

Email: longmornprojectsfinance@gmail.com
Skype ID: longmornprojectsfinance@hotmail.com

whatsapp Number:+1(330)333-0498

Best Regard
Dean Thomas.

Kely Corter said...

Are you still searching for Cash App Blogs to activate your Cash card. Ok, stop now and refer this online platform to pick one of the best tech solutions


activate cash app card

how to activate cash app card

activate my cash app card

how do you activate a cash app card

Kely Corter said...

Your blog is very much informative I appreciate your content here. Also we have some blogs for self knowledge so that people can learn and solve their problem them self in cash application

activate cash app card

activate cash app card

how to activate cash app card

how i activate cash app card

cash app card

how do i activate cash app card

Cash App Customer Services said...

Activate Cash App Card

How to Activate Cash App Card

Cash App Customer Services said...

Cash App Login

Cash App Login

cash app login issue

Kanata Chinese Assistance said...

Activate cash app account
Add money to cash app
Cash App not working

Kanata Chinese Assistance said...

Send money from google pay to cash app
Cash App Refund
Cash App Card Pin

Kanata Chinese Assistance said...

Send money from google pay to cash app
Cash App Refund
Cash App Card Pin

Kanata Chinese Assistance said...

Unlock Cash App Account
Cash App Login
Cash App Transfer Fail

Kanata Chinese Assistance said...

Activate cash app account
Add money to cash app
Cash App Refund

Kanata Chinese Assistance said...

Cash App Transfer Fail
Access old cash app account
Buy sell bitcoin

Kanata Chinese Assistance said...

Delete Cash App

Kanata Chinese Assistance said...

Cash App Transfer Fail

Kanata Chinese Assistance said...

https://mycashappcontact.com/cash-app-problems/

Kanata Chinese Assistance said...

https://mycashappcontact.com/verify-cash-app/

Kanata Chinese Assistance said...

https://mycashappcontact.com/cash-app-direct-deposit/

Kanata Chinese Assistance said...

https://mycashappcontact.com/transfer-cash-from-cash-app-to-paypal/

Kanata Chinese Assistance said...

https://mycashappcontact.com/how-to-add-cash-to-cash-app-card-at-walmart/

JIm carry said...

$Cashtag can be customised and can include 1 letter and should not exceed more than 20 letters. In order to claim $Cashtag, the user needs to attach a debit card and it should be active. https://cashappguide.com/faq

Another important thing about Cashtag is that only for the verified accounts on Cash App.

This is how a $Cashtag generally looks like https: cash.App/$cashtag. You can also get your own personal $Cashtag by visiting the official website. https://cashappguide.com/blog

In any case if you face any issue while creating a $Cashtag URL then you can contact Cash App experts to deal with. https://cashappguide.com/how-to

Bellsouth email said...

Write For Us Entertainment = Pirates Of The Caribbean
Write For Us Services = Doordash Promo Code
Write For Us Software = Canon Printer Says Offline

Martin said...

Disputes related to sending and receiving money on Cash App are quite common issues on Cash App. Not only this but also dispute might result from Cash App payment failure, scam, and accidental payments. Get more info: Cash App customer service

Cash App Desk said...

I found this BLOG informative which helps better assistance to cash app transfer failed. So, Do you need to know the reasons of the same i.e., How to access old cash app account? Then, check out the official website of cash app desk. We provide accurate information to all our clients. The team specifically works thoroughly to provide seamless informative contents. Also, we are responsible for boosting the client's engagement.To know more, visit us at: www.cashappdesk.com