How can allow only number and text in form column.
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](https://community.appsheet.com/t/text-validation-using-list-subtraction-and-an-enumlist-of-allowed-values/38608) 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…
2 Likes
Alright, I’ll try.
Not working
Details please
2 Likes