@kahakun if the user selects whether it is check-in or check-out by using a choice component then you can multiply the check-out value by -1. Thereafter you do a roll up on the scanned value column
When does the product (with the barcode) turn up in your sheet? The first time you scan that barcode - or is it already in the sheet? first time i scan
When you scan the same barcode you want a flag telling the the product is now scanned “out” - but the product remains in the sheet yes but how?
What happens if you rescan the same barcode - should the product now be “in” again? Yes
@kahakun I have done a sample app for you to get inspired by
One button for doing the scanning - and one button for actually inputting the value.
I have made it possible to input the barcode manually as barcode scans quickly eats your quota
I hope that will help you to do your app.
Notice that the data is not user-specific - so if you want multiple users to use the app you will need to replace a number of columns. Please test that it actually works correct with user specific variable
No you were clear i did that… but i have an app i already built out… is there a way to copy what you did from copy of your SImple inventory into my pro app?
also i completely recreated the sheets just like yours… but when i create the scan in linear barcode button it disappears
when i add the button as default it appears… but when i change the action to Scan Linear Barcode… is goes away but still showing that its present in screen data… i haven no idea whats going on…
@kahakun I think there might be a bug there but I managed to get it working and I’m not totally sure what did the trick - but some of the suggestions I gave might help…
@kahakun A few more suggestions. Try to tweak to get it working.
create a new tab and put the button to scan there
create a google sheet (if your app is connected to google sheets) and try to scan the information to that sheet. Change afterwards the sheet connected to the tab - so you use your originally Glide table.
recreate the tab (or potentially just copy the whole tab) where the scan button is found