Solved: Data type characters validation? - Page 2

techno_gateways · 10-27-2019 02:34 AM

Lets say my form has three field

Name
Mobile Number
Civil ID
Now all 3 field are different in a way i want to limit the name characters to 10 Max with no special characters allowed to enter also no numbers
Mobile number should be 10 digits no less no more, no special characters, no alphabets
CIVIL ID can be alphanumeric but should be 13 digits exact any deviation from this formats it should not allow user to submit data

How to do this in AppSheet not able to find any solution to my problems also how to customize error message for each of this validation…any help would be great

Suvrutt_Gurjar

Hi @techno_gateways,

Thank you for the update. Could you check the setting of 'Reset on edit" column?

Also could you please try settings as below?
Column Type: Phone as mentioned in earlier post. This willallow youto make the mobile number field callable.

Expression in valid_if setting

AND(NUMBER([_THIS])>=5555555555, NUMBER([_THIS])<=9999999999)

View solution in original post