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 or navigate to Connections under Advanced.
Click Create 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.