AnsweredAssumed Answered

Format of Single Line of Text field

Question asked by human.hide@gmail.com on Jan 16, 2018
Latest reply on Jan 16, 2018 by sean.fiene@nintex.com

Hello,

 

Need some help with the format of a single line of text field using Nintex form. I need the control to be invalid if the set format is not followed. It should be in the following format (########-##-##-####). 

 

I was able to accomplish this in the column validation settings using the following formula: where "text" is the single line of text column:

=AND(LEN(text)=22,(MID(text,9,1)="-"),(MID(text,12,1)="-"),(MID(text,15,1)="-"),(MID(text,18,1)="-"))

 

However this is not allowing me to set the error message as I want when filling the form. It is throwing a generic error of something went wrong, please try again.

 

Any help or information is much appreciated. 

 

Regards,

Ronnie.

Outcomes