Table as a destination in workflow Assign Data activity

According to what I read here ;https://docuware.uservoice.com/forums/230570-client-english/suggestions/38934235-include-the-ability-to-write-to-table-fields-autom. we should be able to load table fields automatically in a workflow using the Assign Data activity. I have tried it to no avail. The configuration looks correct and there are no errors or faults in the workflow. The table is simply not written to and the document history for this step simply says "Variable is empty"

Ant clues appreciated

Dear Steve Shriver! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-193258-N2D9R for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team

Hi Steve, 

just a wild guess here, but maybe the table field of your test document has no rows?
The assign data to table activity can only assign data to already existing rows, it can and will not create new rows.

Hope this helps. 
Greetings from Germany, 
Simon H. Hellmann

DocuWare System Consultant

Hi Steve,

according to your configuration the workflow will loop through the rows of the destination table and add the specified values to the selected columns. Maybe you can explain a little what you are trying to achieve and I can help to find a solution.

@Simon
The workflow can add new rows, if you transfer data from one table to another using "mulitple columns" as destination type.
In this case you can either tick the "Replace" checkbox, which will replace all existing rows in the destination table or
you can untick the "Replace" checkbox, so that the new rows will be appended at the end of the table.

Viele Grüße / With best regards,

--

Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Thanks Simon and Gerado for your comments. Here is what I am trying to accomplish:

A Purchase Order Document is on file in the PO File cabinet. When an Invoice is added to the Invoice File Cabinet with a PO Number field that is not empty, an AutoIndex job is triggered which finds the matching PO number in the PO File Cabinet and updates the 'Last Vendor Name', 'Last Invoice Amount',' Last Invoice Number' and 'Last Invoice Store Date' field of the PO document. This triggers a workflow on that document that updates the 'Remaining Amount' field of the PO document with some simple math. There is a table field also in the PO Document with 4 columns. I want to capture the 'Last Invoice Amount', Last Invoice Number' etc. fields from the PO Document fields and update the columns in this table so I will have a history of all of the invoices added to the Invoice File Cabinet that posted against this PO document when viewing this PO. The PO document is a DocuWare Form submitted by the requesting user and at the time of submission the table field is empty.

Any suggestions are appreciated.

Thanks again,

Some further testing has shown this: If I prefill the table with one row of data, the workflow will populate the table with the data I want, overwriting the prefilled row. When a second invoice is stored it will update the table, but will again overwrite the first row. I have the filter set to 'is not empty'. If I change the filter to 'is empty' it will not write any data.

What I would like to do is add a new row for the second and all subsequent invoices. Also, there does not seem to be anyway to prefill the table row/columns when using a form.

Again, any ideas are appreciated,

Hi Steve, 

thanks for the detailed description. 
@Gerardo: Yes, I forgot about this feature to add rows.
However, this seems to be exactly the use case for adding new rows which is currently not possible.

As far as I understand, Steve wants to add a new row to a table of the PO each time an invoice related to the PO is stored. To my knowledge, up until DW 7.7 this is not possible without using the .NET/REST API.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hi Steve,

I understand. At the moment you can add table rows only when you transfer data from one table to another.
There you can only map table columns to table columns, e.g.

• '[MyTable]Last Vendor Name' = '[MyOtherTable]Last Vendor Name'
• '[MyTable]Last Invoice Amount' = '[MyOtherTable]Last Invoice Amount','
• ...

The missing piece is the assignment of index fields to table columns, e.g. like in your case:

• '[MyTable]Last Vendor Name' = 'Last Vendor Name'
• '[MyTable]Last Invoice Amount' = 'Last Invoice Amount'
• ...

We will look at that and see if we can improve things in the future.
Currently we are working on improving and extending the mapping of data between 2 tables by being able to match rows.

Viele Grüße / With best regards,

--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Thank you Simon and Gerado. You are correct. I need to add a new row to the existing table for each new invoice. Looks like I need to wait for version 7.8 or maybe 7.9. Unfortunately I'm too old to learn to code it myself :)

Thanks again both,