Setting up a barcode system with Zoho Creator
Hello! I am researching how to set up a barcode inventory system that is compatible with Zoho Creator. I am working with an art inventory, and I want to be able to refer to each piece of artwork with a barcode. My goal is to be able to generate a barcode, store that barcode in a Zoho Creator database, be able to print out a barcode label from that database, and have the database pull up a record when the barcode associated with that record is scanned. I understand that there are barcode generating softwares out there that will generate a barcode label from a given number combination. To create the barcode label, I think that I have to create a number associated with each piece of artwork inside Zoho Creator, export those numbers from Zoho Creator, import them into the barcode generating software, generate the barcodes, and print the labels. My question is what do I need to do to be able to pull up a particular record when I scan the barcode label with a 2D barcode scanner? I want to be able to update the record when I scan the barcode. For instance, I want to be able to change the status of a piece of artwork from available to sold. Thanks in advance for any advice!