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}$
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!
0 nhận xét:
Đăng nhận xét