Hello All:
I have a purchase requisition field within a Nintex Form and I need to set a rule that would allow either 8 or 9 digit length numbers. I thought I would just set a form variable to make this determination at runtime using:
length(MyPurchaseRequisitionField)
However, after testing this using a calculated fielded on the form, I noticed it would return "#value! " if I entered into this field "123" or any fully numeric string. If, on the other hand, I entered "123a" then I would get a correct length of 4.
Obviously length() seems only capable of working with either an alpha or alpha-numeric string and not a fully numeric string.
Originally I had planned on using this variable within a validation rule and the "||" or logic to enable this but without being able to determine the length of a fully numeric string I am stuck.
Does anyone know a way around this or perhaps has another idea of how to accomplish this type of validation?