I am trying to concatenate a string to a field and It has been a challenge. All I want to do is add the string "100", for instance, at the beginning of the employee ID. This string will be placed under the employee ID column on the list when the Nintex form is submitted..
I have tried to create the employee ID field as a calculated field and use the concatenate formula to add "100" to the beginning of the employee ID, but it does not work.
I have also created variables and modules within the Nintex workflow (Query list, set field value, reg expression) and it's still not working.
What am I doing wrong? Any help would be appreciated. Thanks!
Solved! Go to Solution.
The process goes like this:
I created a list, created the workflow and variables and the nintex form was created.
To use the department number field as an example. When the user/requestor enters info on the form, the info is placed under the corresponding list column (e.g., department number entered on the form goes under the department number column of the list).
What I want to achieve is to add/concatenate the number "100" before the department number. For instance if the department number is 23456, I want "100" placed before it (e.g.10023456). this should be consistent for all department numbers entered.
Okeydokey so I had a quick play and here is what I did:
Just ran a test, inserted as a user department number 23456 and list saved 10023456.
hmmm not sure about best practice but I would normally "send to back" this field behind something else so that I don't have set visible = no. seems a bit "fudgey" but it works.