Yes. If the QR code has all the data, then you create 3 formula fields to parse out the three fields separately.
the formula for the first field, for example, would be
Part([3D scan], 1, ",")
then use a form rule to populate the three separate fields on the form.
so scan the code into the first field and the other 3 will populate.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 10-31-2020 19:28
From: Tim Egerton
Subject: Scan QR code to create new record
Hi Mark,
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.
To split the QR Code and post into the three corresponding Arrival Table form fields is that a formula, API or Automation?
Thanks
------------------------------
Tim Egerton
Original Message:
Sent: 10-20-2020 22:56
From: Mark Shnier (YQC)
Subject: Scan QR code to create new record
It sounds possible.
you would have a form which had a field for the results of the scan, and formulas to parse out the contents of the bar code scan into separate fields and then form rules to populate the separate fields.
You could initiate the correct form by having the user go to a particular link "somehow" or by scanning a 3D bar code with the camera app to land the user on correct add Record form.
You will need to have users install the Mobile app from the App Store / Google Play to be able to scan 3D bar codes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 10-20-2020 21:44
From: Tim Egerton
Subject: Scan QR code to create new record
We have a QR code that consists of [First Name]+[Last Name]+[Passport Number].
Is it possible to use QB Mobile to scan the QR code to (1) create new record and (2) automatically populate these three fields.
We then want to add additional data into the mobile app, Save & close.
Then repeat.
Thanks
Tim
------------------------------
Tim Egerton
------------------------------