SeymourBots

Hi @PotatoMato. Yes, we use a barcode scanner. I'm not sure what you mean by "separate the value on the table". Currently the field only accepts one value. I would like to repeat the field rather than have multiple values in one field (e.g. separated by commas, or new lines) as ensuring all fields are filled is more user friendly than counting the lines or comma separated entries. Also multiple entries in one field may cause other issues. Each entry for each field would produce a new line in the table (Figure 1.). thank you for your reply.

I am designing a database for stocktake and tracking of human tissue grafts. Elements that we need to trace are encoded as the serial number for each unit as a barcode, including the donor number, size of the graft, type of graft and the piece number (number of each sized piece cut from one donated tissue). I have chosen to use Caspio because it has been the only platform that I have been able to program to split the information encoded in each barcode into attribute columns (donor, size, type, piece). My problem now is how to create a form into which I can scan each serial numbered unit. So far, I have a form that receives the scanned barcode, which enters the barcode into the Serial_Number column of my table, from which each attribute is split into columns using formulas (Figure 1). In one 'session' of scanning grafts into the database, there will be approximately 30 pieces, each with a unique serial number that needs to be scanned in. Currently I have one Serial_Number field in one form (Figure 2). I would like multiple of the same field for scanning in each graft in a session. How do I do this?