Automatically populate data by scanning barcode | Zoho Creator Academy

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

  • Apple

  • Samsung

  • One Plus

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:
  1. //Construct an image HTML tag that invokes the third-party API  to generate barcode and upload the link to the Image field
  2. input.IMEI_Barcode = "<img src=\"http://bwipjs-api.metafloor.com/?bcid=code128&text=" + input.IMEI_Number + "\"/>";

  3. // Show the preview of the generated code using notes field
  4. 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

  • Apple

  • Samsung

  • One Plus

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.
  1. //fetch data using integration task and replace the parameters according to your application
  2. mobileData = zoho.creator.getRecords("<app_owner>","order-management","All_Products","IMEI_Number==" + input.IMEI,1,200,"creator");
  3. record = mobileData.get("data");
  4. input.Product_Name = record.getJSON("Product_Name");
  5. input.Product_Group = record.getJSON("Product_Group");

See how it works


Points to note

  1. 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.
  2. ​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:
  1. input.notes = "Generated Code:<br><br><div><img src='https://qrcode.tec-it.com/API/QRCode?data=" + input.IMEI_Number + "' width='150'/><br/></div>";
  2. input.imageField = "<img src='https://qrcode.tec-it.com/API/QRCode?data=" + input.IMEI_Number + "'/>";
  1. Data can also be fetched from other apps using functions API.
  1. Functions
  2. Call Function
  3. Creator Fetch API
  4. Creator Fetch Records Integration Task
  5. Connections

    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                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.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • 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 ...
                                                                                                  • 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 ...
                                                                                                  • Scan QR code and bar code

                                                                                                    Understand scanning QR code and bar code to enter input in form fields Applicable to following fields: single line, multi line, email, URL, number, percent, currency, and decimal. Scanning a QR code and bar code is available only when your users ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources