AnsweredAssumed Answered

Length() from Numeric Field

Question asked by gdgonzal on Nov 10, 2017
Latest reply on Nov 27, 2017 by kdelcastillo

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?

Outcomes