cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to concatenate a string to a field

Jump to solution

Hello,

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!

Labels: (1)
0 Kudos
Reply
9 Replies
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

What field type is employee ID? 

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

The field is a text field but I used a reg expression to only enter 5 numbers.  No calculations or incrementing are involved. Just a 5 digit department number.

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

And you want to do this in your form or in the workflow? 

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump 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.

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

Okeydokey so I had a quick play and here is what I did:

  • Column name:  DeptNo = Single Line of Text
  • Nintex Form:  disconnected single line of text control called "InitialDeptNo" added to the form to capture user input for DeptNo
  • Nintex Form:  calculated value control called "DeptNoConcatenation" set up as follows:
  • Nintex Form:  "DeptNoConcatenation" connected to "DeptNo" column in list

Just ran a test, inserted as a user department number 23456 and list saved 10023456.

Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

Hey ,

         Please check this   

Regards

Bashya Rajan A

Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

I tried this too, and it is working as long as I am not hiding the calculated value field (visible = no).

Is there any possibility/best practice to do so?

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

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.

0 Kudos
Reply
Workflow Hero

Re: How to concatenate a string to a field

Jump to solution

Yeah, I was already considering that approach. But I thought there would be something more... elegant.

0 Kudos
Reply