Barcode scan inventory number using iOS app
I am using Ninox for managing my artwork inventory. For every new record added I am using a forumla to generate a random number. I print these out as labels to stick on the back of paintings.
Ideally i would like to scan the barcode using the phone app so it shows the record on Ninon with details. Right now when I use the search box, the scanner button displays, the camera turns on but the scanner does not search or find the record.
is this a problem with my barcode itself or an issue with the app or something else ?
Trigger on Create : inventory_number := format(floor(random() * 1000000000), "000000000") + "VMENON"
This is my label
2 replies
-
What format is the barcode?
-
Hi.
As far as I am aware only Code39 and Code128 allow for charcters in the barcode. Code39 needs the code to have asterix placed at the start and end, so 970862262VMENON would have to be *970862262VMENON*, an easy change to your trigger on create formula
inventory_number := "*" + format(floor(random() * 1000000000), "000000000") + "VMENON" + "*"
I've not used Code128 before but I understand it has a check digit at the end.
Code39 barcodes can become very long and I think your inventory number is longer than would be practical to use.
Creating a random number is not the same as creating a unique number and your formula should include a loop that generates a random number and exits when it has checked that this is unique.
Personally I would use a fixed length serialized number that is as short as possible, maybe prefixed with a letter as this helps if ever I have to export to Excel and prevents Excel from trying to convert this to a number
Eg A0001, A0002, A0003 etc
Regards
John
Content aside
- 4 yrs agoLast active
- 2Replies
- 719Views