Workflow Report Blank Initially, Works after Edit

[sloganuga]

I am having an issue with an app creating a workflow report template that has no data filled in on initial send. When the user goes back and makes any change and saves the pdf report is populated correctly.

Details

Workflow is setup to send email and create a PDF report when update event is “ADDS_AND_UPDATES”

Upon saving an entry a workflow fires creating an email and attaching a Word template. The email is received with the PDF but all data fields are blank. If the user goes back into the survey, changes an entry, and saves, the workflow fires again but the data fields are now populated correctly in the PDF.

It’s almost as it the workflow is triggered before the data is saved and available.

Any help would be appreciated.

Thanks,
Stephen

[Koichi_Tsuji]

Maybe worth checking those docs?

help.appsheet.com

Workflow

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

[sloganuga]

Thank you for the reply. In the referenced case no child tables are being updated, just the primary table which triggers the workflow.

[Steve]

sloganuga:

Upon saving an entry a workflow fires creating an email and attaching a Word template. The email is received with the PDF but all data fields are blank. If the user goes back into the survey, changes an entry, and saves, the workflow fires again but the data fields are now populated correctly in the PDF.

So the template fails to populate on adds, but does populate on updates?

[sloganuga]

Correct.

[Steve]

Are you sure the row that triggers the workflow in fact has the non-blank column values used by the template? You’ve confirmed by looking at the data in your data source?

[sloganuga]

I have confirmed. The initial workflow fires and template is sent and attached to the email, but blank. Upon going back into the same data, changing any field, and saving, the workflow fires and the template is populated.

[Steve]

I’m afraid I have no explanation for that behavior. I’m going to have to refer you to support@appsheet.com for deeper troubleshooting.

[sloganuga · Accepted solution]

Thanks Steve. I will contact support.