Auto Generate PDF on secondary table change

AppSheet AppSheet Q&A
1

I have a primary table for an app I am building. I have set up an auto-generation of a PDF each time the primary table changes & it works great. To keep the primary table from having too many fields, I’ve created secondary related tables that tie to the primary through a job number. It all works well and I can update the primary and secondary tables and show all fields in a PDF.

I need to be able for the app to auto-generate the same PDF to include the primary and secondary table fields if one of the secondary tables is changed (and no change to the primary table). Should I create a hidden incremental field in the primary table that changes each time the secondary tables are changed? Is that possible? If so, how? At least that would trigger a change to the primary table and the auto-generation of a PDF.

Thanks for any help or suggestions you can provide!

2

[quote=“wcksmith”]
Should I create a hidden incremental field in the primary table that changes each time the secondary tables are changed?
[/quote]# :100:

With an action that triggered on related records.

Actions: The Essentials - AppSheet Help
3

Thanks for the great direction! I got the primary file value to change with a bit of poking around, but it wouldn’t run the additional automation to print the PDF even though the data had changed. It took me a while to find the additional switch to turn on under Automation to “trigger other bots” so the PDF generation would run after the action to change the value in the incremental field in the primary table.

1 Like
4

So sorry for not providing that piece. I’m very glad you were able to solve it!