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?
Is there a way to have the prompts automatically open without having to click the scan item button. Then when the prompts are complete have them open and ready to go without having to click the button?
@@excelhighway3549 Is there a way to trigger it to run again after you click okay for the quantity? Maybe press the button for the first entry but if you have multiple entries, can you trigger it to repeat once you click okay on quantity?
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.
Great video! Quick question. Why are rows 4-7 hidden on your InboundBarcode sheet? The items scanned start on row 8 for the InboundBarcode sheet, but start on row 4 for OutboundBarcode sheet? Why?
Hello, I am new with google sheets and I copied everything on the app script exactly how you have it but I get an error for line 11 for Example: Error Exception: Cannot convert ‘ ‘ to int. Inv_Change @ Codegs:11 Do you know what this means?
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! Great video. Question. If I were to purchase this file from your patreon would I be able to upload it on google sheets and have it work properly? Thanks
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?
Hello, I am new with google sheets and I copied everything on the app script exactly how you have it but I get an error for line 11 for Example: Error Exception: Cannot convert ‘ ‘ to int. Inv_Change @ Codegs:11 Do you know what this means?
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
![เปิดคำทำนาย นอสตราดามุส - บาบา วานก้า ปี 2025 คนทั่วโลกต้องเจออะไรบ้าง? | แฉ 11 ธ.ค. 67 [2/3] |GMM25](http://i.ytimg.com/vi/xmTIKWJUMPM/mqdefault.jpg)
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.
Is there a way to have the prompts automatically open without having to click the scan item button. Then when the prompts are complete have them open and ready to go without having to click the button?
I'm not sure, you need to trigger the code somehow. If not with a button what would trigger the code and generate the prompt?
@@excelhighway3549 Is there a way to trigger it to run again after you click okay for the quantity? Maybe press the button for the first entry but if you have multiple entries, can you trigger it to repeat once you click okay on quantity?
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.
Great video! Quick question. Why are rows 4-7 hidden on your InboundBarcode sheet? The items scanned start on row 8 for the InboundBarcode sheet, but start on row 4 for OutboundBarcode sheet? Why?
Update: it looks like sometimes it rows 4-7 show, but other times they do not. Is there a reason for this?
Thanks, no reason the items that are scanned will be saved from row 4.
Hello,
I am new with google sheets and I copied everything on the app script exactly how you have it but I get an error for line 11 for Example:
Error
Exception: Cannot convert ‘ ‘ to int.
Inv_Change @ Codegs:11
Do you know what this means?
It means that you have inputted an empty string or referenced a blank cell , when the code is looking for an integer.
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! Great video. Question. If I were to purchase this file from your patreon would I be able to upload it on google sheets and have it work properly? Thanks
Thank you. Yes, after purchasing the file you will be prompted to create your own copy of the file on your account.
Great! Thanks for the quick response. Accidentally posted the question multiple times 😅
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.
How come I get a message that this file does not exist when trying to open the link on the pdf?
Please try again, I sent you a message directly with instructions.
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?
can i get the excel template
The file is available on my Patreon page:
www.patreon.com/ExcelHighway
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?
The file is available on my Patreon page:
www.patreon.com/posts/96483205/
@@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
please share the file
The file is available on my Patreon page:
www.patreon.com/ExcelHighway
Hello,
I am new with google sheets and I copied everything on the app script exactly how you have it but I get an error for line 11 for Example:
Error
Exception: Cannot convert ‘ ‘ to int.
Inv_Change @ Codegs:11
Do you know what this means?
It means that you have inputted an empty string or referenced a blank cell , when the code is looking for an integer.