I have a base that shows me 3 things.
- Employee Name
- Vehicle Reg
- Vehicle Number (via a lookup based on Vehicle Reg)
- Route Number
These things are dynamic and change every day. Before the employee starts working we ask they fill out a form confirming their name, vehicle and route number. I have configured name & vehicle to prefill when the employee clicks on a link next to their name.
I would like to keep the field on the form that asks them to type route number in. However, I would like their answer to be checked against the relevant record and
- if answer and base info match relay a message to say ‘Correct, please proceed’
- if not, ‘ATTENTION, please seek management, do not set off’ (ideally also not allowing them to submit the form)
I would also like to add a lookup field that displays the Vehicle Number on the form (if possible!)