Tip #33: Maintain uniform data in all your applications using Server Scripts in Qntrl

Tip #33: Maintain uniform data in all your applications using Server Scripts in Qntrl



Server scripts in Qntrl provide command to customers to code their own scripts that run on their databases or servers, executing business operations and transferring data to and from Qntrl. It helps develop company-specific business logic to manage databases, validate Qntrl’s data with server-side data, integrate with third-party applications, and automate activities in business workflows.
 
Let us understand server scripts better using a business case.
 
Business Case
Zylker Corp, an IT company, maintains an external database server that holds all their client data. Every time a client request is filed in Qntrl, Zylker wants the client details to be auto-fetched from the database. Also, when a client request is completed, a new invoice has to be raised in a third-party invoice application using the details available in Qntrl.
 
Solution
Zylker's requirement can be solved by coding 2 different server scripts:
  1. Develop a script for fetching and validating data from a third-party server. Refer the sample script.
  2. Develop a script for transferring data to third-party applications. Refer the sample script.
 
This helps you avoid data clashes between different applications and maintain one central server. Server scripts also ensure complete data security and privacy as customer data is stored only in their servers and not in Qntrl.
 
We’ve documented a detailed guide solving some real-time business cases for you.
 
We hope these scripts are helpful to you. In case you have any special requirements about server scripts, leave a comment below or email us at support@qntrl.com.

      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

          • Tip #21: Increase user engagement using dynamic email content and attachments in Orchestly

            Businesses often send out bulk emails like weekly newsletters, monthly event updates, promotional emails, surveys, beta access emails, product reviews, seasonal greetings, and so on. Even as the gist of these emails remain constant for all recipients, personalizations capture the audience’s attention and help brands connect with them.   Orchestly’s email templates allows you to draft and send dynamic emails with personalized content and attachments to internal and external users. Email templates
          • Qntrl's 2023 year in review

            This year has been all about analyzing our customer feedback and building a resilient and solution-driven product from it. As a result of this work, we're happy to announce that a whole new version of Qntrl is getting ready for release soon. This new
          • Tip #61: 5 different ways to create Cards in Qntrl

            Qntrl supports an array of features that covers everything required for business orchestration, from process automation to business advancement. Cards, being the elemental feature of Qntrl, record all the details of a particular task from the beginning
          • Tip #17: Stay informed of significant business impact using Orchestly

            With remote working becoming the new norm, leaders across sectors need to stay updated of their business performance in the market to aid business decisions. Instead of awaiting virtual meetings from sales and finance heads to put forth the business status, organization leaders can themselves dig into the system to keep an eye on their revenue generating customers or set up notifications to monitor major updates.   Orchestly recognizes such requirements and provides adaptable solutions for all business
          • Onboard faster with Orchestly's Tutorials

            We are actively rolling out new learning materials to assist our customers onboard at ease and automate their processes effortlessly. On that front, we recently launched Tutorials for Orchestly.   Tutorial is a step-by-step guide to help users familiarize the concepts of Orchestly and automate simple processes right from scratch. We’ve documented 3 such business processes viz. Order Manufacturing, Product Implementation, and Change Management.   We're looking forward to document more customer-centric

          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

                                  • Sending merged mail templates for signatures fail since today

                                    We have ZOHO one, we use merge templates in CRM to edit in ZOHO Writer, and from there send it for signature through zoho sign. This all worked up until today, suddenly we read in the log that the merge is succesfull but the sending for signature failed.
                                  • Feature Request - Make Lead List Larger and Adjustable

                                    Hi LandingPage team, I recently started using LandingPage and I am happy to share my feedback to help improve the app. I've noticed on the Leads page, there is no option to make the columns wider. It would be great if the comlumns expanded to fit the
                                  • Zoho Projects - Pin Recent Projects

                                    Hi Projects Team, It would be great if I could "pin" projects on the Recent Projects list in Zoho Projects. We have some internal projects which we regularly have to add time and some regular client projects. It would be great if I could pin those projects
                                  • ZDK Error

                                    I get this error when trying to trigger a CRM Function from Client Script: Uncaught (in promise) ZDKError: {"code":"NOT_ACTIVE","details":{"api_name":"activate_client_from_prospect"},"message":"api is inactive for the given custom function","status":"error"}
                                  • "Disbursing product components in phases, monitoring them, and displaying only the final product."

                                    i have a product composed of multiple components, and these components will be delivered to the customer in batches. However, the final invoice should only show the finished product. How can I issue (or release) the components and track their delive
                                  • Followed Subtasks doesn't show up in the Subtasks Section

                                    I have a task assigned to me now in the same task, there's a subtask and I am added as the follower on that task Even though I am a follower I still don't see that in the subtasks section The view permission for the profile is Related It's supposed to
                                  • Tip #39- Strengthen account security with Multi-factor Authentication (MFA) – ‘Insider Insights’

                                    Securing your organization's data begins with verifying that only the correct individuals have access to it. One of the simplest yet most effective ways to accomplish this is to enable Multi-factor Authentication (MFA) within Zoho Assist. MFA introduces
                                  • Automate timeout chat tracking with Workflows in SalesIQ

                                    With our feature-packed Nova release, Workflows has become one of the most powerful tools in Zoho SalesIQ. They let you automate follow-up actions when key events occur, such as when a chat ends, a visitor leaves a bad/good rating, or a lead is updated.
                                  • Mass edit / Mass update products

                                    Hi, Is there any way to mass update or bulk edit product fields in Zoho Inventory?
                                  • Automatic Verification of IMAP Integration Status

                                    Our sales staff have their O365 email integrated with CRM, over time this integration requires re-authentication via the UI. I can manually check the integration status by accessing Settings -> Channels -> Email -> Email Sharing -> "Configuration Type"
                                  • Tip of the Week #68– Share and access files faster with Zoho WorkDrive extension.

                                    Have you ever wasted time searching for the right file to attach to your emails—or worried whether the right people could access it? Without proper sharing settings, files might end up inaccessible to teammates or, worse, visible to people who shouldn’t
                                  • CV-Library: The Newest Source Booster in Zoho Recruit!

                                    We’ve expanded your sourcing toolkit — CV-Library, one of the UK’s largest and most trusted online job boards, is now available as a Source Booster in Zoho Recruit. This gives recruiters instant access to millions of UK-based candidate profiles, all without
                                  • Zoho AI Translate Task as Rest API

                                    I cant find any docs on how to use Zoho AI Translate Task from a rest api call https://www.zoho.com/deluge/help/ai-tasks/translate.html I am working on a custom Widget and I dont think I can execute zoho deluge ai translate task from a custom widget.
                                  • Is there the possibility to book less than 250 customer portal users?

                                    If you use the Creator, which is included in Zoho ONe, you can create a customer portal and give access to a maximum of 3 external people / customers, right? On the Creator website I saw that you can add 250 users for 100€/month. However, we don't need
                                  • Display Parts custom fields in the Work Order

                                    Hello, I see that is it possible to add custom fields in the Parts module. Would it be possible to also add those custom fields in the Work Order Module under Parts? This would be very useful for customer who want to showcase more information about parts.
                                  • Unable to edit Saved Estimates

                                    We are facing issue with editing the price or discount for a saved estimate for nearly 1 week.
                                  • Translation Blueprint & Picklists with Custom Values

                                    Hello everyone, I downloaded the translation file and I'm not finding the blueprint transitions. Does this means that the transitions cannot be translated? Also, the picklist values to be translated in the document are not the same that are actually used the in module. For exemple, for my lead module, the picklist values for Lead Status are : Not-contacted, contacted, junk and lost lead. In the translation document (English to French), this is what I see: PicklistValues.Leads.Lead_Status.Contact
                                  • How to create a custom sales signal?

                                    I want to create a custom sales signal for a custom module. is it possible to create one? If anyone know please let me know
                                  • Multi-line address lines

                                    How can I enter and migrate the following 123 state street Suite 2 Into a contact address. For Salesforce imports, a CR between the information works. The ZOHO migration tool just ignores it. Plus, I can't seem to even enter it on the standard entry screen.
                                  • Only show products in offers based on lead source

                                    We work with several lead sources, each with their own products and different pricing. For example, one product might have two or three different prices. Sometimes, when creating a quote, the wrong product is accidentally selected. Is there a way to only
                                  • Narrative 7 - The importance of data sharing

                                    Behind the scenes of a successful ticketing system - BTS Series Narrative 7 - The importance of data sharing Definition Data sharing requires a commitment to preserving the integrity and dependability of shared data throughout its entire lifecycle. This
                                  • TrueSync regularly filling up my local disk

                                    Seems that WorkDrive's TrueSync randomly starts filling up my local hard drive space. None of the folders have been set as "Make Offline" but still it seems to randomly start making file offline. The settings of the app is so minimal and is of no real
                                  • How can you re-push non failed submission through the integrations again?

                                    Hi, I can see there is an option the 'Re-push' failed integration submissions from Zoho Forms. Is there a way to do this for all submissions? We've just re-built an integration so things go into different fields and we would like to re-push everything
                                  • Check out in Meetings

                                    Why there is no check out in Meetings of Zoho CRM, very difficult to track
                                  • Issue with Zoho Projet

                                    Zoho Project on all the cellphones of my customer is crashing. He has mixed brands (Samsung and Pixel). Everything is fine on website and mobile website. Could not reproduce the issue in workshop using Samsung/Pixel/iPhone Uninstallation of Zoho Project
                                  • SecurePass email English language issue -- please hire someone to correct the English language issues sprinkled throughout your interface

                                    I wrote previously about some incorrect English in your SecurePass offering. After about six months it was corrected. I have never revoked permission before today and just discovered another language mistake that was not corrected. When you revoke a SecurePass
                                  • Published Components

                                    @zoho team, Checking if we can add a password for the public links as we have non-licensed users
                                  • Zoho Creator customer portal users

                                    Hi, I'm in a Zoho One subscription with our company. I'm running a project now that involves creating a Zoho Creater application and using the Zoho Creator Customer Portal.  At most we need 25 customer portal users. In our Zoho One plan we only get 3
                                  • Please Enable Snippets for Agents Adding Comments

                                    Snippets and templates are currently enabled for agents when they use the reply functionality. There is currently no way to add a template or snippets when an agent comments. This is really weird. Our agents don't use the reply functionality, only the
                                  • Tip of the Week - Extracting Data from JSON Columns

                                    Let's say you are importing a CSV or Excel file into Zoho Analytics. What if the file contains a few columns in JSON format? This is where Zoho DataPrep, embedded right within Zoho Analytics, comes in handy. This week's tip explains how to extract data
                                  • Deluge UI Updates

                                    Are there any updates planned for the Deluge UI in Zoho Desk? It feels quite dated and lack-lustre after you've spent some time in the CRM Deluge UI.
                                  • Zia Agents - Follow Ups

                                    It would be nice to have Zia Agents do follow ups. A lot of times agents are trying to schedule things with users and they say "can we set your printer up tomorrow?" and the user never says anything. A way to have a personalized reminder to the user automatically
                                  • Hide Agents name in Ticket Responses in "My Area"

                                    We were able to hide the agents name in the emails, however, the customer is able to see which agent has responded to a ticket in the thread of emails by going into their Help Center thread. Is there any way we can hide that information?
                                  • Option to Automatically Update Extensions

                                    Hello Zoho Desk Team, We recently received an email notifying us about an extension update that must be done manually. We’d like to request a feature that allows extensions to be updated automatically without requiring manual intervention. This would
                                  • Copy / Duplicate Workflow

                                    I have workflows setup that are very similar to each other. We have a monitoring system watching servers, and all notifications - no matter what client it is about - will come from a  noreply@ address which is not very helpful in having it auto assigned to the right account. I have setup a workflow that will change the contact name of the ticket (currently it would say noreply@) to the correct customer which is based on the subject line, as that mentions which server the alert it is about. I need
                                  • Embed Report with Auto Height

                                    Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditions
                                  • Zoho Payroll: Product Updates - August 2025

                                    This month’s updates to Zoho Payroll bring enhanced efficiency and smarter features, simplifying payroll management for users in India, UAE, KSA, and US. Read on to explore how these updates can streamline your workflow. Filter Pay Runs by Type (India,
                                  • Numerical Rating for Interviewer Assessments

                                    Introducing Numerical Rating, a powerful new addition to interviewer assessments that brings precision and flexibility to candidate evaluations. ✅ What is Numerical Rating? Numerical Rating lets interviewers assign a score for each question in the assessment,
                                  • Choosing a portal option and the "Unified customer portal"?

                                    I am trialling Zoho to replace various existing systems, one of which is a customer portal. Our portal allows clients to add and edit bookings, complete forms, manage their subscriptions and edit some CRM info. I am trying to understand how I might best
                                  • User Tips: Adding Multiple Products (Package) to a Quote v2.0 (with Client Script)

                                    This solution is an improvement on the original idea which used deluge. My solution was posted in the comments are: https://help.zoho.com/portal/en/community/topic/adding-multiple-products-package-to-a-quote The updated version uses client script instead
                                  • Next Page