This tutorial explains on automation of sheet activities like creating a sheet, copying sheet, clearing values using App script. For demonstration, I have taken 2 scenario Creating new Spreadsheet every Month’s 1st day. copying data from daily sheet to the Monthly sheet at a specified time every day. Step 1: Create a Spreadsheet which holds […]
This tutorial is the continuation part of previous QR scanner App. Here we are making real-world application with little modification in the logic. Please follow every step carefully. This App Development consists two parts creating backend using app script & Sheets. Building an Android app using App Inventor. 1 creating backend using app script & Sheets. Step 1: […]
Step 1: Create New Project in App Inventor Step 2: Add new Screen Step 3: Add Block Logic as below Step 4: Create Screen2 and add the following components […]
This tutorial explains to write an app script to search Key element in a sheet. This is useful in many scenarios. Please refer other tutorials to know the application of this operation. var ss = SpreadsheetApp.openByUrl(“Your Spread Sheet URL”); var sheet = ss.getSheetByName(“Sheet1”); function doGet(e){ return search(e) ; } function doPost(e){ return search(e) ; […]
This tutorial explains about storing QR code scanned data in Google Spread Sheet. This is very simple application which uses Zxing Qr code api, Android http client and Goolge App script. Here It consists of 2 Parts, Google App Script Part (Back End) Android Part (Front End) [maxbutton id=”1″ url=”https://github.com/androidLabsCode/QrCodeToGsheet” ] 1.Google […]
Powered by WordPress Crazy Coders Club 2025 | All Rights Reserved.
