Hi everyone !!! sorry but I still haven’t figured out how to design my APP.
In an excel sheet, called GSE that I use as a DB for my cars, I have a column with “id” - “model” - “Social Number”.
Each vehicle will be equipped with a QRCODE sticker with the vehicle’s “ID” inside. I would like to scan this QR code and I would like the app to automatically show me what type of machine it is, so that I can add any mechanical interventions to do.
I have not yet understood how the QR code to be associated with the vehicle is recognized. To generate the QR code I am using a site suggested by the community, inside I insert the vehicle id
Thank you!!!
The QR code will have the information in the key_column.
It’s just a visual representation of an alphanumeric chain of characters.
Because of this, a “scannable” field should be of type Ref (in a perfect world) and refers to your table Vehicle,
Cannone_Cannone:
the QR code I am using a site suggested by the community, inside I insert the vehicle id> Thank you!!!
That should work then, if you set the scanned column with type Ref ?
If you wish to display very few informations such as Model and Social Number, then I suggest you add virtual columns with app formula:
[ScannedQrCode].[Model]
and
[ScannedQrCode].[SocialNumber]
What did you try so far ? Can you share some screenshots ?
2 Likes
Thanks for your help!!! for now I have done very little, a sheet with “ID” type machine and company number.
I created an example QRcode with the “id” code of the first line.
Now I would like you to scan the QR code to show me the data of row “2” that is CAR1.
Then separately I will make a second sheet where I will add any maintenance.
Cannone_Cannone:
Now I would like you to scan the QR code to show me the data of row “2” that is CAR1.
I would suggest something like this:
This is an interactive Dashboard.
-
Left side is a table with the item to look for, single row:
View: Detail View based on the “filter” table.
-
Right side is a detail view based on my articles table: for you it will be car models.
Cannone_Cannone:
Then separately I will make a second sheet where I will add any maintenance.
Could be something that will come with an action, from the right-side of the dashboard
2 Likes
I’m sorry, but I just can’t understand !!
I have only one sheet where I have these 4 columns,
In the app screen when I try to scan the QRcode I get the error The scan result didnt match aby know entries.
But I don’t want to add anything in that view, I just want it to show me the machine data.In fact, if one day I succeed in my intent, on the main screen of the App I would like to open only the possibility to scan and then add the data of the machine. maintenance.
Thanks for your help
Aurelien:
[ScannedQrCode].[Model]
664 / 5.000
Risultati della traduzione
Hello!! I don’t know if you can still help me, I created two views, one that I use as a “DB” and the other from Scanner. I used the scanner column with reference to the DB with the key id “rimses”. As a scanner view I have given a Form view. Problem is, it doesn’t make me hide the “Rimses” column. In addition I would like that when I scan a QR code, it only makes me display a type of data, instead in the form view it then asks me to save, but I don’t want to give anything !! I would just like to view and then, as you said, connect me to a form with an action button and fill in the data for maintenance there. I don’t know if you can give me other advice. Thanks again
I will try to help you step by step.
Cannone_Cannone:
In addition I would like that when I scan a QR code, it only makes me display a type of data, instead in the form view it then asks me to save, but I don’t want to give anything !!
Are you looking for something like that?
(Translation for the view header: “Produit scanné”==> “Scanned product”)
(Could be “Scanned vehicle” in your case)
This is a similar system than this:
Main difference is: I use one single row in the Filter table, which of type Ref and which property “scan” is set to ON, as explained in my previous answer.
I suggest you try to understand/reproduce the mechanism in the sample app, then we will have a look on the “add maintenance information” step later
2 Likes
Thank for your help,but i don’t understand the example app that you said me see…
If i click on the link I see another app “Slice based on user input”
Cannone_Cannone:
If i click on the link I see another app “Slice based on user input”
Yes, did you try to use it at first ?
On this sample app, you select a color and you have some information related to that color.
My suggestion is about using the same mechanism, but instead of a color you pick a car (the scanned vehicle), and instead of a chart you will have the detailed information of the vehicle.
2 Likes
OK Thanks I will try,i have an another question,for the scansion i have insert a column add in the sheet DB then i had change the setting column qr code in REF.
do you think it is better to create a new QR CODE sheet that connects to the Db as a ref?
I hope I have explained
Cannone_Cannone:
,for the scansion i have insert a column add in the sheet DB then i had change the setting column qr code in REF.
I don’t get it, as [ScannedQrCode] looks to do the job, in my opinion.
What is the purpose of this ?
Cannone_Cannone:
do you think it is better to create a new QR CODE sheet that connects to the Db as a ref?
For filtering purpose as explained previously, yes. Just one single row. Ref to DB. Update mode: “Updates only”.
1 Like
Aurelien:
[ScannedQrCode].[Model]
So here I am !!! I got to do 3 views:
DB, Dashboard, Scanner.
I would like to have the scanner view in the Dashboard view but I can’t.
the step I do is to scan and then find the data in the dashboard. is there a way to do it automatically?
Thanks so much
Cannone_Cannone:
I would like to have the scanner view in the Dashboard view but I can’t.
That’s why I was suggesting using a mechanism involving a slice
Nonetheless, congrats for having it to this stage !!
Now, let’s say your filter table, for scanning purpose, is named “SCANNING”
Then, your row filter condition for the slice that will go under the detail view will be:
[key_vehicle]=SCANNING[column_scanned]
1 Like
Nothing I just don’t get there !!! I tried to create a slice on the DB table and I inserted in the Row filter condition as you said but nothing !!!
My mistake !!!
Please wrap the second part with ANY()
[RIMSES]=ANY(SCANNER[ScannedQrCode])
For my information, what does RIMSES means ?
1 Like
RIMSES is the column that is used as the key for each medium and is a number
1 Like
Hi @Cannone_Cannone
This seems like the follow up of your previous post
[Qr code info](https://community.appsheet.com/t/qr-code-info/60164) Questions
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
Just to make sure you get it.
You need at least 2 tables/sheets.
One if the one that has your car list.
The other one is just for scanning it’s gonna has 1 single row. One of the columns from that table is the one that needs to be Ref or Enum basetype Ref and marked as Scannable
1 Like
SkrOYC:
Just to make sure you get it.> You need at least 2 tables/sheets.> One if the one that has your car list.> The other one is just for scanning it’s gonna has 1 single row. One of the columns from that table is the one that needs to be Ref or Enum basetype Ref and marked as Scannable
In fact I still can’t yet it seems to me to have done everything right. I have two tables one where I have all the “db” machines where as the key I use the “RIMSES” column and another table called “SCANNER” where I only have one column called “ScannedQrCode” “which is of type Ref and scannable connected to the” DB "
There are a lot of ways we can do this so don’t give up
I’m gonna help you but please tell me which scenario seems the best for you:
- I want to open a Form to scan a QR code and then be redirected to the detail view of that record
- I want to have a Dashboard with two views, a place to scan and another to show the details
- I want to open a Form to scan a QR code and then be redirected to another form to start an inspection or something
1 Like
Thank you very much everyone, let’s say that I would like to scan a qr code, an inspection form will automatically open with the data of the scanned machine. The inspection form has already been created as an excel sheet.
Example I use the RIMES value in the db as a unique key for each machine