You need to sign in to do that
Don't have an account?
Rakul Srivastav
Formula for Validation error in flows
I need to add a validation error message for an input in Flow.
I have a Phone field where I have maintaned a validation, where the phone number should be of length 10, it should not start with 1. I'm using the below formula.
AND( LEN({!School_Phone_Key})=10,
NOT(REGEX({!School_Phone_Key} ,"^[a-z A-Z]*$")) ,
NOT(LEFT({!School_Phone_Key}, 1) = "1")
)
Now I also need to check if any symbol is presnt in the field, it should be restricted if the 10 digit number has any symbol. Can someone please guide me with the formula.
You should just add ^(([0-9]{3}) |[0-9]{3}-)[0-9]{3}-[0-9]{4}$ to the pattern match
It's not a program, I need a validation rule for phone field which needs to have the conditions:
1) length of phone number field should not be greater than 10
2) the first number should not be 1
3) the field should not allow any characters or alphabets, only numbers allowed.
The formula i have is working for points 1,2 and i need help for the 3rd point. It's a validation rule i would need to add in FLOW