How to get a QR scan to display data from Sheets?

[Biomed_BEProj]

Hello,
I am trying to create a Medical Inventory Scanner using QR. Does anyone know how to display information from the database (Sheets) such as name, manufacturer, etc after the QR code for a particular entry is scanned? Thanks

[1minManager]

First created a Table (spreadsheet tab) where the first column is the QR code and the others are

Biomed_BEProj:

name, manufacturer, etc

Then in Appsheet you set the QR Code column to be scannable and then you’ll need app formulas for the subequent columns with a formula similar to this:

ANY(Select(Table_Name[Name_Column],[QR_Code_Column],[_ThisRow].[QR_Code_Column]))

Hope this helps

Simon@1minManager.com

[mateo]

My two apps are made exactly like @1minManager has written above. I just can confirm what I have read

[Biomed_BEProj]

Hi, I tried doing that but I’m getting this error for the QR column,
Column Name ‘QR’ in Schema ‘Medicines_Schema’ cannot be scanned (not Barcode scannable) because it contains a formula or AppFormula.

[SkrOYC]

Seems like you are adding the App Formula inside the same column that you should be using to scan the QR.
I’m sorry if I’m wrong but if you are looking for a fast solution to apply without reading the docs, you won’t be able to solve your problem.
I encourage you to read that as much as posible:

help.appsheet.com

AppSheet Help Center

[1minManager]

SkrOYC:

I’m sorry if I’m wrong but if you are looking for a fast solution to apply without reading the docs, you won’t be able to solve your problem.

Either do as @SkrOYC suggests, or if this isn’t possible simply contact one of the Appsheeet Partners (https://www.appsheet.com/Partners) like me . They are all more than capable of jumping into your App and quickly fixing the issue. Probably in minutes. When I started out with Appsheet, this is what I did to learn the platorm and it really helped.

[mateo]

Maybe try to check:
{ Data → Columns → [QR SCANNING COLUMN] → Auto Compute → App formula }
whether it is empty. It is possible that you had formula in your gsheet in that column and it was automatically overwritten in AppSheet (?)
It is just my first thought after reading your post,
Good luck!