Automating Data Exchange between Salesforce and Zoho Creator

Automating Data Exchange between Salesforce and Zoho Creator

Requirement

Enhance customer management by integrating the Contacts module of Salesforce with Zoho Creator.

Use Case

Consider an organization that manufactures electronic products and utilizes Zoho Creator Order Management Application for sales and relies on Salesforce for CRM. They use Creator for order placement and product inventory management, and Salesforce to implement customer retargeting and analyze purchasing trends. When a customer wants to buy a product, the customer will approach the sales person and the sales person will place the order in the New Order form of the Order Management Creator application. There are two types of customers: new customers and existing customers.

When a new customer approaches to place an order, the Salesforce integration form will be used to facilitate the collection of essential customer details. This data will be transferred automatically to the Salesforce Contacts module, after which the order will be placed.

For existing customers, the system will seamlessly cross-reference the entered customer's email with the records stored in the Salesforce Contacts module. Consequently, pertinent fields associated with the customer, such as name, phone number, address in the New order form, will be auto-populated by extracting the relevant data from the Salesforce to place the order.

Prerequisites

A Salesforce account to store and retrieve customer details from its Contacts module.

Steps to Follow

Info: Datasource and connection are necessary for creating an integration form or integration field. If you already have them created, you can simply select the required datasource or connection. However, in the below steps, you will be creating a new datasource and connection while creating an integration form.
  1. Create an integration form to add the customer details to Salesforce, with the name Customer Details, and click Add Datasource.

  2. Click Add Connection in the pop-up to create a Salesforce connection.

  3. Provide the details shown below and click Create and Authorize.

    You will be routed to the Add Datasource page.
  4. Fill in the details as shown in the below image, then click Create.

    Upon successful creation, the form builder of your new integrated Customer Details Salesforce form will open.
  5. Drag and drop the following Salesforce's contact modules fields from the left pane of the form builder into your form. You can also add other fields from your Salesforce Contacts module depending on your preference.
    This use case can be demonstrated using just the above-mentioned fields. You can include as many fields as required.
    1.  

    2. Form

      Form Link Name

      Field Link Name

      Field Name

      Customer Details

      Customer_Details

      firstname

      First Name

      lastname

      Last Name

      email

      Email

      phone

      Phone

      mailingstreet

      Mailing Street

      mailingcity

      Mailing City

      mailingcountry

      Mailing Country

      mailingpostalcode

      Mailing Zip/Postal Code

  6. Create a form with the following details to collect orders from the customer.
    1.  

    2. Form

      Form Link Name

      Field Type

      Field Name

      Field Link Name

       

       

      New Order

       

       

      New_Order

      Integration

      Email

      Email

      Decision Box

      New Customer

      New_Customer

      Name

      Customer Name

      Customer_Name

      Phone

      Mobile

      Mobile

      Address

      Address

      Address

      SubForm

      • Single Line

      • Number

      • Currency

      Orders List

      • Product

      • Quantity

      • Total Cost

      Orders_List

      • Product

      • Quantity

      • Total_Cost

      Currency

      Grand Total

      Grand_Total

    Note: While creating an integration field in the New Orders form, select the details as shown below. You can also select the same datasource which is selected while creating the integration form.
  7. Create a workflow to execute on user input of the New Customer field in the New Order form with the details shown below. This workflow will open the Customer Details integration form in pop-up, if the New Customer decision box is selected.

  8. Add the folowing code in the Deluge editor.
    1. //When the New Customer decision box is selected, the OpenUrl task opens the Customer Details integration form in a pop-up.
    2. if(New_Customer == true)
    3. {
    4. openUrl("#Form:Customer_Details","popup window","height=700,width=550");
    5. }
  9. Create another workflow to execute on user input of Email field in the New Order form with the details shown below. This workflow will fetch the customer details form the Salesforce and auto populate data in the respective fields.

  10. Add the followingcode in the Deluge editor.
  1. // Create a list to add the required fields that needs to be fetched from the Salesforce contact module 
  2. fieldList = List();
  3. fieldList.add("firstname");
  4. fieldList.add("lastname");
  5. fieldList.add("email");
  6. fieldList.add("phone");
  7. fieldList.add("mailingstreet");
  8. fieldList.add("mailingcity");
  9. fieldList.add("mailingstate");
  10. fieldList.add("mailingcountry");
  11. fieldList.add("mailingpostalcode");
  12. //Create a variable to store the response of the Salesforce - Get Records integration task which fetches the record from the Salesforce contacts module matching the email Id from the Email field.
  13. response = salesforce.sales.getRecords("Salesforce","contact","ID=" + "'" + input.Email + "'",fieldList);
  14. //If the Email field is not empty, populate the respective fields with the Salesforce - Get Records integration task response; otherwise, fill the respective fields with an empty string.
  15. if(Email.isEmpty() == false)
  16. {
  17.  input.Name.first_name = response.getJSON("records").getJSON("FirstName");
  18.  input.Name.last_name = response.getJSON("records").getJSON("LastName");
  19.  input.Phone_Number = response.getJSON("records").getJSON("Phone");
  20.  input.Address.address_line_1 = response.getJSON("records").getJSON("MailingStreet");
  21.  input.Address.district_city = response.getJSON("records").getJSON("MailingCity");
  22.  input.Address.state_province = response.getJSON("records").getJSON("MailingState");
  23.  input.Address.country = response.getJSON("records").getJSON("MailingCountry");
  24.  input.Address.postal_Code = response.getJSON("records").getJSON("MailingPostalCode");
  25. }
  26. else
  27. {
  28.  input.Name.first_name = "";
  29.  input.Name.last_name = "";
  30.  input.Phone_Number = "";
  31.  input.Address.address_line_1 = "";
  32.  input.Address.district_city = "";
  33.  input.Address.state_province = "";
  34.  input.Address.country = "";
  35.  input.Address.postal_Code = "";
  36. }
Steps to follow in your Salesforce account to allow OAuth access to the Zoho Creator application.
  1. Go to the advanced setup in your Salesforce account and navigate to PLATFORM TOOLS > Connected Apps > Connected Apps OAuth Usage.
  2. Click Install from the actions column listed in the Zoho Creator row, as depicted below. This will grant OAuth access to your Creator application.

See How it Works


  1. Understand Integration Forms
  2. Salesforce Integration Tasks
  3. Understand Connections


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

                                                                                                              • Capture data using NFC

                                                                                                                Requirement Capture data from NFC supported tags. Use Case An organization wants a mechanism where its employees can submit feedback about its cafeteria and restrooms by tapping their NFC- enabled ID cards against the feedback collecting ...
                                                                                                              • Automating Portal User Creation with Zoho Creator Forms

                                                                                                                Requirement Automatically create a portal for the user with their email entered in the Zoho Creator form. Use Case Consider a healthcare organization utilizing Zoho Creator to oversee patient data, appointments, and medical records. When a new ...
                                                                                                              • 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, ...
                                                                                                              • FAQs: Zoho Creator - Starter Guide

                                                                                                                This page covers essential insights into Zoho Creator, a low-code platform offering support for multiple languages, shared responsibility models, and the unique Deluge coding language, providing comprehensive assistance for your business needs. What ...
                                                                                                              • Introduction to Zoho Creator Procurement

                                                                                                                Procurement is a constructive method used to streamline an organization’s procurement process in and out to achieve desired results while saving money, managing time, and establishing collaborative supplier relationships. The purpose of procurement ...
                                                                                                                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