Weekly inspections - reports for done vs. outstanding/remaining

Weekly inspections - reports for done vs. outstanding/remaining

Hi all,

Probably a really obvious one here.  I'm a Zoho Creator newbie.  I've created a Fleet Management app in Creator (see attached dashboard screenshot) so that our team can manage our fleet vehicles.  It has the following two key reports based on forms:

  1. FLEET VEHICLES (top list in the image) - contains all 71 of our fleet vehicles (each one is a different line item)
  2. VEHICLE INSPECTIONS (middle list in the image) - drivers complete the form once a week Sat-Fri.  The dashboard shows how many inspections have been done this week based on a filter for 'this week'.  The Vehicle Inspections form uses a lookup function to the FLEET VEHICLES for the vehicle registration number.

I've been asked if I can make a report to show vehicles that haven't been inspected this week.  I thought it would be as easy as deducting vehicle inspections this week from all Fleet vehicles to show outstanding/vehicles remaining to be done... so that we can chase drivers to do their inspections...

Any help you can give would be appreciated.

Thanks

Dave