Do either A or B:
A: If share with specific people and groups, select **Editor** for them. (recommended)
B: If share with anyone via link, make sure it shows **can edit**
For details, see: https://support.google.com/docs/answer/2494822
To see Spreadsheet ID and Sheet Name, open the Google sheet in a web browser, then refer to the below image.
In this image, Spreadsheet ID would be 1RwPt-bfNzl0qyai11ItkUkpm13Ldlaa-psND1NmSP0s and Sheet Name would be Sheet1.
Hint: To avoid typing these on your phone, you may convert these into QR Codes using online QR code generators. Then use the app to capture the values directly.
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. adding timestamp, geolocation to the barcodes, or other app features), visit "Settings" in the app.
Last updated: 22nd August 2021