I have an app that allows users to enter items[inventory id] or choose from a list. In this table I have the items stored - I need the user to be able to scan (barcode) the items and the app pulls up the information for that item (entered above). In particular, I need a pdf (certification) available for the user to look at.
Columns I have for this:
[Inventory ID] - Key column (scannable)
[certification] - File type column for pdf
Any thoughts help would be greatly appreciated!
You can refer to the article Use a barcode scanner to get you started. Once you fo through that, if you still have questions please come back here to the Community.
I hope this helps!
I really appreciate that - however I already have the app working WITH the barcode column marked “Scan?”. My issue? I need the user to be bale to use the app (phone) - scan an item - and the app needs to pull up the info based on what the scanner - scanned.
For example:
If I entered in the app an item with [inventory id] = 1234
Then I added the pdf Certification.
I want the user to be able go scan that item using their phone and be able to pull up that pdf.
Does this make sense?
Ok sure. Wasn’t sure how far you had gotten. If you showed your data and form we could give you better specifics. Without those I have to give lengthy general descriptions. So hopefully the below covers it.
To make sure we are on the same page, typically you would have an Items table that includes barcode column. In your case, it seems to be an Inventory table in which you have columns for:
inventory ID
PDF Certification
barcode
You would assign the barcode value to this barcode column as an alternate identifier for the PDF to be easily looked up later.
The next step, if you haven’t done it yet, is to associate the barcode VALUE with your Inventory row. An easy way to do that, is to bring up your PDF Inventory row in Edit mode. If you hadn’t associate the barcode yet, the barcode field would be empty. Tap the button on the barcode field to open the scanner, scan the barcode which will insert the barcode VALUE into the field and then simply save the form. The barcode is now saved with the PDF row as an identifier.
I am not certain at this point if you just want the user to be able to lookup the PDF in the Inventory table directly OR you could have a second table in which you need to assign the PDF Inventory row and want to do so by using the barcode.
If all you want to do is perform a lookup in the Inventory table, all you would need to do to go to the Inventory view, tap on the Search magnifying glass at the top and the search field will change to something similar to the image below. The scan button is highlighted, tap it to open the scanner, scan the barcode and then the table will filter to show your Inventory row for that associated PDF:
I’ll stop here for now. If your intention is to lookup an Inventory PDF to assign to some OTHER table Form view, let me know and I’ll provide details if you need them.
Here is my invnetory table: I have barcodeimage - but it is a Virtual. Do I need to make a column in table "[barcode]?
Ok, The search bar having the ability to scan a barcode and go straight to that in a row - is EXACTLY what i needed! Thanks so much!
Yes, the barcode image is just a representation of some value. It is that value that needs to be saved in the table. As an example, for the water bottle below, the scanned value would show up in the search bar as indicated in the second image.
Notice the numbers match with those at the bottom of the barcode image but not all barcodes have the numeric value shown.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
