Qr code info

AppSheet AppSheet Q&A
1

Hi everyone!!! Question for you !! I have to check on four-wheelers. I would like to use qr code to apply on cars. When I scan the QRcode with the app, I would like it to open the history of that vehicle, example car number, mechanical interventions and more. Do you think this is possible?
Thank you

2

Hi @Cannone_Cannone

Yes it’s possible.
The best approach I would suggest is to use the same approach as this sample app:
https://www.appsheet.com/templates/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

  • First view will be the scanning, with column type Ref, to table Vehicle
  • 2nd view will be the a detail view based on the table Vehicle

Additionally, you can add an action button to reset the scanned value from the first view.

Edit: correction on 2nd view

1 Like
3

thanks a lot!! but i dont undestand L’app for example

4

the app “filters” what is picked in the bottom/enum view
the graph view will be a slice, based on criteria: “matches the user selection on the other view”

2 Likes
5

Thanks but I didn’t understand how I can connect an adhesive QR code attached to a car, scan the qr code with the app

6

The QR needs to be made through the app for the app to identifty the info from the QR as an usable string, for example.
Usually, QR images are key values for a table.
If the QR are already printed and have another info not related to AppSheet, this seems hard, even not possible

7

I haven’t found a useful use case for my apps yet (I’m still looking since it’s a really cool thing) but you can find some info here

https://community.appsheet.com/search?q=qr+code

Koichi even made QR with public url to open views form outside the app

[Scan barcode with your native mobile camera and jump to target view](https://community.appsheet.com/t/scan-barcode-with-your-native-mobile-camera-and-jump-to-target-view/18984) Tips & Tricks ?

I suppose loads of people are using Scanning functions here and there withi the app you generated. Probably most common case would be ; - Dynamically generate the QR code using the third party APIs to display QR as Image on your app. Initially Appsheet introduced this tool and site, https://qrcode.tec-it.com/en, as free qr code generator. I have been using the same on my production App, and working well so far. Again, basic usage of QR code is (least for my case) that we generate Virtual Colum…

2 Likes
8

thanks I thought it was easier

9

Let me summarize this just to help your understanding @Cannone_Cannone

You need a table with the info of the car. Let’s call this Cars
Cars have an [ID_CAR] column that’s the key.
Then you have another column, type Image and called [QRCODE] with this Initial Value expression:

CONCATENATE(
  "https://quickchart.io/qr?text=",
  [ID_CAR]
)

If you print the QR to put it into a car, then you know that you can get the key for that car record on your database by scanning it.
To get the info you need what @Aurelien already said, a view with Ref column and stuff like that to pull the info

2 Likes
10

the problem is that the QR code stickers are empty for now I should print them

11

That’s not a problem from my POV, because you will put whatever you want on them, like the Key value I talked above

2 Likes