Perform Phone number and email validatio

Avishek1

Dear Expert,

Can you please help me with validation of a phone number and email column.

Phone number column need to be validated with 10 digit and email column to be validated cell value should have @ and .(dot) in entry

Kenda

Hey @Avishek1 

Here are two formulas to create new fields that should help you out...

To check the phone number field:

iif(IsNumber([Phone]) && Length(tostring([Phone]))=10, "Valid", "Invalid")

This first ensures the value is a number then it also checks that the length of the value is 10, if so, the new field will say valid. Otherwise it will say invalid.

To check the email field:

iif(Contains([Email], "@") && Contains([Email], "."), "Valid", "Invalid")

 This checks to see if the email field contains both an @ and a period. If so, the new field will say valid. Otherwise it will say invalid.

Hope this helps!