Lock any symbol entry

[Sayad]

Dear Users 

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

[Joseph_Seddik · Accepted solution]

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. 

[Joseph_Seddik]

You don't want the user to input symbols, then unfortunately, and strangely enough, you have to list all the unwanted characters.

NOT( OR(
  CONTAINS([_This], "symbol-1"),
  CONTAINS([_This], "symbol-2"),
  ...
  CONTAINS([_This], "symbol-n")
)) 

[Sayad]

Showing error, Which column i input this function.

.

[Joseph_Seddik · Accepted solution]

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. 

[Sayad]

Thank you. one more last Question,
in this function three symbols are locked. How can I have more symbols? 

NOT( OR(
  CONTAINS([_This], "symbol-1"),
  CONTAINS([_This], "symbol-2"),
  CONTAINS([_This], "symbol-n")
)) 

[SkrOYC]

https://help.appsheet.com/en/articles/2357288-or

[Joseph_Seddik · Accepted solution]

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

[Joseph_Seddik]

@Steve Do you know if there are plans to support regular expressions? any hope? Also, if you have a better solution please? Thanks you!

[Steve]

I am unaware of plans to support regular expressions.