cancel
Showing results for 
Search instead for 
Did you mean: 
terencepalmer
Nintex Newbie

How to format TEXT in Nintex Workflow when setting a value?

Hello,

In a normal SharePoint Issues App you can create a new column as a Calculated (calculation based on other columns)  Type called say "External Reference". You can use the formula section to format the result eg: if your Issue ID is 17 then the formula  "LCS"&TEXT(ID,"0000") will format the Single line of Text to LCS0017 and update the "External Reference". The trouble is that this does not work when the issue is created as the ID does not exist yet so the "External Reference" is not updated

I have used a nintex workflow to using the Set Field value to up the "External Reference" after the issue is created but if I use the same formula "LCS"&TEXT(ID,"0000") my "External Reference" is updated to "LCS"&TEXT(17,"0000")

I would really live to update my  "External Reference" after the issue is created so that it looks like LCS0017.

Any help or guidance would be appreciated.

0 Kudos
Reply
1 Reply
terencepalmer
Nintex Newbie

Re: How to format TEXT in Nintex Workflow when setting a value?

Hello

This was resolved by

  1. Adding a set variable step and creating a strLCSref text sting variable. and setting the variable to equal ItemProperty:ID
  2. Then with the Set Field value, set the  External Reference to equal LCSfn-PadLeft({WorkflowVariablestrLCSref},4,0)
Reply