I have a list with a Nintex form. I would like to do these with Nintex form rules rather than Column / List validation if possible.
First off, I need to disallow forbidden characters from the item title field, with a message that says something like "Your title has forbidden characters...." if someone tries to enter them.
(I'm using this field to create an excel filename with a workflow later on. Using a regex to scrub the user entry, replace forbidden characters with "-" and update the title with the scrubbed value is working, except when the scrubbed value is a duplicate to one that already exists in the list)
I've been trying to use something like this:
=AND(IF(ISERROR(FIND(",", aColumnName])),TRUE),IF(ISERROR(FIND("&", aColumnName])),TRUE),IF(ISERROR(FIND("!", aColumnName])),TRUE),IF(ISERROR(FIND("@", aColumnName])),TRUE),IF(ISERROR(FIND("~", aColumnName])),TRUE),IF(ISERROR(FIND("#", aColumnName])),TRUE),IF(ISERROR(FIND("$", aColumnName])),TRUE),IF(ISERROR(FIND("%", aColumnName])),TRUE),IF(ISERROR(FIND("*", aColumnName])),TRUE),IF(ISERROR(FIND("(", aColumnName])),TRUE),IF(ISERROR(FIND(")", aColumnName])),TRUE),IF(ISERROR(FIND("-", aColumnName])),TRUE),IF(ISERROR(FIND("+", aColumnName])),TRUE),IF(ISERROR(FIND(":", aColumnName])),TRUE),IF(ISERROR(FIND(";", aColumnName])),TRUE),IF(ISERROR(FIND("n", aColumnName])),TRUE),IF(ISERROR(FIND("]", aColumnName])),TRUE),IF(ISERROR(FIND(".", aColumnName])),TRUE),IF(ISERROR(FIND("/", aColumnName])),TRUE),IF(ISERROR(FIND(""