How Can We Help?
Scan Actions For Spreadsheet Add-ons
When scanning barcodes, QR codes, and NFC tags, extra data can be created on the spreadsheet as a result of the scan. These data can include date, time, or other arbitrary data that you define. For example, you may want to update one column with a status, and another column with the date or time.
If you’re using our smartphone apps for scanning, you can also set the add-on to return data to display to the person scanning the barcodes or NFC tags. For example, you can scan a product’s QR code, and if found in the spreadsheet, the product’s name and location are returned.
Creating Data
For the Find, Mark & Replace, and the Insert & Replace scan actions, under the Select Headers dropdown, select the headers where the extra data should be created.
Under the Values To Replace With, enter what should be created. For the date, time, and GPS coordinates, use the tokens below.
If you’ve selected multiple headers, separate the Values To Replace With with commas. Each separation should map to the selected header.
Date Tokens
Include the brackets as shown.
Example: {mm/dd/yyyy}
Token | Example | Description |
---|---|---|
dd | 05 | Day of the month, two digits (01–31). |
d | 5 | Day of the month, without leading zero. |
mm | 03 | Month number, two digits (01–12). |
m | 3 | Month number, without leading zero. |
yyyy | 2025 | Full year in four digits. |
yy | 25 | Year in two digits (last two digits of the year). |
Time Tokens
Include the brackets as shown.
Example: {hh:MM}
Token | Example (2:07:09 PM) | Description |
---|---|---|
hh | 14 | Hour in 24-hour format, two digits (00–23). |
h | 14 | Hour in 24-hour format, no leading zero. |
MM | 07 | Minutes, two digits (00–59). |
M | 7 | Minutes, without leading zero. |
ss | 09 | Seconds, two digits (00–59). |
s | 9 | Seconds, without leading zero. |
GPS Coordinates
This is only available when using our smartphone app. Include the brackets as shown.
Example:{latitude}
Token | Description |
---|---|
latitude | Latitude |
longitude | Longitude |
Returning Data
To specify what should be displayed on the smartphone app after the scan, under the Select Headers dropdown, choose the columns you want. A maximum of five columns is allowed.
Smartphone App Constraints
Configuration
Visiting the configuration link or scanning its QR code will override the previously saved ones. This enables different users to have different configuration settings.
Previously saved configurations are available on the smartphone for the user to choose.
Permissions
You can disallow the smartphone user from making changes to the scan behaviour.
Scanning Session
The sidebar must remain open to receive scan data from the smartphone app.
You can, however, pause and resume the session from the scan settings page.