#qrcode #barcode #barcodescanners #webappscript #googleappscript #googlesheets
Ditch the Paper: Scan product info with QR codes and manage your inventory directly in Google Sheets, accessible from anywhere on any device.
Boost Efficiency: Say goodbye to manual data entry errors and expensive software. Enjoy real-time inventory updates and mobile management for a smoother workflow.
Embrace the Future: Join the growing trend of QR code and web app adoption, unlocking a cost-effective and customizable solution for effortless inventory control.
Free & Customizable: This web app is completely free to use and adapt to your specific needs. Add additional data fields, create custom categories, and make it your own.
About the Web App
This web app empowers shop owners to effortlessly scan product barcodes or QR codes, input additional details, and seamlessly submit the information directly to a Google Sheets inventory list. It reduces the need for manual data entry, saving time and reducing errors.
The web application primarily comprises two major sections: namely, the QR Scanner and the Data Entry Form. The data entry form is similar to the one we discussed in an earlier blog post. What is new here is that we have integrated a QR and barcode scanner into this web app to scan the products and input the codes into the data entry form. Therefore, users can insert the QR code along with other product details such as name, price, category, and quantity into the Google Sheets. This way, users can easily update their inventory in Google Sheets.
This is a responsive web app. Therefore, users can utilize it on their mobile phones and leverage their cameras to easily scan QR and barcode without needing to purchase additional equipment.
Here’s how to deploy the web app to scan QR/Bar codes to take your inventory to Google Sheets.
To use this, you’ll need to deploy it as a web app in your Google Account. Below, I will briefly explain the deployment process and guide you on how to use it for scanning QR codes and barcodes. Then, in the next section, I will delve into the code and explain how you can customize it to fit your requirements.
Here is a brief overview of the workflow.
Copy the below Google Sheets template to your Google Drive.
Open the script editor and deploy it as a web app (Google Guide).
In your Google Sheets, Go to Extensions -- Apps Script to open the script editor
Go to Deploy --New deployment
Go to Select type (⚙️icon)- -Web App
Enter the information about your web app in the fields under “Configuration.” Select your email and “Anyone” if you want to access the web app without logging in to your Google Account.
Click Deploy. (When you run the script for the first time, you will be prompted to grant permissions. To do so, please click on ‘Continue’, select your email, click on ‘Advanced’, click on the name with the ‘Apps Script’ label, and then click ‘Allow’ on the next screen.)
Copy the web app URL
Access the web app link in your mobile phone browser (“Try opening the web app in an incognito window if you encounter any difficulties accessing it.”).
Click the “Request Camera Permissions” button and allow access to the camera. Select a back camera if you have multiple cameras on your phone.
Click the Start Scanning button, scan the product QR/ Bar code, and add details such as product name, quantity, price, and category.
Submit the form and your data will be saved in the Google Sheets.
Continue to the next scan…
Subscribe to our UA-cam - ua-cam.com/channels/wQsIx8ayeCswM5Kxr8_9yw.html
🔗 Spreadsheet Link:docs.google.com/spreadsheets/d/1fTJLEGrQrvi_EtnekLkpG3BJP7Gf5udy9DLih9UfA0U/edit?usp=sharing
DEMO LINK:script.google.com/macros/s/AKfycbyZMcqk1rAlbSWU4YY4TM5bZTiO55axYUQGqzzjQuo/dev
www.linkedin.com/in/safdar-dasti-093813133/
tibbaimam.taunsa.9
ua-cam.com/video/d5jldH_DE0M/v-deo.html
ua-cam.com/video/nP6bUCY3n44/v-deo.html
ua-cam.com/video/-DtEhQAjgiU/v-deo.html
ua-cam.com/video/DduTQoun7pY/v-deo.html
ua-cam.com/video/eXBs58wDtWg/v-deo.html
ua-cam.com/video/rnmaPoKOkRM/v-deo.html
ua-cam.com/video/wE89R-uZalk/v-deo.html
ua-cam.com/video/s8DZsBbTz_M/v-deo.html
ua-cam.com/video/GVfMcO7n8YM/v-deo.html
ua-cam.com/video/0IOREUQZPBM/v-deo.html
ua-cam.com/video/zvkQOThqzV4/v-deo.html