TimEgerton
4 years agoQrew Trainee
Re: Scan QR code to create new record
Hi Mark,
Based on you comments we have been working on this.
Thanks
------------------------------
Tim Egerton
------------------------------
Based on you comments we have been working on this.
- We have a "People" table with fields [First Name], [Last Name] & [Passport Number].
- We create a QR code in the "People" table which has the format [First Name],[Last Name],[Passport Numer_Uppercase]. ie CSV format.
- [Passport Number_Undercase] is a Formula - Text field "Upper([Passport Number])"
- The QR Code is emailed to the "Person" in a PDF attached Exact Form.
- We have an "Arrivals" table with a form that includes the fields [QR Code], [First Name], [Last Name], [Passport Number], plus other fields to be filled in (Date/Time).
- The Arrivals table form is Mobile app enabled (online & offline).
- On arrival at the airport the QR Code is scanned into the Arrivals table form.
Thanks
------------------------------
Tim Egerton
------------------------------