Hello again! For forms, is there a way for "V...

(Ricardo Gonzalez) #1

Hello again! For forms, is there a way for “VALID_IF” to trigger FALSE if the user submits an answer that is not Roman alphabet only? For example,

JOHN DoE = TRUE JOHN DOE = TRUE Jo1n Doe = FALSE 133 = FALSE John D!E = FALSE

Attempted to search for a solution in previous posts.

(GreenFluxLLC) #2

Hi @Ricardo_Gonzalez. Here are the available Text Expressions. Unfortunately, none of them can do this directly.

The SUBSTITUTE() expression could be used to remove individual characters though. So you could individually remove A-Z and Spaces, then use LEN() to see if any characters remain. It won’t be pretty, but it’ll do the trick.

SUBSTITUTE() is case sensitive, so you’ll have 53 nested expressions (A-Z, + a-z, + space). Then wrap that in LEN()

and it should = 0 for valid entries. Should look something like this:

Valid_If: LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE… ([Name], “A”, “”), “B”, “”), “C”, “”)…

)=0

You might also want to allow “-” for hyphenated names.

Text Expressions help.appsheet.com

(Steven Coile) #3

Nope. :frowning:

(Eloi George) #4

You could use a formula in the spreadsheet itself to validate after the save.