AnsweredAssumed Answered

A couple easy questions for a Nintex Pro...

Question asked by calmaguer on Dec 19, 2017
Latest reply on Dec 22, 2017 by calmaguer

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(",", [ColumnName])),TRUE),IF(ISERROR(FIND("&", [ColumnName])),TRUE),IF(ISERROR(FIND("!", [ColumnName])),TRUE),IF(ISERROR(FIND("@", [ColumnName])),TRUE),IF(ISERROR(FIND("~", [ColumnName])),TRUE),IF(ISERROR(FIND("#", [ColumnName])),TRUE),IF(ISERROR(FIND("$", [ColumnName])),TRUE),IF(ISERROR(FIND("%", [ColumnName])),TRUE),IF(ISERROR(FIND("*", [ColumnName])),TRUE),IF(ISERROR(FIND("(", [ColumnName])),TRUE),IF(ISERROR(FIND(")", [ColumnName])),TRUE),IF(ISERROR(FIND("-", [ColumnName])),TRUE),IF(ISERROR(FIND("+", [ColumnName])),TRUE),IF(ISERROR(FIND(":", [ColumnName])),TRUE),IF(ISERROR(FIND(";", [ColumnName])),TRUE),IF(ISERROR(FIND("[", [ColumnName])),TRUE),IF(ISERROR(FIND("]", [ColumnName])),TRUE),IF(ISERROR(FIND(".", [ColumnName])),TRUE),IF(ISERROR(FIND("/", [ColumnName])),TRUE),IF(ISERROR(FIND("\", [ColumnName])),TRUE))


But it's not playing nice with question marks and nesting IFs.


Also, I have a choice column (A) (radio button) that has three options.  I would like one of the options to be invisible unless a different choice column (B) (drop down) has a particular option selected.  I know this is possible, but I'm not sure how.

 

 

 

 

Thanks for any assistance!

Outcomes