I want to use a field in Nintex Designer (currently trying with the number field) with the minimum of 11 numbers and a maximum of 11 numbers. If the account number has 10 or less, I want to have leading ‘0’’s to get a total of 11. I thought using a rule would do this, but didn’t see it, but not sure if going about it in the right way. Any assistance would be appreciated.
Example, if account number is:
5555555
I would like to add leading ‘0’’s so it would look like this:
00005555555
Thanks,
Lois
+2
Hi
You can create an expression which uses the Pad Left function (https://help.nintex.com/en-US/K2Five/userguide/5.3/Content/K2-Workflow-Designer/Use/ContextBrowser/Functions/Functions.htm#:~:text=Result%3A%20%22ample%22-,Pad%20Left,-Pads%20a%20string) and then replace field value with this expression in a rule.
+2
Thanks so much!! PadLeft is what I needed. I did change from a number field to a text field, not sure if I could have converted to a string, but it was just as easy to switch to a text field.
+2
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.