Scan in and out

I have the barcode scanner working able to scan in barcode… but how do I scan it out.

Scanned in Barcode(12345) makes a line
Scanned out Barcode (12345) also makes a new data line

How do I formulate or custom action to say…

Scan in Barcode 12345 (boolean false)
Scan out Barcode 12345 (boolean true)

how can i do this boolean change in the same data line?

@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

Barcode number rollupnumber
Xxx. 1 0
Xxx. -1 0

1 Like

This works for none unique items, in my case all items are unique.

I need to be able to adjust current row…

I think doing it wrong… can you show me how to do it? skype or google hangouts?

@kahakun I can try to help you through the community.

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?

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

What happens if you rescan the same barcode - should the product now be “in” again?

1 Like

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

4 Likes

you are amazing and thank you so much… idk how to thank you!!!

@kahakun Glad to hear. If you want to share a demo of your app at a later stage then please do. The community is always interested to see showcases.

i will… this is the last part of what i have been trying to do for for months.

thank you!!!

1 Like

for some reason when i convert the action on the button to “scan…” it disappears

I also have had problems of that kind. Not really sure why…

In the demo app there is already a button which has action “scan linear barcode” - why not use that?

i can copy your functions into my app?

how?

I been trying to build it on my own by looking at it :frowning:

your work is art… there is so many clients for you here in NY to make money. we should talk more lol

@kahakun You can copy the sample app if you open the link on your computer. I thought that was clear - but it clearly wasn’t :frowning:

1 Like

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 :frowning:

You need to copy things manually between apps. Be diligent!

Data editor - columns first….
Then ux components (and remember visibility settings!)

1 Like

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 The problem could be a visibility issue. Try to remove all visibility constraints if any put on the button.

You can also try to create a compound (“Create new action”) action instead of a normal action

Try also to add some data into the sheet where the barcode goes.

Other components same variable might be restricting you to get access to the button.

That was a few ideas

1 Like

@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