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.





      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ





                                ご検討中の方

                                  • Recent Topics

                                  • Client Script | Update - Client Script Support For Custom Buttons

                                    Hello everyone! We are excited to announce one of the most requested features - Client Script support for Custom Buttons. This enhancement lets you run custom logic on button actions, giving you greater flexibility and control over your user interactions.
                                  • Save embed widget personalizations

                                    Ok, Zoho, Great work on providing PRICING TABLES via the embed widget. Thanks so much. This changed the game for me Only one slight problem....I can't seem to save my widget settings. I'm still building my products and plans but I'm testing how they look
                                  • Problem with UTM Parameters: Zoho Forms - Zoho Desk Integration

                                    Hi Zoho Support Team, I want to automatically capture UTM Parameters from my website URLs and pass it from Zoho Forms into Zoho Desk. I have activated the UTM tracking feature. I've integrated the UTM Tracking code in my website footer on all pages. I've
                                  • Team folder not created when creating project using zoho flow

                                    When I try to automate project creation using zoho flow, and I have enabled workdrive integration to automatically create team folders to attach to the project, this only works when I create a new project through the UI. But I am trying to automate project
                                  • Zoho CRM upload files error

                                    Since today, we have been experiencing issues with uploading photos to opportunities. The message indicates that the storage is full, but as far as I can see, there is still plenty of space available. Could there be an issue or a bug?
                                  • Add an option to deactivate Zoho Meeting "Welcome" message

                                    My request is to provide an option to deactivate the annoying Zoho Meeting "Welcome" voice when participants join meetings... or remove it all together. First impressions count, especially with new clients. This notification reminds me of the AOL "You've
                                  • Turning off the recorded welcome in Zoho Webinar

                                    Is there a way to turn off the recorded voice that comes up at the beginning of every webinar session? It devalues the experience for attendees from feedback, interrupting their connection with our brand and delaying webinar start unnecessarily.
                                  • Service line items

                                    Hello Latha, Could you please let me know the maximum number of service line items that can be added to a single work order? Thanks, Chethiya.
                                  • SalesIQ > My Chat sort by Unread or Follow-up

                                    Hi Zoho SalesIQ Team, I would like to submit a feature request regarding the My Chat > Sorting in the SalesIQ UnRead Follow-up Conversation tags Thank you for considering. Best regards, CJ
                                  • Record sharing for Activities modules in CRM

                                    Hello everyone, We've got a few quick enhancements to what we covered in this previous announcement: record sharing is now available for Activities modules. 1. Sharing Tasks, Meetings, and Calls Until now, activity records could only be shared indirectly
                                  • SalesIQ : How to disable "Idle chat handling" ?

                                    Hello SalesIQ Team. SalesIQ, How to disable "Idle chat handling" ? I would like to disable the option “Automatically close chats that have been idle for a specified amount of time.”
                                  • How do I create an update to the Cost Price from landed costs?

                                    Hi fellow Zoho Inventory battlers, I am new to Zoho inventory and was completely baffled to find that the cost price of products does not update when a new purchase order is received. The cost price is just made up numbers I start with when the product
                                  • Function and workflow to create customer payment and send receipt

                                     I am attempting to set up a workflow/custom function for the automatic creation of a customer payment and sending the email receipt, but am receiving the error "Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" I've been over everything several times and cannot see where the error is (code is copied into the attached document).  I haven't used custom functions before with Deluge, so it's very likely something very simple, or I've completely mucked
                                  • Smart Alerts: Protect users with configurable email alerts

                                    Email-based threats are becoming harder to identify and manage. Administrators need proactive ways to protect users from phishing, fraud, and policy violations. Standard filters can block emails, but blocking alone isn't always the most effective response.
                                  • Facturation électronique 2026 - obligation dès le 1er septembre 2026

                                    Bonjour, Je me permets de réagir à divers posts publiés ici et là concernant le projet de E-Invoicing, dans le cadre de la facturation électronique prévue très prochainement. Dans le cadre du passage à la facturation électronique pour les entreprises,
                                  • Ticket Status

                                    HI, Any idea on how to create other options for this header??? I want to add an "Ordered" status. Its under "tickets" in Overview, I need a new status created (see second picture)
                                  • Power up Zoho CRM with project intelligence

                                    Dear user, You're probably one of those businesses using your CRM as a single source of truth. It's where sales, project execution, and finance teams go to analyze past decisions and formulate future strategies. But what happens when project data is either
                                  • Print multiple uploaded images in an HTML snippet in a Page

                                    I have a Form: Job_Preparation It stores details of each new item that must be built by the fabricators in our workshop. The form has a field: Documents I upload 4 image files to the Documents field. I want to print a sheet for our workshop staff with
                                  • "Track Inventory for this item" is forced checked by default for goods items (eTims issue?)

                                    Hello, Since connecting our Zoho books to eTims (Kenya) the "Track Inventory for this item" is forced checked by default (eTims issue?) in the Item creation page for any type of goods. So when purchasing anything that the company does not intend to sale,
                                  • Its 2022, can our customers log into CRM on their mobiles? Zoho Response: Maybe Later

                                    I am a long time Zoho CRM user. I have just started using the client portal feature. On the plus side I have found it very fast and very easy (for someone used to the CRM config) to set up a subset of module views that make a potentially extremely useful
                                  • Why can't we choose Fixed Asset account for Purchased Items? (eTims issue?)

                                    Hello, When the company purchase items not for sale and not supposed to be in the inventory stock, like equipment for operational use, there is no way to access the Fixed Asset accounts in the drop down list. Is that an eTims limitation again? Or something
                                  • Zoho Team Inbox - roadmap

                                    Hi, would be good to understand the Teaminbox roadmap, in particular: 1. API / Zoho Deluge connections. We have a process where the each email needs to be either tagged or assigned daily. It would be great if we could automate a 5pm alert for any exemptions
                                  • SalesIQ Integration with LINE: API Rate Limit Issue and Pre-Chat Flow Concerns

                                    Hello SalesIQ Developer Team. I have investigated the issue and found that the LINE Rate Limit is being consumed unusually quickly. LINE API free usage limit: 300 messages per month per band. This limit will be reached within the first few days. 1. LINE
                                  • Free webinar! Sign documents across borders: AES, QES, ID verification

                                    Hello all, Signing paperwork across geographies sounds simple, until critical questions around legality, security, and compliance pop up. Join our upcoming webinar to see how Zoho Sign helps businesses worldwide sign documents with confidence. Agenda:
                                  • Blueprint Not Triggering When Lead Status Is Updated by Workflow (IndiaMART Integration)

                                    I have set up a blueprint that triggers when a lead’s status is “New Lead.” Our CRM is integrated with IndiaMART, and when leads are created from IndiaMART, their Lead Status is initially set to None. To handle this, I created a workflow that automatically
                                  • Add field "Expected Availability Date" to Purchase Orders

                                    Hi there. We drop ship and 'make to order' whereby we backorder sales order items directly with factories for manufacturing. One of the leading questions from Customers is "when is the order ready". Currently there is an 'Expected Delivery Date', which
                                  • Related list view for Assets

                                    We first set up all our parent assets in FSM and now we are adding child assets which are the parts for the parent assets. When under the customer related list, since it only displays 5 rows of data, I have to click through many assets to locate the parent
                                  • How To Invoice Immediately for Future Subscription

                                    Hi, When a new subscription is created that has a future start date, Zoho Subscriptions does not invoice the customer until the start date of the subscription. Is there a way to immediately invoice the customer as soon as the subscription is created,
                                  • Problem with the blueprint flow.

                                    Scenario: 3 departments in a single environment: A-B-C agents from department 1 D-E-F agents from department 2 G-H agents from department 3 Since we've been using Zohodesk (2023), agents can assign tickets to the correct department using the blueprint
                                  • Create Tasklist with Tasklist Template using API v3

                                    In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to
                                  • Spell Check Red Underlines Keep Appearing Even After Disabling

                                    Hello Zoho Support, I'm facing an issue in Zoho Writer where red spell-check underlines keep appearing even after I disable Spell Check. I have already: Turned OFF Spelling Errors Turned OFF Grammar Turned OFF Writing Quality Turned OFF browser spell
                                  • Add multiple users to a task

                                    When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman
                                  • iOS Books app shows filtered view after changing to All sales orders

                                    My boss often checks sales orders on his iPhone. The app is mostly working fine, but there's an ongoing issue: When switching between different filters (also called custom views on the web), going back to All doesn't often work. It typically gets stuck
                                  • Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

                                    Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
                                  • Recurring Invoices

                                    I'm looking to set up recurring invoices on a monthly basis, using GoCardless as a payment gateway. I've done this successfully, however there's a big problem with the Invoice Date and Due Date. We prefer to provide sufficient notice of collection (10
                                  • Recurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps

                                    We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurring
                                  • Vorrei disdire l'abbonamento

                                    Vorrei disdire l'abbonamento, ma non trovo il modo. Mi assistete?
                                  • Has anyone successfully gotten conditional rendering to work in Zoho Books Sales Order HTML PDF templates?

                                    I’m trying to hide a custom field box when the custom field is blank. The value placeholder itself works perfectly: ${salesorder.cf_distribution_reference_numb} If the Sales Order has a value, it renders correctly. Example: 45488045. But when I wrap that
                                  • What's New in Zoho Inventory | April & May 2026

                                    Hello users, We're excited to roll out the latest Zoho Inventory updates for April and May 2026. These enhancements are designed to make your daily operations smoother and more efficient, from advanced inventory management and flexible pricing to automated
                                  • Latest updates to Zia in Office Integrator

                                    Hello Zoho Office Integrator users! We’re pleased to share exciting updates to the proofing capabilities of Zia, our AI-driven writing assistant, in Office Integrator. With these updates, you can now get spell and grammar check in Brazilian Portuguese,
                                  • Next Page