I have this formula and the field is string:
lookup("Budgets","id",trim(parseLookup(Rubrica,false)),"Title")
List of budget
In form start by 2
I have this formula and the field is string:
lookup("Budgets","id",trim(parseLookup(Rubrica,false)),"Title")
List of budget
In form start by 2
Hi Jose,
looks like forms is recognizing that you have a number here. In that case leading zeros are always removed. You could try do do some calculations with "startsWith" and the length of the string to readd missing zeros but I won't to that until it's really necessary.
Best regards
Enrico
But in the same field if it starts with a letter, for example, "P0262", appears correctly, so the "form nintex" recognizes that the field is a string.
Yup. Had the same effect recently where I had a date in a text box and Nintex even stripped the dots from my date string and counted it as number, totally ruining what I was going to do. Didn't come over this. As long as there is no letter in the string it is held as a number :/
yes, that's known "feature" of calculated value control, everything what can be converted to a number is considered to be number, regardless of control setup.
you can workaround it by enforcing the value to be string - either by prep-/appending some non numeric character or by passing value through a function that returns string output, eg tolower()
see this https://community.nintex.com/message/34514?commentID=34514#comment-34514
I tried to do:
toUpper(trim(lookup("Budgets","id",trim(parseLookup(Rubrica,false)),"Title")))
but, don't works
does it still trim leading zero if you try following?
"x" + lookup("Budgets","id",parseLookup(Rubrica,false),"Title")
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.