You need to sign in to do that
Don't have an account?
chok
Tax id validation rule
Hi,
I need to validate tax id field with out being junk.
For example it cant be 9999999999 or 2222222222 or 3333333333.
I know we have to use regex function for particula format but all numbers cant be same
Thanks
Hi,
while using regx its very easy to implement
REGEX(fieldName, "[0]{4,}|[1]{4,}|[2]{4,}|[3]{4,}|[4]{4,}|[5]{4,}|[6]{4,}|[7]{4,}|[8]{4,}|[9]{4,}")
will report you whenever user tries to enter similar digits more than 3 times
if you want to allow less or more repetitive chars then simply change the " {4,} " to like "{3,}" only two same chars or "{6,}" for 5 same chars
Thanks
Akhilesh