Skip to main content
Nintex Community Menu Bar
Solved

Transfer data to List, but cram several fields from one list into one column

  • May 2, 2018
  • 8 replies
  • 35 views

Forum|alt.badge.img+16

Hi all,

 

So i've got a list where the user selects a row (the row has 5 fields)

 

I want to then transfer all of those 5 fields into another List, but put all 5 fields in one column and a new line for each of the 5 fields.

End result would be all 5 fields in 1 field on the other list.

 

I am using the transfer data rule, and can put the 5 fields into one column, but it's all next to each other.

 

My question is, how do i get each field onto a new line???

I tried <br> between the fields and
, neither of which work.

 

Basically here is how i want it to look:

 

PICKER LIST - Row 1 (field1, field2, field3, field4, field5

 

Add New Row

Transfer data to this New Row

 

NEW LIST - Row 1 (field1)

field1 should look like this

 

Field1

Field2

Field3

Field4

Field5

 

Come on K2ers, whats the magic character for the new line between items so that i can chuck everyone into one Column?

 

Thanks

 

Best answer by Albarghouthy

Hi Sharpharp1,


 


In this case you will need to create an expression, find attached


8 replies

  • May 2, 2018

Hi,


 


Please check this community thread:


 


http://community.k2.com/t5/K2-blackpearl/Line-Feed-in-Text-Area-Control/td-p/80196


 


 


Hope it helps.


 


Note: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.

Albarghouthy
Forum|alt.badge.img+16

Hi Sharpharp1,


 


<br> should work, you might be missing the literal property on the column, make sure its checked since you're using HTML tag


 



Forum|alt.badge.img+16
  • Author
  • Scout
  • May 2, 2018

Mustafa,

 

It's not on the List, It's tranferring the data to the EDIT/ADD Line.

 

I want to do it this way, so the user can Accept or delete that record.


Albarghouthy
Forum|alt.badge.img+16
  • Scholar
  • Answer
  • May 2, 2018

Hi Sharpharp1,


 


In this case you will need to create an expression, find attached



Forum|alt.badge.img+16
  • Author
  • Scout
  • May 2, 2018

Hi Mustafa,

 

It won't accept the expression, there seems to be an extra value required, see below

 


Albarghouthy
Forum|alt.badge.img+16

I cannot see the image for some reason, please add as an attachment 


Forum|alt.badge.img+16
  • Author
  • Scout
  • May 2, 2018

Attached



Albarghouthy
Forum|alt.badge.img+16

Hi Sharpharp1,


 


the expression should only take  3 parameters, not sure why you have 4 parameters. 


I think you are adding the Replace function in the wrong place, make sure you add it right before the parameter of the Decode function