Automatically populate data by scanning barcode
Requirement
Scan a barcode to fetch the required details stored in another app.
Use Case
A mobile store uses an order management application to manage their orders. When a product is added to the form, a corresponding barcode is automatically generated and uploaded along with the product details.
The store uses another application for mobile phone servicing to scan the same barcode sticker on the mobile phone for quick retrieval of the product details.
Steps to follow
1. Lets us first build an order management application. Create a form with the following details.
details.
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Product | Product | Dropdown
| Product Group
| Product_Group |
Single line | Product Name | Product_Name | ||
Number | IMEI Number | IMEI_Number | ||
Image | IMEI Barcode* | IMEI_Barcode | ||
Add Notes | Add Notes | plain |
2. Check the Link option under Browse from field properties of the image field. This allows you to directly add the URL of the barcode image you want to upload.
3. Create a workflow with the following details.
4. Click Add New Action and add the following snippet:
- //Construct an image HTML tag that invokes the third-party API to generate barcode and upload the link to the Image field
- input.IMEI_Barcode = "<img src=\"http://bwipjs-api.metafloor.com/?bcid=code128&text=" + input.IMEI_Number + "\"/>";
- // Show the preview of the generated code using notes field
- input.notes = "Generated Code:<br><br><div><img src='http://bwipjs-api.metafloor.com/?bcid=code128&text=" + input.IMEI_Number + "'/><br/></div>";
5. Add a few records to this app.
6. Now let's build another app named Mobile Phone Servicing. Create a form with the following details.
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Product | Product | Number | IMEI | IMEI |
|
| Dropdown
| Product Group
| Product_Group |
Single line | Product Name | Product_Name | ||
Multi Line | Issue | Issue |
6. Enable QR code and Barcode scanning for IMEI field.
Now let's create a connection that will be used later in this tutorial.
7. Navigate to Microservices and click + Create New to create a new connection.
8. Select Zoho OAuth
9.Select the required scopes for Creator, fill in other details, and click Create and Authorize.
Ensure that the connection is enabled for this app.
10. Create a workflow with the following details.
11. Click Add New Action and save the following script in the deluge editor.
- //fetch data using integration task and replace the parameters according to your application
- mobileData = zoho.creator.getRecords("<app_owner>","order-management","All_Products","IMEI_Number==" + input.IMEI,1,200,"creator");
- record = mobileData.get("data");
- input.Product_Name = record.getJSON("Product_Name");
- input.Product_Group = record.getJSON("Product_Group");
See how it works
Points to note
- This tutorial uses an open-source barcode generator API to achieve the desired result. You can use any API you wish to generate the barcode.
- ​The same procedure can also be used to generate any coded image. For example, use the below script to generate QR code instead of barcode:
- input.notes = "Generated Code:<br><br><div><img src='https://qrcode.tec-it.com/API/QRCode?data=" + input.IMEI_Number + "' width='150'/><br/></div>";
- input.imageField = "<img src='https://qrcode.tec-it.com/API/QRCode?data=" + input.IMEI_Number + "'/>";
- Data can also be fetched from other apps using functions API.
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Add subform rows with dynamic data from another subform
Requirement Automatically add rows to a subform and populate it with dynamic data fetched from another subform. Use Case A form named Orders Database contains customer details and their frequent orders in a subform. We have another ...Generate Barcode using third-party API
Requirement Generate a barcode based on the provided IMEI (International Mobile Equipment Identity) number using a third-party API. Use Case A mobile store uses an order management application to manage their orders. The application has a form ...Auto-populate subform data from a form based on lookup selection
Requirements Streamline the process of retrieving and displaying relevant data by auto-populating a subform based on the value selected in a lookup field. Use Case Consider an IT asset management application used by organizations to conduct asset ...Autopopulate Zoho Creator field with Zoho People data
Requirement Autopopulate Zoho Creator field with employee information stored in Zoho People. Use case Let's assume an organization named Zylker has a private library. The regular users must purchase a membership in order to access the library, ...Auto populate a field based on the selection from a lookup dropdown
Requirement When a value is chosen from a lookup dropdown, related values are populated in the other fields of the same form. Use Case An order management app contains a form to store order details. When the admin chooses the customer name from ...
New to Zoho LandingPage?
Zoho LandingPage Resources