Qr code info

Cannone_Cannone · 12-15-2021 07:43 AM

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

Aurelien

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=912...

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

Cannone_Cannone

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

Aurelien

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”

Cannone_Cannone

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

SkrOYC

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

SkrOYC

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

Cannone_Cannone

thanks I thought it was easier

SkrOYC

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

Cannone_Cannone

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

SkrOYC

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