Hello! I’m working on an application for storing oxygen cylinders. It involves scanning the barcode on the oxygen cylinder, selecting the person issuing the cylinder from a list, choosing a location from a list, specifying the capacity, and indicating the owner. Unfortunately, I don’t have a list of these cylinders, and I need to scan each one individually to add them to the database. How could I do this to scan several cylinders at once, assign values to them, and have them appear in the database as separate entries?
To keep the table/column structure as simple as possible, I would use your structure where you have only one cylinder column, but I would read the initial value from the last row for these other columns. Then the user would only need to scan the cylinder. You could add a condition to your initial value like if the last row is added lets say within last 30 secs, use the last row’s data. If not, use just blanks.
well, worked myself with this: https://www.youtube.com/watch?v=_m7anO_WQps and Video that Mauricio linked. Thanks!