+5
Hello everyone.
I am trying to achieve some functionality I have never attempted before.
I want to be able to have a list view, in a smartform, and for each column I want to be able to append each line to store in that field in the database. (Attachment)
Company code Vendor Code AP Specialist
DDD 1 Adriana
STR 2 Christine
Ex. Database storage:
DDD;STR 1;2 Adriana;Christine
+10
Can you please clarify what exactly do you mean with Database Storage:
DDD;STR 1;2 Adriana;Christine
So basically kind of read all the records from the list view and merge all those in some kind of hash or consolidated array that includes all the elements form the list view ?, perhaps to use it for a Dropdown or something else ? or just to be inserted into a Database ?
What I would do probably is to have a For Each element in the list view. then have 3 expressions [ Because you have 3 Columns ] to merge each of the fields Company Code, Vendor Code and Ap Specialist. once created all the array. Call another Outbound Rule that take all 3 Params that have been built as the concat of each of the fields and execute a final insert into the DB just the way you want it.
Let me know if this makes sense or sounds all confusing.
Good Luck.
Dino.
+5
Not to confuse you but I need these fields to be able to tag documents and for integration into another system.
What your suggesting makes sense. I will take a whack at it and get back to you 
Thank you!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.