App sheet

[anonymous]

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)?

[baba_sawane]

Hi Sanjay,

For 2 : select Email as column type

[Aurelien]

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

ISBLANK() - AppSheet Help

CONTAINS() - AppSheet Help

AND() - AppSheet Help

NOT() - AppSheet Help