Business case 1: Populate read recipients list for a card using Server Scripts (On Load)
Managers find it useful to know which employees have viewed a new card or comment, like a read receipts list. It helps managers know if an employee has viewed his assigned task and evaluate how informed employees are about new updates in the organization. To customize such requirements in Qntrl, server scripts can be used.
Business Scenario
Zylker Corp is making arrangements for a product launch and all the employees are roped in for the process. Every employee is assigned tasks to complete. The managers of the company want to monitor the employees who are actively involved in the launch and keep track of the card.
Solution
The requirement can be solved using server scripts as follows:
-
Create a multi select field--
Read Recipients
--in the form with different user names as options.
-
Create a server script and code the logic to populate users in the Read Recipients field when users open the card.
-
Create a card and add the work that has to be taken up for the product launch and track the users who have viewed the card using the Read Recipients field.
Sample Configuration
Step 1: Create an orchestration
Create a new
orchestration
for the product launch and add related fields to it.
-
Add a
multi select field
and name it
Read Recipients.
-
Add user names as options to the multi select field.
-
Turn off the visibility so that the field is hidden while creating a card.
Once the form is saved, proceed to design the blueprint, set permissions, and publish the orchestration.
Step 2: Code server scripts
Code the server script to populate user names in the Read Recipients field when they open the card.
-
Create a new server script and enter a name: 'Populate read recipients list'.
-
Choose
Product Launch
in the
Form
dropdown.
-
Choose
Job
as the
Execution Location
to execute the script.
-
Choose
On Load
as the
Execution Trigger
to execute this script whenever the card page loads.
-
Copy and paste the below script into your script editor and replace the parameter names.
-
You can use the ? icon at the top-right corner of the script editor to refer to parameter names.
-
Once the script is ready,
Publish
it.
- function onLoad(){
- var userIdPicklistIdMap = {};
- userIdPicklistIdMap["<User_ID>"] = "<Picklist ID>";
- userIdPicklistIdMap["<User_ID>"] = "<Picklist ID>";
- userIdPicklistIdMap["<User_ID>"] = "<Picklist ID>";
- userIdPicklistIdMap["<User_ID>"] = "<Picklist ID>";
- userIdPicklistIdMap["<User_ID>"] = "<Picklist ID>";
- //Get User ID from our API doc: Get all users
- //Get Dropdown ID from our API doc: Get all custom fields
- var myPickId = userIdPicklistIdMap[current.User.getId()];
- if (!myPickId) {
- console.log("Current user not available in Read Recipients dropdown");
- return;
- }
- var readRecipients = current.Job.getVariable("Read Recipients");
- if (!readRecipients) {
- readRecipients = "";
- }
- console.log("Read recipients = " + readRecipients);
- var splitByComma = readRecipients.split(",");
- if (!splitByComma[0]) {
- splitByComma.shift();
- }
- if (splitByComma.indexOf(myPickId) == -1) {
- splitByComma.push(myPickId);
- }
- console.log("result = " + splitByComma.join(","));
- current.Job.setVariable("Read Recipients", splitByComma.join(","));
- //Select Read Recipients parameter here
- current.Job.setValue(current.Layout.Fields.<select-Read-Recipients-parameter-here>.id ,splitByComma.join(","));
- console.log("Read Recipients updated");
- }
Step 3: Add card
When the orchestration and server script are ready, we can test the script by creating a new card.
-
Navigate to
Cards
and click
Add Card.
-
Select
Product Launch
from the Form dropdown.
- Enter the card details and Save.
Once the users start viewing the card details page, their names will start getting populated in the
Read Recipients
field.
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Business case 3: Validate new data entered in cards using Server Scripts (Before Update)
Performing operations and coordinating with teams can be quite a herculean task. If the information given in the card details is changed to corrupt information later, it may create chaos and slow down task completion. This is why if a user is to make ...Business case 2: Fetch data from third party websites using Server Scripts (Before Create)
We might sometimes want to fetch external data from other applications or websites like weather details, stock rates, or flight status related to the card, when we create a card. Server scripts can be used to fetch such data and display it in Qntrl. ...Business case 4: Set conditions for users to delete cards using Server Scripts (Before Delete)
Organizations provide permissions and privileges to various sections of staff according to their roles and profiles. In order to make sure that the data within Qntrl can only be deleted by the right personnel, organizations can implement complex ...Business case 6: Delete associated cards from third-party applications (After Delete)
Automate deleting records in third party applications, such as Zoho Desk or SAP, once they are deleted in Qntrl using the 'After Delete' server script. Business Scenario Zylker uses Jira to track issues in their products and every bug filed in ...Business case 2: Use client scripts to auto-populate fields based on user input
While designing forms, we would sometimes require to display different sets of fields for different user responses. Such automatic field population can be handled using client scripts. Business Scenario Helen creates a sign-up form for her product ...
New to Zoho LandingPage?
Zoho LandingPage Resources