Allow Only text and number

[Mr_Smile]

How can allow only number and text in form column.

[Suvrutt_Gurjar]

Please try in the valid_if of the column

Edit: Minor changes done to the expression.

Text Validation using List Subtraction and an EnumList of Allowed Values Tips & Tricks 💡

Text validation in AppSheet can be a little challenging. [image] There’s no RegEx, and you have to nest 26 SUBSTITUTE()'s just to validate for letters only. And you can nest more SUBSTITUTE()'s for numbers and special characters, but not apostrophes. This sample app uses a different approach; An EnumList table that stores the list of allowable characters, to be reused for validating multiple columns throughout the app-- or for generating lists for buttons and dropdowns. Text Valida…

[Mr_Smile]

Alright, I’ll try.

[Mr_Smile]

Not working

[Suvrutt_Gurjar]

Details please