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.
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
Nope.
You could use a formula in the spreadsheet itself to validate after the save.
User | Count |
---|---|
42 | |
28 | |
24 | |
22 | |
13 |