Hello! I need help creating a daily report template. I have a table in my app where a user enters data into a column, and then when the form is saved, a row with data from the entry is added to a different spreadsheet called “daily report (pst).” At the end of the day, users may have made multiple entries or edits the table, and they all are recorded in this. At 10:00 pm, I want there to be a report for each “list”. I want this report to contain a list of the different entries of just today. No yesterday or before yesterday entries. And I want each report to be specific to a particular list. As an example, I have this document of how I would want my November 30th report for Acme East to look. I also only want the report to go out if there was an entry made on a day for a particular store list. For example, if you look at my spreadsheet link, I would not want a November 29th report for Redner’s because no entries were made, but one would be sent on the 30th at 10:00 pm, containing the 2 entries listed on the Redner’s report.
How should I go about making this report? Thanks!