User jobs issue

Iโ€™m designing a vehicle collection and delivery app. I have a sheet called drivers, one for clients, one for vehicles, one for collection inspection and one for delivery inspection.

Once the vehicle to be collected is input in โ€œVehicleโ€, a driver can then select it in โ€œcollection inspectionโ€. How do I make it that after a driver has selected a vehicle it is no longer available for other drivers and then once the driver has inspected the vehicle and submitted the data It then becomes available in โ€œinspection deliveryโ€ but only to the same driver who collected it.

Many thanks for your help

0 1 139
1 REPLY 1

Top Labels in this Space