QuickBase Integration – Overview
Already a codeREADr customer? If you also subscribe to QuickBase you’ll have extensive capabilities for managing all your data in the cloud.
Already a QuickBase customer? If you subscribe to codeREADr you can quickly & accurately scan barcodes, collect multiple choice & form data, GPS locations, photos, timestamps, etc. You can do that both online and offline using the native codeREADr iOS and Android apps and insert that data into QuickBase tables.
Not a customer of either service? The integration super-charges QuickBase’s best-in-class cloud service with codeREADr’s native, enterprise-grade app to quickly and accurately scan barcodes and capture, validate and collect associated data into a formal record — anywhere, anytime.
There are three (3) ways to use QuickBase with codeREADr.
1. Direct API Integration
This process uses our APIs to automate the process to eliminate manual uploading and downloading files. You create specific tables within QuickBase to automatically insert data captured by your authorized codeREADr app-user(s). Also, the data viewed by the app-user after each scan is current with the data in the associated QuickBase table.
For direct integration we created a ‘wizard’ for you to simply connect codeREADr to QuickBase. No programming is necessary. You don’t even need to learn the codeREADr platform (unless you need special features). All you need to do is associate each QuickBase field to a codeREADr field. From that we auto-generate the codeREADr ‘Service’ (workflow) so your authorized app-users can immediately start scanning.
What can you do with direct integration? To your QuickBase tables your app-users can:
- Add new record.
- Edit an existing record.
- Edit existing or add new record.
- Edit existing or add new record IF user inputs at least one value.
Here’s an example of a QuickBase table using the API option. The most important differentiators include:
- auto-insertion into key fields (no uploading)
- scan data from multiple codeREADr Services can be inserted in a single table and optionally in a single row.
In the example below, the Pack, Pick-up and Delivery tasks were completed by different field workers each scanning the same Tracking ID. The scans records for each are shown in this table in a single row based on the Tracking ID. This enables easier use of formulas for reporting purposes. See 2-minute video here.
2. Import/Export CSV
Without using codeREADr or QuickBase APIs you can create codeREADr Services directly on the codeREADr.com web site.
If a record-only type Service (i.e. no database required) you simply decide what information you want to collect after each scan. If a validation type Service (i.e. validating against a database of barcode values) you also determine what information you want to collect after each scan but you need to also import a simple CSV file to codeREADr’s servers. That file includes the barcode values to validate against and any associated content, such as conditions or descriptions for those values.
After scanning, you can filter and export a CSV file of your scan records and import them into QuickBase.
Here’s a CSV export from codeREADr.com:
And here’s the file after importing to your QuickBase table:
Once your data is in QuickBase you can build you applications and generate reports.
The CSV option is especially valuable in cases where the app-user could have slow or unstable Internet connectivity but still needs to quickly both view and validate each scan.
For example, let’s say you need to validate tickets, badges or IDs for an event. If connectivity is slow, then lines build up quickly. If you create your Service on codeREADr, the event’s database can be downloaded directly to the app for instant viewing and validation of each ID.
Or, for example, let’s say the app-user needs to know the current condition or status of an asset before updating the record but there’s no Internet connectivity. Here, too, the offline viewing and validation of the asset database is of great value.
3. Keyboard as Barcode Scanner
[This option will be made publicly available mid-late April 2016 and will be only compatible with Android devices. It’s not currently possible for iOS devices. You will need to download a special version of the codeREADr app.]
With this option you don’t need to use the codeREADr or QuickBase APIs and you don’t need to create any associations. Instead, you use your standard QuickBase apps and view them on Android devices as currently done. See 30-second video here.
To scan a barcode, you tap the form field into which you want to insert the barcode value. The cursor will blink in that field and the custom codeREADr keyboard will open, including a SCAN button to launch the camera for scanning. Once the value populates that field, the camera closes and you can can either scan again, manually enter text with the keyboard or close the keyboard and continue your normal work flow within the QuickBase app.
If the task assigned to a field worker requires a lot of scanning this method is more time consuming than when using the standard codeREADr app. Why? Because with this option the worker must find the appropriate field, tap it and then scan.
Whereas with the standard codeREADr app using the API or CSV options you create the workflow within a codeREADr Service optimized for rapid, successive scanning.