Hi, I would like to share a video tutorial of how to scan bar code from books into Google Sheet that I made. https://www.youtube.com/watch?v=p1Av1bGQ7P8
If you are interested on how to do this, check out the step by step tutorial.
Thanks!
Stonez56
Hello. This is a 42 minute long video. Consider posting an aia here or show images of all the Blocks please.
1 Like
One could also take a different approach to this, using a google form to upload the barcode data to an unrestricted google sheet, and download the data from there.
(note: on my device I scan the barcode with the red line at right angles)
1 Like
There is a problem with keeping a row_num for use with a WriteCell block, if this app is used in a multi-user environment.
The risk is that two users might overwrite each other, using the same row_num value.
A safer approach would be to use either a Forms based append or an Add Row block.
Neither approach needs to be told what row number to use, since they add at the end.
2 Likes
When making this tutorial, I didn't anticipate the possible of multiple users scenarios.
App Row Block is a better approach. Thanks!