On demand report for a specific group of records

AppSheet AppSheet Q&A
1

I would like to create an “on demand” report based on a specified group of records (normally based on custom dates as the variable) to be emailed to the initiator of the report (another email variable). The raw data I am using is based on a Google sheets database https://docs.google.com/spreadsheets/d/19qdHzg94MBbk0JjXGwwPH5sklxOQwXFmIzlA4R_XTMI/edit#gid=1521911716 with the result to look more or less like this but as a pdf https://docs.google.com/spreadsheets/d/18MMWu4FLxikRYpNTUx3ygC0hHGNDtiNWdSXEL8lFycs/edit#gid=1734945451

Hoping someone can advise me on this.

Many thanks,
Hugh Temple

2

You’ll need a table to collect the report requests. Each row will be one request, and should include the recipient email address and the report parameters. Setup an automation that watches that table for adds (and optionally updates). When triggered, the automation should generate and send the requested report.

Recategorized this topic as #appsheet-automation.