Iโm puzzling over what I hope is a fairly simple requirement.
Iโm adding something to my app to allow drivers to check a vehicle out and back in.
So I have 2 tables, Vehicles and VehicleCheckSheet.
They are linked using Ref and Reverse Ref fields on vehicle registration number.
Each vehicle can have many check sheets.
A check sheet contains checkout date/time, checkin date/time, checkout mileage, checkin mileage, driver performing the checkout/in.
When a driver takes a vehicle from a depot they will complete a check sheet e.g. tyres, lights, mileage etc.
But I want the action of completing that check sheet to update the Status column in Vehicles .
The status can be Checked Out - DUTY, Checked Out - SERVICE, Checked Out - OTHER, Checked In.
So those values will be selected by the driver from a dropdown when they are completing the check sheet (Iโll be using some showif constraints e.g. Checked In will only be available if current status is one of the Checked Out statuses).
When the driver returns a vehicle they will check it in and record the current mileage, any defects and the location that they have checked the vehicle in to.
What Iโm trying to give the fleet manager is a top level view of all vehicles where he can see the status of each vehicle, its location if itโs been checked in somewhere and the current mileage based on the most up to date check-in.
I hope thatโs painted a good picture of what Iโm trying to achieve.
The core question is how do I keep those vehicle level values (status, location, mileage) updated out of the act of completing a vehicle check sheet?
As always, any help offered will be much appreciated.
Cheers David
LinkedIn
Twitter
