Custom Function: Computing_Field_Values | Online Help | Qntrl

Custom Function: Computing_Field_Values

  • This custom function can be used to add two values and save the return value in a custom field. 

  • The sum will be dynamically updated in the custom field after this function is executed. 

Business Scenario

Helen is the head of Procurement Management at her organization. Once the individual purchase cost of all the materials is approved by Helen, the total cost can be calculated and saved by executing this function. 

Steps to configure the custom function

Before executing this custom function, you will have to configure the arguments, add custom field values (if required), and authorizate connections. Follow the below steps to configure the function. 

1. Configure the Arguments 


First, configure  Argument Values for all the parameters used in the custom function. You can either specify the Custom Value or choose a Form Field from the dropdown. Form fields capture dynamic values from card fields corresponding to the custom function.     

 

  • orgName : Specify your organization’s name. This will be available in Qntrl’s URL ( core.qntrl.com/blueprint / <orgName>/<module>). 

  • param1 : Either enter a value here or map a custom field. 

  • param2 : Either enter a value here or map a custom field. 

  • jobID : Choose the  Card ID  Form Field here. You can also specify the ID of the card. This will be available in the Card URL ( core.qntrl.com/blueprint/ <org-name>/<job>/<jobID>).


2. Add custom field values


To provide values for custom fields in the card, add the below syntax to the function.  This is optional and can be included only if there is a need to provide values to the custom fields. 
Syntax:
paramMap.put("column_name of the custom field","value of the custom field");


The 'column_name of custom field' can be obtained using APIs:
    1.   Click the hyperlink to visit our  API Documentation
    2.   Navigate to the  Reference tab and select  Forms  on the left panel. 
    3.   Execute the  Get form details  function by clicking  Try Now
    4.   Choose your organization and configure the URL by entering the Form ID. This will be available in the Form URL ( core.qntrl.com/blueprint /<org-name>/<layout>/<formID>). 
    5.   Click  Execute
    6.   Press Ctrl+F on your keyboard and search for your custom field name. You can find it listed as an alias_name. 
    7.   Find the column_name linked to this custom field. It will be listed just above the alias_name. 


The column_name can be used in the syntax specified above to add custom field values.



3. Provide authorization using Connections


Connections helps you authenticate the API call for specific scopes of  Qntrl  and other internal Zoho applications used in the custom function. 
    1.   Invoke Connections to authorize your Qntrl account. 
    • Click  +Connections button in  Custom Functions . A new tab will open in your browser. 

    • Click  Add Connection in the top-right corner.

    • Choose  Zoho Oauth on the  Pick Your Service tab.

    • Enter a  Connection Name and choose the 'Orchestly.job.ALL' scope to connect. 

    2.   After successful authentication, include the connection details in the invokeurl block of the custom function.  

      e.g: connection: "<Connection-name>"


Once the above steps are configured, you are all set to execute the custom function. 



Computing_Field_Values  is a part of Qntrl's pre-define custom functions available in Function Gallery. However, you can also write your own  custom functions  in Qntrl. 

    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 Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            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

                                                                                                              • Custom Function: Create_Job

                                                                                                                This custom function can be used to create a new card in any orchestration. It can also be configured to carry forward necessary field values from the former card to the latter.   Business Scenario Helen is the head of Procurement Management in her ...
                                                                                                              • Custom Function: Create_Ticket_in_Zoho_Desk

                                                                                                                Zoho Desk is customer service software which allows you to address customer concerns. This custom function can be used to post a card as a ticket in Zoho Desk.  Prerequisites  Sign up for Zoho Desk and create a department. The ticket will be created ...
                                                                                                              • Custom Function: Post_and_Update_Comments_in_Zoho_Desk

                                                                                                                Zoho Desk is a customer service software which allows you to address customer concerns. This custom function can be used to add or update comments in Zoho Desk whenever they are added or updated in Qntrl.  The comments will be added to the tickets ...
                                                                                                              • Custom Function: Move_Job_to_other_Blueprint

                                                                                                                This custom function can be used to move a card to any blueprint created using the same orchestration, automatically.  Business Scenario In a food processing business, once the food items are packed and ready to be shipped in the Manufacturing ...
                                                                                                              • Custom Function: Move_Job_to_other_Stage

                                                                                                                This custom function can be used to move a card to any stage in the blueprint automatically. Cards can be moved to previous stages or upcoming stages.  Business Scenario Mark, the head of Marketing, reviews all the marketing articles in his ...
                                                                                                                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