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!








63 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

Cash App Desk said...

This blog consists of good information. I follow all the mentioned pointers and get away with my problem. So, if How to access old cash app account without Phone Number then there might be a possibility that the Cash App server may be down. If this happens, you should not worry. The cash app desk will help you to get the money that is deducted from your account.To know more, visit us at: www.cashappdesk.com

Mark Tayler said...

If you have recently downloaded a Cash App on your phone then you must know about the Cash App refund process. However, the Square Cash App perfectly handles most of the payments. But there is no guarantee that you will not ever face any kind of problem. People who use Cash App they know that once in while Cash App payments might fail. And when a payment fails on Cash App then the user needs to apply for a Cash App refund. There is only one way to get a refund from Cash App. And that method requires you to go through the Cash App mobile application and get in touch with Cash App customer service. Also read about - Cash App Direct Deposit Failed: Reasons and Solutions Guide

Quintero Solutions said...

If you are searching for the online marketing services for your business, then your search ends here. We, Quintero Solutions count as a leading digital marketing company india, India offer wide range of excellent Digital Marketing Services at the low cost. Our service includes seo services), Keyword Research Analysis, Content Creation & Optimization, Social Media Optimization (SMO), Email Marketing, and Website Design & Development Services to all sized business. We also provide web development services like iPhone & Android App Development, Angular Development, eCommerce Development, etc.

i-cashapp.com said...

Drives in the right manners are the main perspective for the activation of the cash app card. using you are hoping to Activate Cash App Card, don't get stressed, essentially you can take the direction of the Cash App support team. They will productively direct for the enactment of the cash app card through which you would have the option to use it according to your necessities. And hence, you should hold fast to rules and guidelines as far as utilizing the cash app card is concerned.

Read more:-


Activate Cash App Card


Cash App Direct Deposit


Cash App Login Online


Where can I load my cash app card?

Edwin Mosley said...


Being healthy and fit isn’t a fad or a trend, it’s a lifestyle. Helping people lead healthy and happy lives through design.

Source: How to Boost Testosterone Naturally
More on: BLY

Thetechie find said...

Your blog is very much informative I appreciate your content here. Also we have some blogs for self knowledge

teamworks starbucks

Travelographers said...

Cash App Payment Declined is one of the most sought after payments apps for mobile users in both the US and the UK. If you are considering signing up for a payment app, you might consider Cash App because it has many of the features that you will need for an easy, quick and safe payment processing. The app has a simple, low-key design, and even beginners can easily recognize the app's functions. This means you will be making money on the go without having to deal with any confusing interfaces.

Website: cashappfix.com

Cash App said...

Why Cash App Won't Let me Add Cash? If your payment fails on the Cash App it is an opportunity there is a chance that your Cash App server could be down. It could be due to an unsupported credit or debit card used to pay cash to Cash App. It is not a problem that your cash isn't debited from your account.
Website: cashappcustomerservicenumber.com

Link Roku Activation said...

Get solution to activate Roku streaming device using Roku com link enter code.

tv.youtube.com/start/roku
roku com link .
amazon.com/mytv

Cash App said...

How To Change Card On Cash App?Never use a credit card for cash advances. The interest rate on a cash advance can be almost double the interest rate on a purchase. The interest on cash advances is also calculated from the moment you withdrawal the cash, so you will still be charged some interest even if you pay off your credit card in full at the end of the month.

Visit Us: cashappfix.com

Arabella Bella said...

How to Become an Aesthetician Requirements to Become an Aesthetician are certified cosmetology experts who cleanse and deal with the pores and skin.
Esthetician Estheticians, additionally referred to as pores and skin care therapists, specialize in beauty remedies of the pores and skin.
Extracellular Fluid Human cells are bathed in fluids each within side the mobileular and out.
Written Communication There are most important varieties of conversation: oral and written. Written conversation includes any sort of message that uses the written word.
Cultural Diffusion The definition of cultural diffusion (noun) is the geographical and social unfold of the one of a kind elements of 1 extra cultures to one of a kind ethnicities, religions, nationalities, areas, etc.
Easement Appurtenant Let’s say you simply offered a brand new domestic on a pleasing piece of lakeshore belongings.
Selective Perception In this lesson, we can talk selective belief and the selective belief principle. Learn greater approximately selective belief from examples.
Neutral Stimulus A impartial stimulus is a stimulus that doesn’t produce an automated reaction. In classical conditioning, a impartial stimulus becomes a conditioned stimulus.
Null Hypothesis A speculation is a hypothesis or principle primarily based totally on inadequate proof that lends itself to similarly checking out and experimentation.
Spongy Bone Cancellous bone, additionally called spongy or trabecular bone, is one of the kinds of bone tissue determined within side the human frame.

Arabella Bella said...

content://com.android.browser.home: The Android cell phone is a complete-featured smartphone. Some default home features such as Web content:// com.android.browser.home/ and various other bloatware attributes continue to be relatively unsatisfactory to see Android devices as a whole.
Jay Cutler Instagram: Jason Isaac Cutler is known as Jay Cutler is an American IFBB Professional Bodybuilder and he has earned that name and fame by working hard.
How to Stay Safe and Secure Online: More than 4.5 billion people use the internet worldwide, which is more than half the world’s population.
What Is Net Working Capital?: Net Working Capital: Net working capital is the characteristic of a company’s current assets and current liabilities.
What Is The Profit Formula?: Profit Formula: While people often use the terms benefit and revenue synonymously, they are quite different concepts in business.
Smith And Wesson Stock: Smith And Wesson Stock: Throughout most of its history, the company formerly known as Smith & Wesson Holdings was best known for its guns.
Trash Compactor: A compactor is a machine or mechanism used to reduce the size of material such as waste material or bio mass through compaction.
starfox marvel : Starfox: Like many of you, I am a big fan of both Nintendo-developed video games, and the recent decade of the connected universe Marvel superhero movies.
Blackboard FCPS: Online blackboard teaching is a new trend followed by universities. The United States first introduces online teaching.
Appvalley VIP: Among those millions of apps that are made for iPhones devices, one app that has made a different place for itself is AppValley.

Kanewillam said...

Need to activate cash app card?
Are you searching to know how to activate cash app card then stop your search because you have found the right site.
At this site, you will know how to activate a cash app card the all you need to do for this is just a click on this link. https://www.cash-app-support-number.com/blog/how-to-activate-cash-app-card/