User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

Problem:
We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.

Summary Solution:
If a quote is created / edited. OnSave a client script checks to see if a deal is linked. If NOT (and it's over $x) then the user is prompted to Create One (via popup) or Link an Existing One. They can't save the quote until this is done.

Prompt options:
  1. If Create One is selected, the user selects options clicks save
  2. If Link One is selected, the user is directed to links an existing deal from the lookup field (manually).
Steps involved.
  1. Create a Client Script for "Edit Page", "Create Page" and paste in the code below.
  2. Change your API names as needed and click save.

Pro's of this method
  1. Opportunities / Deals get auto-created
  2. Allows for more accurate reporting
Con's of this method
  1. It won't help training your reps to create deals before a quote is needed!
  2. If you're not familiar with Client Script, you'll likely struggle

FAQ:
  1. When the quote is marked as won...
  2. When a quote subtotal is updated...
  3. When you have multiple quotes...
  4. When a note is added to the quote... will it update the deal?
    1. No to all of the above BUT you can implement a workflow to achieve this (see PART 2, coming soon)
  5. What will PART 2 of the solution do?
    1. If a quote is marked as won, the deal will update
    2. If quote subtotal is updated, the deal amount will update
      1. If multiple quotes are linked, the quote with highest amount will be used
    3. If a quote note is added, it gets auto-added to the deal
    4. If a quote is marked as Declined the deal is updated, unless it has other active quotes, then it does not change the deal stage
  6. Does it assign the correct Account, Contact and Owner?
    1. Yes. It takes the details from the Quote
  7. Does this solve every scenario?
    1. Absolutely not!!
  8. I don't know Client Script, can I still implement this?
    1. Yes, however it will likely come with some frustration but it's worth it!
  9. Do I need multiple scripts for each action (create, edit, clone?)
    1. Ideally you would have a static resource that you call just once... if you don't know what that is, then it's easier to create one script for each.

Steps for Creating Quote (repeat for edit or clone):
  1. Go to Settings > Client Script
  2. Click "New Script" and add name, description.
    1. Category: Module.
    2. Page: Create Page (Standard)
    3. Module: Quotes
    4. Layout: whichever is relevant to you
    5. Event Details:
      1. Type: Page Event
      2. Event: onSave
  3. Click "Next" and paste in code below (see auto-create-deal.txt)
    1. Note: Please verify all your API names match up.





      • Sticky Posts

      • Function #46: Auto-Calculate Sales Margin on a Quote

        Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it's
      • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

        Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such
      • User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

        Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.
      • Custom Function : Automatically send the Quote to the related contact

        Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow
      • Function #50: Schedule Calls to records

        Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM

        • Recent Topics

        • Function #50: Send Mass emails to your customers

          Hello everyone, and welcome back to our series! We have reached a milestone of 50 Functions, which means that we have automated 50 different tasks in Zoho Books. Every Friday, we have shared a nifty function aimed at either automating a task or streamlining
        • Time tracking

          Hi there We are looking for a simple, intuitive but powerful time track application. We bill our clients by the time we spend, and so need to link Clients<>Projects<>Tasks or Activities<> Time spent. Is there an app in Zoho we could use? Many thanks.. Morri
        • Staff Tracking in

          Hi , I would like to see what activity my staff does over Zoho CRM and over Zoho Mail . I need to know which deals in CRM haven't been touched or had an activity on by a particular staff member . Basically need to establish what work.gets done by WFH
        • Zoho Projects connector with Zoho CRM (Related List module) features

          Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
        • Report: avg time to visit each lead

          We are on zoho one. our sales team visits leads using the ZohoCRM app. They track their hours using the zoho books timer. So the results in zoho books look like this: -total hours worked: 8 In ZohoCRM we have a custom date/time field in each lead record
        • Creating a Stop Start Timer for Custom Moduel

          Hello, I am trying to track Maintenance of internal Assets through Zoho CRM (I have tried the FSM, Projects, Inventory apps nothing is working the way I need it to). I have it all built in the CRM where I have internal work orders where i can keep track
        • Logging time to a Sales Lead in CRM

          Hi, Is there a way to log time against a Sales Lead / Deal in CRM before it is won and becomes a project? Our employees often do work for sales opportunities and need to log time against them at any point of the sales cycle, before it is won. Thanks, Atif
        • Hourly Billing in Zoho CRM Deals, Books, and Projects?

          We bill on an hourly basis and need that time added into a client's invoice in Books. A client might have multiple deals open with us that we are working on, and billing separately, and thus need separate invoices for each. The functionality of Projects
        • Time taken on a task

          I notice that you can record the length of a call, but not an event or a task. When a potential progresses from beginning to end it is just a series of tasks/calls/events in a process.  I have most of it automated depending on the type of sale and triggered by updating the sales cycle field. It follows that you should be able monitor the time of each of them so that you actually know how much time you spend on each potential. This gives an idea of profitability of each potential. I would think this
        • Timesheets from Deals

          Hi Guys, new Zoho One customer here with only a few employees. I run a small software company and currently our small number of employees are creating manual timesheets in excel. There is a column for a job number (that relates to a Zoho Deal) and they just put in the time taken to perform the work. As an example, they might spend 1 hour running some barcodes for a particular client (and deal). Then they may do a support all for another client and that takes 2 hours (This client would have a yearly
        • Timesheet option in zoho crm

          Recording a timesheet against a job is very crucial for every business because it will help them in billing the client accordingly and also it keeps a track on how much time a user is exactly taking in marking the job as cloed. Currently in crm there
        • Portal access is now available in the Zoho CRM mobile app

          Hello everyone, Zoho CRM Portals provide a secure space for sharing selected records with people outside your organization. These portal users can include customers, vendors, partners, or anyone who needs access to specific CRM data. Previously, portal
        • Field of Lookup - 5 Field Association Limit.

          This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
        • Zoho Forms API

          Is there any way to get all form entry list using API? Looking forward to hear from you
        • Multiple locations

          I have many customers (accounts) that have multiple locations, like bank branches. How can I manage them under one account?
        • Calendar won't load

          I run into this problem about once a week, where I try to open my Zoho calendar in a web browser, and it just gets stuck, waiting forever to load (see attached screenshot). I'm usually using Edge or Duck-Duck-Go browser. Sometimes it loads just fine,
        • Feature Request: Enhance Zoho Books Customer Approvals with WhatsApp, Multiple Approvers, Automated Reminders, and Workflow Automation

          Product: Zoho Books Module: Time Tracking → Customer Approvals Category: Feature Enhancement / Workflow Automation / Omnichannel Communication Description I would like to suggest several improvements to the Customer Approvals module in Zoho Books, particularly
        • Feature Request: Extend Zoho Books Customer Approvals API and MCP Support

          Product: Zoho Books Category: API Enhancement / OAuth Scopes / MCP Integration Feature: Customer Approvals (Timesheet Approvals) Description I would like to suggest an enhancement to the integration and automation capabilities of Zoho Books, specifically
        • Introducing PRM: Build, manage, and scale your partner ecosystem

          Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
        • Tip: #14 Save words and phrases in Writer for faster writing!

          As you start working with more documents everyday, you'd find yourself using certain words and phrases across documents quite often. In this week's tip, let's discuss two easy ways to train Writer to remember your commonly used words—equipping you to
        • Introducing the Markdown editor in Zoho Learn

          Hello everyone, We're excited to announce the release of the Markdown editor in Zoho Learn. With Markdown editor, you can create and import articles as Markdown. You can write content using simple Markdown syntax and see how it looks with the built-in
        • Zoho ERP | Product updates | October 2026

          Hello users, A new month, a fresh set of updates in Zoho ERP. This month brings Netting, enhancements across our verticals, and more updates to help streamline your everyday work. Explore this month’s updates and see what’s new. Compliance with Revised
        • Zoho Forms - Feature Request - Embed iFrame or Dynaic URLs in Description fields

          Hi Zoho Forms team, I'm working with a client who uses Zoho Forms internally to collect information over the phone from potential work placement candidates. At the end of the form, the candidate needs to be booked in for an induction, which we've configured
        • BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

          As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?
        • Digest Octobre - Un résumé de ce qui s'est passé le mois dernier sur Community

          Bonjour chers utilisateurs, Bienvenue dans ce nouveau digest de la communauté Zoho France ! Vous y trouverez les discussions marquantes, les nouveautés produits, les conseils pratiques partagés et bien sûr les événements à venir. Le mois dernier, nous
        • Bank feeds - still a problem

          I'm really frustrated that the bank feeds only "sometimes" work.  I raised this problem once before and was advised that Zoho used Yodlee and feeds were only updated once a day.  That's fine but it only "sometimes" seems to work.  Eventually transactions appear but they sometimes seem to take days.  I know of other programs (Xero) that another business I am involved with uses Yodlee and they do not have this issue. My bank feeds are active,  I tried to manually refresh however Zoho tells me that
        • this is getting ridiculous

          My checking account bank feeds haven't worked since 6/4/21.  Multiple emails to Zoho since 6/10, and all they tell me is they have re-escalated my problem to their banking service provider team.  14 days and nothing is fixed. I'm just about ready to bail
        • No feedback from Zoho Books regarding Yodlee feeds for Investec

          I reported on 6 Feb 2025 that the Bank Feeds for Investec bank via Yodlee are not working. To date there has been no resolution. You are charging us for a suite of products where the functionality does not work. Please advise how you will refund me for
        • ongoing bank sync problems

          My bank feed broke May 14th 2021 Since then I just get an endless stream of we are working on it, "Kindly bear with us for sometime" from support Multiple times I have asked to speak to managers and half the time they don't call at all. If they do call
        • We must admit - Yodlee is an unreliable partner!

          Hello Zoho, Our Yes Bank account intergration is messed up since the beginning and the problem has not been addressed yet. With bad synchronization, poor categorization of transactions, duplicate/unknown copies of accounts, no support, geared at income/expenses,
        • Make your PDFs clearer with shapes

          Sometimes the best way to mark up a PDF is to point at it directly. Zoho PDF Editor includes shape tools that let you add circle, check and cross marks anywhere in your PDF, so you can flag content for review without extra comments. Here's what you can
        • Admin Logging in as another User

          How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Latest Update (27th April 2026): With the early
        • Project Migration

          We currently have two separate Zoho organizations: A Spark Robotic organization under Zoho CRM Plus A separate Contract Manufacturing organization under Zoho One We are working with Zoho Support to consolidate the CRM Plus organization into our existing
        • CNIL - Suivi de Pixel

          Bonjour à tous, À la suite de la nouvelle recommandation de la CNIL sur les pixels de suivi dans les e-mails, savez-vous si Zoho Campaigns permet : de conditionner le suivi des ouvertures au consentement de chaque contact ; de proposer un lien permettant
        • Live connection to DS files in Zoho Creator / ChatGPT

          As an idea, we are using ChatGPT to build with Zoho Creator (outside of Zia), which is works brilliantly to assist write deluge, provide test suggesitons etc. Currently we are uploading the DS files which are very point in time, it would be great to have
        • Improved Filtering and Tagging options for Notes

          We rely on the notes section across several modules and would love to have some more options in filtering, grouping, and tagging notes. We would like to be able to filter notes differently on a contact or deal and have that choice stay on that record
        • Action required: Update the Zoho Desk Client SDK URL in your extensions

          Hi Developers, To improve reliability and performance, the Zoho Desk Client SDK is now served from a new CDN domain. We request that you update your existing extensions with the new Client SDK URL given below. Note: Going forward, all newly created extensions
        • Decoupling Email Sending from Storage in CRM & Email Storage Add-on Purchases

          Hello everyone, We are excited to announce the rollout of the second phase of our email storage management, designed around a simple principle: your business communication should never be disrupted by storage limits. We've decoupled email sending from
        • Enhancement Request: Preserve Canceled Zoho Bookings Meetings in CRM

          I recently worked with Zoho Support on ticket 170383788 regarding what happens in Zoho CRM when an appointment is canceled in Zoho Bookings. Support confirmed that the current behavior is intentional: when a Bookings appointment is canceled, the corresponding
        • Edit PDFs using Zoho PDF Editor

          Hello users, In a previous article, we covered the organizing capabilities of Zoho PDF Editor. Here, we'll provide a quick recap of its editing features, including a few new additions. A few highlights of Zoho PDF Editor's editing capabilities: Add and
        • Next Page