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









                                                                                                        • 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