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


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        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


                                                              • Desk Community Learning Series


                                                              • Digest


                                                              • Functions


                                                              • Meetups


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner


                                                              • Word of the Day


                                                              • Ask the Experts


                                                                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 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 ...
                                                                                                                        • Adding a Salesforce field to a form

                                                                                                                          Prerequisite : The Application Programming Interface (API) feature must be enabled for your Salesforce organization. Open the form builder. Add an integration field to the form. (Refer to this page to see how to add a field to a form) Select ...
                                                                                                                        • Understand Connections

                                                                                                                          This help page is for users in Creator 6. If you are in the older version (Creator 5), click here. Know your Creator version What Does This Page Cover? Learn about connections and their types that can be used to integrate your Creator application ...
                                                                                                                        • Create an application for solution

                                                                                                                          Zoho Creator enables you to create an app solution based on your business requirement. You can create an application to run your business in a streamlined manner with the capabilities that Creator has to offer. An application helps you solve problems ...
                                                                                                                        • Adding an administrator to Creator account

                                                                                                                          Administrators in Zoho Creator have full access across the platform, including both edit and live modes of applications, BI & Analytics, and Integration Flows. They can build and edit application schemas, manage all application data, handle user ...
                                                                                                                          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