My app users create reports based on any time period they choose. I want to trigger a pdf of the report emailed to user email
Hi, are you able to give more details what you are looking for, thanks!
Yes
Annualloadbook app has users that run
Reports for expenses each month or week or year
They also run basic reports for load revenue.
I need to make it so that when the fleet manager or solo driver or owner runs a report then the get it emailed to them
Jack Bates
Annualloadbook app
208-250-2845
I would probably created 3 different action buttonsโฆ Week, Month and Year. Those actions would write a value like โWeek_โ&NOW(), โMonth_โ&NOW() or โYear_โ&NOW(). Then you can read the condition like INDEX(SPLIT([PdfCreated],"_"),1). When you create the template for the PDF, you can then use that value for your Start: & End formula.
I believe I understand only not sure about adding the buttons
The process should be able to trigger from the sheet labeled " monthly summary "
anytime a user makes an enquiry to process a summary report, regardless of time frame. Creates a new line in the "monthly summary " sheet
Jack Bates
Annualloadbook app
208-250-2845
If you have some kind of users table, you could trigger those buttons from there and additional table would not be needed. You only need one text column for that purposeโฆ all buttons would write the into that same column.
Ok I will try it on a copy of the app
Virus-free. www.avast.com
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |