Hello! I have a Caculated Value field that retrieves a value, from another list, with this formula: lookup(“ContOB”, “RefID”, RefID, “Manager”) .It does get the correct Manager name but in this format: 83;#Lastname, Firstname. How do I get rid of the "83;#" at the beginning of the returned value?
Lookup result: 83;#Lastname, Firstname. How do I get rid of the \83;#\" at the beginning of the returned value?"
+3
+3
I did find the answer: parseLookup(lookup(“ContOB”, “RefID”, RefID, “Manager”),true)
https://ootbtutorials.com/2016/05/02/runtime-function-examples-for-nintex-forms/
Thank you, Nick Hurst!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.