Kia ora All
I’m trying to create a timesheet report. I want to be able to generate a PDF that list all of the desired USER ID’s hours that have been tracked during a specified date.
Here is the Timesheet Table
Here is the User table
In a previous (not deployed App) I was able to create a hack to generate a report via another sheet and importing ranges ect, but it was a bit cumbersome. The report it generated though was perfect.
Here’s the old version of the generated report
So essentially, what I want to do is, create similar report above (but for all USER ID’s) and email that report to the HR Manager.
I guess I need to create a bot and a scheduled event, but that as far as I can get too. Any ideas?
Ngā mihi