Setup Guide (Archived)

(for app version 1.7 or above)

Step 1. Create a Google Spreadsheet and share it with your Google account (with edit permission) so that your Google account can edit it

Make sure you select **can edit** (NOT can view / can comment) when asked

To see Spreadsheet ID and Sheet Name, open the Google sheet in web browser, then refer to the below image.

For this image, SpreadsheetID would be 1RwPt-bfNzl0qyai11ItkUkpm13Ldlaa-psND1NmSP0s and Sheet Name would be Sheet1.

Start column: Start column of the table to insert data. If a table is found overlapping the start column, the data will be merged to that table.
Automatically create sheet if not exists (Available from app version 1.7)

If checked, the app will create the sheet when you next scan a barcode if the specified sheet is not found in the Google Spreadsheet.

Sheet name format (Available from app version 1.10)
- Normal: Sheet name on Google Spreadsheet will be exactly as what you specified in the app
- Date: Sheet name specified in the app (e.g. yyyy-MM-dd) will be converted to today's date/time as the sheet name in Google Spreadsheet (e.g. 2020-07-01). The date/time conversion logic uses java "Simple Date Format". For details, refer to "Date and Time Patterns" and "Examples" section in: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

To customize this app (e.g. sending timestamp and geolocation along with the scanned barcodes, or other app effects), visit "Settings" in the app.

Last updated: 26th June 2020

Page updated

Google Sites

Report abuse