I currently have an Editable List View which allows users to have several rows into a list. When the rules save the results, it saves each ROW as a NEW record in the smartobject.
How can I make all the list items save under just ONE record, rather than save each row as a new entry?
Reason i ask is i want to then in my workflow pull all the records into one big MEMO field
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
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?
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?
How do you expect the output of the two rows in one field only?
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