1) How can I validate Only Alphabets(letters) in name, it should not include number or any special character?
2) How can I validate only email address(I want user can enter only email address)?
Hi Sanjay,
For 2 : select Email as column type
Hi @Sanjay_Roka
For 1), use this expression in the valid_if expression:
AND(
ISBLANK(EXTRACTNUMBERS([_THIS])),
NOT(CONTAINS([_THIS],".")),
NOT(CONTAINS([_THIS],",")),
NOT(CONTAINS([_THIS],"$")),
NOT(CONTAINS([_THIS],"*")),
NOT(CONTAINS([_THIS],"%")),
NOT(CONTAINS([_THIS],"-")),
NOT(CONTAINS([_THIS],"_")),
NOT(CONTAINS([_THIS],"anySpecialCharacterYouWishToAvoid"))
)
For reference:
Check form input validity (Valid_If) - AppSheet Help
EXTRACTNUMBERS() - AppSheet Help
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |