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

1 Like