Solved: Lock any symbol entry - Page 2

Sayad · 03-05-2022 09:11 AM

Dear Users

I want your help. how can I lock any symbol entry in the form?

Joseph_Seddik

Write it down instead of copy/paste.
You should put it in the Valid if field.
Also replace the dots “…” with a similar CONTAINS line for each of your undesired symbols.

View solution in original post

Joseph_Seddik

Keep adding as many lines as there are "locked" symbols, one line per symbol.

NOT( OR(
CONTAINS([_This], "@"),
CONTAINS([_This], "#"),
CONTAINS([_This], "$"),
CONTAINS([_This], "%"),
CONTAINS([_This], "&"),
CONTAINS([_This], "/")
))

Read these:

Expressions: The Essentials | AppSheet Help Center

Yes/No Expressions | AppSheet Help Center

View solution in original post