Unexpected behaviour/change in behaviour of Document generation workflow

Hello community members,

A document generation workflow that I have created was generating desired results initially, but now the result(doc) that is generated with the same workflow isn’t as expected. Seeking help to rectify the same. PFB the details.

Context: Workflow: pdf doc creation and email of Purchase Orders. Tables: 2 Tables - parent and child - Parent table is purchase requisition (Purchase number, vendor,datetime). The parent contains a child table of related orders(SKU,order quantity). Workflow - To create a doc when add or update happens to parent table. PDF contains purchase number (parent table) and a table containing order details.

Problem: The document initially was generating the required pdf, however, now it’s generating the pdf but the table of orders from child table aren’t appearing. Also, I do get the desired result now,but I have to edit/update the row and then run the workflow.

I think that the first time workflow runs (when the form is saved) it doesn’t allot (yet) the purchase number to child table orders- I get a yellow exclamation in the form when orders are added to a purchase requisition form. P.S. the app is not deployed yet.

Thanks in Advance!

:confused:

Which is it? You don’t get the tables, or you do?

https://community.appsheet.com/search?q=yellow%20triangle

1 Like

Thanks Steve for the prompt response.

The first time the workflow runs - on saving the form (add event to parent table) - the doc doesn’t add the child table. Please see the attached screenshot.

Additional info:
I’ve figured a work around( an unpleasing one). I need to just edit the form( any kind of update to the row) and then run the workflow. The second time it adds child table to the pdf.

1 Like

See Sending Email Only After Adding a Parent Record and All of Its Children here:

1 Like