Workflow - Report

[John_Henry_Jose]

I have two tables. One is master table and another one is child table.
I have set a workflow that whenever new row is added in master table, the pdf report will be generated.
The workflow works fine but problem is that workflow get triggered before child table updates its records.
So, in PDF Report we could see only master table information and not child table information.

When I test the workflow manually, the complete information is printed in PDF report.

Is there any other workaround there please?

Thanks.
John

[Lynn]

Yes

[John_Henry_Jose]

Hi Lynn,
Can you please advise me on that workaround to get full information in PDF Report?

Thanks.
John

[Steve]

help.appsheet.com

Workflow

Send Email, SMS or Notifications on Add, Update, or Delete.

[John_Henry_Jose]

@LeventK
I am forced to maintain 2 workflows as a workaround to get full report from Parent & Child Table records.
As a workaround, Initially, I will trigger workflow when new record add in Parent Table and it is success.

In order to get detailed report (Parent Table information and Child Table Information), I have a virtual Column in Parent Table to check all related child records are posted, if true, then the detailed report will be triggered.
But, it is not happening.

Can you please help me out?
Thanks.
John

[Lynn]

Hi @John_Henry_Joseph , check out this thread.

Workflow rule not firing using child table Questions

Hi, I was wondering if anyone could shed some light on the following, I have a workflow rule that has worked in previous apps without any problems, now however I am struggling to get this to work. I have two tables, Requisitions (parent) and Items (child), you can add many Items to a requisition and Items has a “Is Part Of” relationship to the requisitions table. I have an Updates Only workflow set up to run when the Requisitions table is updated however I am struggling to get this to work, it…