I’m currently trying to design an inventory management app using bubble. The idea is to use a barcode scanner to identify an item, and then be able to modify information about this item, or create a new item if it does not yet exist. I have managed to get the barcode scanner to identify the item, but i’m missing a step in the logic.
After the barcode scanner has identified the barcode of the item, it should compare the barcode against all items in the database. If the item already exists, it should allow you to modify the item details or change the amount of stock. If it does not exist, you should be able to create a new item with that barcode.
I can make a new item based on the barcode, and i can search for it in the database if it already exists.
Where i’m struggling is to make the app decide which of these it needs to do - i’m missing the step where it checks the barcode against the database, and then it needs to make a decision as to which option should come up,
Could someone advise me how i can do this?