Form auto confirms answer matches information in a base before proceeding

Hello!

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!)

Thanks!

Hi @Victoria_Read ,

This is not possible directly with Airtable forms. You can however use MiniExtensions.com for something like that.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.