Use a barcode scanner with AppSheet as described in the following sections:
- Overview of barcode scanning with AppSheet
- Get started with a sample template
- Enable barcode scanning
- Test barcode scanning
Note: Barcode scanning is supported for Core and Enterprise plans only.
The following sections provide more details about barcode scanning with AppSheet:
- Supported barcode scanners
- Supported barcode formats
- General limitations of barcode scanning using AppSheet
AppSheet supports two options for barcode scanning on your mobile device.
Provides barcode scanning out of the box.
Requires no additional set up after you enable barcode scanning in your app.
Delivers a robust set of barcode scanning features and formats for situations where scanning conditions are more challenging (such as, poor light, damaged or bent barcodes) or when you need to scan a lot of codes.
You must have a Scandit account and register a license key with AppSheet in order to use Scandit for barcode scanning. See Use Scandit.
AppSheet supports the barcode formats, or symbologies, out of the box.
- Code 39
- Code 93
- Code 128
- Data Matrix
- EAN-8 and EAN-13
- Interleaved 2 of 5 (ITF)
- QR Code
- UPC-A and UPC-E
The Scandit barcode scanner also supports the following formats:
- Code 11
- Code 25
- EAN 13+2
- EAN 13+5
- GS1 Databar
- Micro PDF417
- Truncated PDF417
Note: Not all formats supported by Scandit are enabled in AppSheet at the moment. Contact AppSheet Support if you are interested in a particular format.
The limitations of barcode scanning with AppSheet include the following:
- Scanning is supported only when running an app on mobile devices.
- Scanning is not supported:
- When running an app in a web browser. The Scan button is not shown.
- In the app editor's emulator window. The Scan button is displayed to show you how the app would look like on a mobile device, but it is not operational and always generates the same value: 111122333.
- Line breaks in multi-line QR codes will be removed.
To get started using barcode scanning, check out the Inventory Management sample template. The Inventory Management template manages inventory items and enables you to use a barcode scanner to generate the Item ID when adding a new item.
Enable barcode scanning as described in the following sections:
- Enable barcode scanning using the camera on a mobile device
- Enable barcode scanning using an external barcode scanner
By default, the System default barcode scanner is enabled. To use Scandit for barcode scanning, you also need to register your Scandit account with AppSheet and enable Scandit for barcode scanning. See Use Scandit.
To enable barcode scanning using the camera on a mobile device:
- Open your app in the app editor.
- Select Data > Columns.
- Click the table for which you want to enable barcode scanning.
Perform one of the following tasks:
Enable the Scan setting for the desired column in the column list.
Optionally, enable Search to enable scanned input in the app's built-in search box at the top of the app screen.
Click the Edit (pencil) icon to open the row configuration dialog, expand Other Properties, and enable Scannable.
Optionally, enable Searchable to enable scanned input in the app's built-in search box at the top of the app screen.
Save your changes.
After you enable barcode scanning, within the app the column will include an icon to indicate its input may be scanned:
If a column that is scannable is also searchable, the app's built-in search box at the top of the app screen will also allow scanned input, as indicated by the scan icon:
Set the type of the column to Text. Any supported external barcode scanner that interacts with your mobile device as a keyboard when a barcode is scanned will insert the barcode into the text field on the input form.
Test barcode and QR code scanning by running your AppSheet app on a mobile device.
Note: Barcode scanning is not available from within the browser-based app or the app editor's emulator window. See General limitations of barcode scanning with AppSheet.