Hello thanks for your helpful video. I have a question regarding the outbound quantity. I noticed there are minus sign prefix in your LogDB. Please could explain.
I am started from scratch. Do I need to make a list first like you did? Do you have a video explaining everything from the beginning. As I say in my previous comment I am a novice and need some guidance. Thank you so very much! Could you tell me what to do first?
I really love your video but I am completely new and it would be really helpful if you explain the sheets you created. For ex when I go to app script (following your video) I do not have anything on it. Am I supposed to copy everything that is on yours for barcode? Thank you so much for being patient with me.
Hi there, this is genius. However, I’m trying to connect multiple wireless scanners to a Google Sheet and each scanner should populate into separate column, how do I attain this feat ? Thank you in advance.
Hi, I copied all of your code, but it doesn't work properly. I've checked it over 10 times now, and I've definitely typed exactly the same code as you show on the screen here. It prompts me to input the barcode and quantity, but then I don't get any changes appearing in the field L2. Also, when I click on the buttons, it doesn't trigger the questions to input barcode and quantity, that only happens when I first open the file, but not again Any idea why it won't work?
I'm not sure. I'd be happy to share the file with you. Please subscribe to my newsletter : excelhighway.ck.page/landingpage I will share the file after that.
Hello thanks for your helpful video. I have a question regarding the outbound quantity. I noticed there are minus sign prefix in your LogDB. Please could explain.
These lines indicate outbound delivery, the negative sign will reduce the inventory.
I am started from scratch. Do I need to make a list first like you did? Do you have a video explaining everything from the beginning. As I say in my previous comment I am a novice and need some guidance. Thank you so very much! Could you tell me what to do first?
Yes, you should create the same sheets and formulas I used.
Another question. In the number of row cell I get 1 instead of 0. Is it what you wrote =counta(A:A)-1
Thank you!
That cell should count the number of rows to copy, I wrote -1 to ignore the header line.
I really love your video but I am completely new and it would be really helpful if you explain the sheets you created. For ex when I go to app script (following your video) I do not have anything on it. Am I supposed to copy everything that is on yours for barcode? Thank you so much for being patient with me.
Thank you for your feedback. Your app script will be empty the first time you open it. You should copy everything so it will work as expected.
Thank you!!!
Hi there, this is genius. However, I’m trying to connect multiple wireless scanners to a Google Sheet and each scanner should populate into separate column, how do I attain this feat ? Thank you in advance.
Thanks, I'm not sure if the scanner can be identified. Are items scanned by each scanner different?
Hi, I copied all of your code, but it doesn't work properly.
I've checked it over 10 times now, and I've definitely typed exactly the same code as you show on the screen here.
It prompts me to input the barcode and quantity, but then I don't get any changes appearing in the field L2.
Also, when I click on the buttons, it doesn't trigger the questions to input barcode and quantity, that only happens when I first open the file, but not again
Any idea why it won't work?
I'm not sure. I'd be happy to share the file with you.
Please subscribe to my newsletter :
excelhighway.ck.page/landingpage
I will share the file after that.
@@excelhighway3549 Thanks so much! I just subscribed now. Matthew
@@excelhighway3549 I too have the same issue, and even I have subscribed, can you please help me out
can i get the excel template
The file is available on my Patreon page:
www.patreon.com/ExcelHighway