Solved: Daily Reports to identify what users did not updat... - Page 2

Alejandra_Petro · 06-02-2020 06:49 PM

Hello,

is it possible to generate an automated daily report showing the Users that have not completed a field (Column) into the App?

So I have a table named “Work Diary” where the driver uploads a photo of his previous day’s work diary page.

Now, I want to get a report each morning with the drivers that have not uploaded the photo or page.
is this possible with Appsheet? I know you can generate reports but not sure whether the reports can be this specific.

Thanks in advanced.

Steve

This is certainly possible.

Assuming the Driver column of the Work Diary table is a Ref to the Drivers table, the following will get you a list of the rows of the Drivers table that don’t have entries in the Work Diary table for yesterday’s date:

(
  FILTER("Drivers", TRUE)
  - SELECT(
    Work Diary[Driver],
    ([Date] = (TODAY() - 1))
  )
)

In your report template, use the expression in your <<Start>> tag:

<<Start: (FILTER("Drivers", TRUE) - SELECT(Work Diary[Driver], ([Date] = (TODAY() - 1))))>>

Daily Reports to identify what users did not update field?