Offline-to-Online apps

Utilize QR codes and barcodes (coming soon: NFC, iBeacons, Bluetooth and more) to bridge the gap between the real world and your data. Create powerful applications to create and access rich data related to any physical objects, from toothbrushes to trucks.

The basic use case of offline-to-online apps is to attach business information to physical objects. This means that when you use your Composer-built app to scan a QR code on a truck or read a barcode on a product, the business information related to that physical object is brought up. The information can be anything: simple text data, information about a product, attached files and comments, relationships with other data, image galleries and so on. The possibilities are endless.

Example

Warehouse Inventory Management

Many companies have warehouse inventory data in SQL databases. Keeping the data up-to-date might work fine, but it’s still a big job to dig up relevant product information – especially when you’re in the warehouse and not on your computer. Furthermore, there’s additional content like PDF manuals that you’d like to be able to access easily.

Composer lets us create an app that allows warehouse workers to use their mobile phones to scan a product’s barcode, which instantly brings up that product’s data record from the SQL database, including attached files. (Of course, you could import the product data from a CSV file, fetch it from an API or even input it manually for each product.)

Example App Features

  • Scan barcode with mobile app to bring up product data
  • Get up-to-date product data from an SQL database
  • Attach PDF manuals and other files to each product
  • Let warehouse workers add comments to individual products
  • If the inventory data in the database doesn’t match what’s on the self, make corrections from the app

We connect our Composer to our SQL database, which automatically creates an app that lets us browse and manage product data (if desired, we can make the data read-only). We then add a QR reader feature to our app and point towards our newly-created “Products” resource.

Next, we need to provide an unique identifier for each product. This allows our Composer app to know which product data record to bring up when the barcode is scanned.

To identify individual products, we’ll use the unique Stock-Keeping Unit (SKU) numbers that are already included for each product in the database, as well as printed on barcodes on each product.

In Composer, we select the SKU field as the identifier for our QR reader feature. We’ll also add the Comments and Files features for each product, which allows us to add comments and attach PDF manuals to each individual product.

Now, when we scan a product’s barcode with our Composer app, we get a record that shows the product information from the database, as well as files and comments related to the product. The same data is also available in the web app, which we can use to upload the PDF manuals for each product.

Since the database connection is two-way, we can e.g. quickly see if the database inventory count doesn’t match what’s on the shelf and adjust it on the fly.

Other examples for this case
  • MAINTENANCE HISTORY

    Access maintenance history of vehicles and other products by scanning a QR code. Place new work orders at the touch fo a button.
  • TRACK EQUIPMENT LOANS AND USAGE

    When a piece of equipment is used or loaned out, input the necessary details via a mobile app.
  • MILEAGE REPORTS

    Create a new mileage report by scanning a QR code on the dashboard of a company vehicle.

Customer Case:

Repair History and Service Ordering App for Rocla

Solution Provider:

AppGyver

Customer:

Rocla (a subsidiary of Mitsubishi), a global manufacturer of forklifts

Problem:

For each forklift sold and delivered to a client by Rocla, there exists a lot of relevant data: warranty dates, contact phone numbers, user manuals, repair orders, lists of past repairs done, and more. However, the data was spread out to over different systems, and accessing it in the context of the physical forklift was not as fluent and efficient as it could be.

This meant huge losses in efficiency and even actual money: with customer satisfaction foremost in mind, Rocla ended up performing maintenance for free when they could’ve charged for it. This was a consequence of the problems that arose when working to combine all the relevant data from the various systems.

Solution:

Using Composer, AppGyver created a mobile app for Rocla that allowed the relevant data for every forklift to be easily accessed on-the-go. Each forklift will be equipped with a heavy-duty QR code sticker, suitable for warehouse conditions. When the QR code is scanned with Rocla’s app, the data record for that particular forklift is automatically pulled up.

The data contains basic information like forklift identifier numbers, models, current warehouse location and customer contact information. Additionally, each forklift record includes PDF user manuals, a list of past repairs (brought in via an API from an existing external system) and outstanding and completed repair orders.

Finally, a web app interface is also available for admins to locate forklifts by customer, identifier and any other properties.

Benefit:

Forklift data is now readily accessible, allowing Rocla’s employees to quickly check e.g. warranty validity. Customers can also easily reference the attached user manuals, without having to store physical paper copies in each forklift.

Customers can now create repair orders for broken forklifts directly from the app, and even attach photos to better show the damages. When a new repair order is created, an email is automatically sent to the maintenance engineer responsible for that customer’s forklifts. Since everything is available from the app, there’s no need to go back to the computer to order repairs.

The forklift’s repair history then enables Rocla’s maintenance engineers to immediately see how the particular forklift has been serviced in the past, and plan repairs accordingly.

“AppGyver has enabled us to truly free our business data from the depths of legacy systems. Both our employees and customers can now access relevant information in the field with unsurpassed speed. This greatly increases our ability to communicate and create value with our customers. With Composer, we can design the app around the business process, not the other way around. AppGyver is a fantastic partner to work with, and we can't wait to create more apps with Composer.”

Jari Valtanen, VP, BU North, Rocla