Hi Sharpharp1,

List views were not designed for this purpose, I can only think of one inefficient workaround which is to add  a data label fpr each column.

For example if you have 5 columns, you will need 5 data labels and then create 'For Each' rule to loop through the list items 

For all rows

Transfer data

in the transfer data action you will need to transfer the smartobject property for each column to the related data label and also pass the data label itself:

If you have a lot of rows, you will encounter performance issues.

Is the data source SQL? can you not use stored procedure to concatenate the required rows?

Hi Mustafa,

Thanks for the swift reply...

Just to add, there is only 5 columns - name, id, dept, email, role

In my estimation, there is not likely to be any more than 20 users added to the list at any one submission.

So basically, instead of saving each row as a seperate record in the Smartobject, I want it display the list in the form, but when doing a SAVE, I want it to concat all the rows into one field and SAVE in one entry in the Smartobject...

The main reason for having all the rows concatenated into one field is because the record in the smartobject is passed onto another system. Having multiple rows isn't going to work, but having one row of data will, as i can pass each field across, rather than multiple rows.....

Hope that makes sense

i.e. Rows on List

joe, id001, finance, manager

pete, id004, finance, supervisor

on save, copy all the above into one field

Is there any other way of achieving this outside of list views? Is it possible to lookup Users and details and add them to a text box and keep adding other users to it?

Hi Sharepharp1,

How do you expect the output of the two rows in one field only?

the output will look 

joe, id001, finance, manager, pete, id004, finance, supervisor

 

you can pass static values to make look better:

 

Name:joe, ID:id001, Dep:finance, Role:manager, Name:pete, ID:id004, Dep:finance, Role:supervisor,....

 

example of the transfer data action in my for each:

 

 

Every iteration it will add the row to the data label and preserve the previous value of the data label.

 

You will need to consider that this will not be displayed in a list view once saved so you can save the string in a seperate table if you would like to display the rows later.

 

If your data source is SQL I would recommend to write stored procedure to concatenate these rows, otherwise you will need to implement the first suggestion.

 

Have a look at the following if you need help with the stored procedure.

https://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

 

you can use picker control (multi select enabled) for this and configure the display value to show the required fields then save the display field (not tested)

 

 

Hope that helps

Thanks Mustafa,

Spent quite a bit of time on this and got it working (still not sure how)...

Basically, I removed the rules which save/create the records in the Smartobject.

I then do an Apply to Row - when Subview is closed, this then goes back to the main form and displays the entry (but doesn't write it to the Smartobject)

I added a cheaky Data lable in the footer of the list view.

Thanks to your idea of the For all Loop, i used that on Submit button to loop through all the displayed rows and do a transfer and all all 5 fields into one Field with a sneeky <BR> tag to display each record on a new line.

I then save everything and bingo, one record saved with all my entries in a single "Super-field" -just my name for it

My next test is to see how this passes that Super-field into a web-service to see how it comes out in an email to the user.... fingers crossed this works

Thanks again Mustafa for the pointers bro