Forum Discussion

TimEgerton's avatar
TimEgerton
Qrew Trainee
5 years ago

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 thre...
Formulas and functions
Mobile
Tables and fields
TimEgerton's avatar
TimEgerton
Qrew Trainee
5 years ago
Hi Mark,

Based on you comments we have been working on this.

  1. We have a "People" table with fields [First Name], [Last Name] & [Passport Number].
  2. We create a QR code in the "People" table which has the format [First Name],[Last Name],[Passport Numer_Uppercase]. ie CSV format.
  3. [Passport Number_Undercase] is a Formula - Text field "Upper([Passport Number])"
  4. The QR Code is emailed to the "Person" in a PDF attached Exact Form.
  5. 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).
  6. The Arrivals table form is Mobile app enabled (online & offline).
  7. 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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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.com
mark.shnier@gmail.com
------------------------------
  • TimEgerton's avatar
    TimEgerton
    Qrew Trainee
    5 years ago
    Thanks Mark.

    ------------------------------
    Tim Egerton
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Another tip is that you will need to put those three formula fields on the form. Initially you can expose them to your users but if you don't want them to show to users you can put them in a section and then hide the section with a form rule. The reason for this is that sometimes form rules do not behave properly if the fields they use are not actually on the form.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------