0

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 

Screen Shot 2021-03-04 at 3.15.43 PM

2 replies

null
    • John_Halls
    • 4 yrs ago
    • Reported - view

    What format is the barcode?

    • John_Halls
    • 4 yrs ago
    • Reported - view

    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

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 722Views