Having researched this a fair bit, I am coming up blank. I need way to only allow alpha numeric characters to be entered into a field. I am guessing some sort of Valid_If expression might help by enforcing any special characters to be deleted or changed. Who’s the AppSheet brains that can help with …

Please try in the valid_if of the column the following expression: AND(ANY(EXTRACTEMAILS(CONCATENATE(SUBSTITUTE([_THIS]," “,”“),”@removespecialincolumn.com")))= CONCATENATE(SUBSTITUTE([_THIS]," “,”“),”@removespecialincolumn.com"), NOT(CONTAINS([_THIS],“-”)), NOT(CONTAINS([THIS],"")) ) Please te…

It would help to identify the challenge if we would first know more details.. like how many characters or numbers the text can contain, what’s the maximum? For example.. if the maximum characters amount is five, it’s much shorter formula than if it’s a long string.

Thanks @AleksiAlkio . I am needing a maximum of 20 characters that can only include A-Z and 0-9.

I am sure @AleksiAlkio will come up with a compact solution. @James_Fussell1 : In the meantime , did you get a chance to test the solution I suggested. It basically makes use of EXTRACTEMAILS() function to discard the special characters. Since Emails can allow Hyphen(-) and underscore (_) , those a…

The straight forward Valid_If expression I am currently using (below) works well, except it will not work for removing " or ’ which is my problem. I have also tried CONTAINS([_THIS],TEXT(“”")), but this doesn’t work either. Any suggestions on this? NOT(OR( CONTAINS([_THIS],“#”), CONTAINS([_THIS],…

If I remember you need to write the trick like.. RIGHT(“A’”,1)

ALPHA NUMERIC CHARACTERS ONLY

AppSheet AppSheet Q&A

Tommy62 August 29, 2023, 8:21pm 2

Schau dir diesen Thread an–> Gewusst wie-so-validation-to-allow-only-alphanumerische-zeichen

Topic		Replies	Views
How to set validation to allow only alphanumeric characters - no symbols etc AppSheet Q&A databases , expressions	5	83	September 30, 2020
Text type should not allow the user to type any number or Special Characters AppSheet Q&A automation	27	138	January 24, 2021
Allow Only text and number AppSheet Q&A ux , databases , expressions	4	51	November 25, 2021

ALPHA NUMERIC CHARACTERS ONLY

AI Suggested topics