Skip to main content

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

 

 

 

 

 


13642iADE7D48D374901FD.png

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


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!


Reply