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


    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 ...
                                                                                                          • FAQs: Capture Location - Location Data

                                                                                                            This page covers everything you need to know about managing geolocation data capture on your website forms, from informing users about location tracking to enabling and disabling the feature as per consent and privacy regulations.covers What is ...
                                                                                                            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