Barcodes for Inventory Management

Hi @Sandy_Hang - I can’t find a way to do manage this with a barcode field and a barcode scan, but you can get close to it using the standard forms.

The first table I have is the “stock items” table:

This has a name or ID, an opening stock number, a link to a “Scans” table (see below). The “count of scans” is a count of the scanned field. Finally, “current stock” is a formula of:

{Opening Stock} - {Current Stock}

The second table (I’ve called this “Scans”) is where your staff record the stock that they take:

The “Stock” field is the link to the stock items table.

As each item is recorded in the scans table, the link is updated in the stock items table and the current stock is recalculated (decremented).

Obviously, as you buy in new stock you update the Opening Stock record and delete any records in the scans table in order to reset the opening stock and the current stock to the same value.

Hope this helps!

JB

You can’t scan a barcode and have it trigger an action automatically. However, this is possible with QR codes since they can be based on links (not just numbers). Here’s one solution:

1. Generate an ‘action link’ for every record with this extension.

2. Turn those links into QR codes.

Now every time you scan one of those generated QR codes, a specific record will get updated (or created).

Another option would be to make something like a changelog history table using our form builder. It has a built-in barcode scanner and you can create a new record for every entry.

Where do they scan in this table ?
I do not see the link between the scanning and the name ?
Do i miss something ?

The person scans the barcode Scans table under the Stock column (2nd picture). Each row is a scan of one item. Then he created a view (1st picture) that groups all the same items into one row and gives you a count of the number of times the item got scanned. This works well if you scan one item at a time to deduct inventory.