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:
- FLEET VEHICLES (top list in the image) - contains all 71 of our fleet vehicles (each one is a different line item)
- 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
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.