Kaizen #154 - Dynamically Update Picklist Values in Zoho CRM Workflows

Hello all!

Welcome back to another interesting Kaizen post.

Today, we will discuss how to add automatically or remove values from a picklist field using Deluge within a workflow. This post serves as a solution for the forum post.

Use case

The sales team migrates users from Pipedrive to Zoho CRM. In Pipedrive, the team managed deals using a Kanban view displayed based on the Closing Months (a picklist field). They automated the updating of picklist values to include current and upcoming months based on the deals' closing timelines. 

In Zoho CRM, to replicate this process, users should manually update the picklist values. The requirement is to automate updating the picklist options during record creation or editing within a workflow.

Solution

By triggering the PATCH Fields API (introduced in V6) through a Deluge function within a workflow, this process can be easily automated. Automating picklist updates saves time, reduces the chances of human error, and ensures that picklist values are always up-to-date.

• First, create a custom picklist field called "Closing Month" in the Deals module.
• Then, use the custom picklist along with the Closing Date (a mandatory field date field in the Deals module) within a Deluge function in the Workflow. 
• The PATCH Fields API can be used within the Deluge function to automate updating picklist values and to list the current and upcoming closing dates in deals.

Let us see the steps in detail on how to achieve this case.

Example

Consider the Closing Month as a custom picklist in the Deals module with three months: January, February, and March. Whenever a new deal is created and its closing month matches one of the picklist values, the record will be updated with the corresponding month in the Closing Month field and placed under the existing picklist value in the Kanban view. If the new closing month is not already in the picklist values, then the Deluge function will automatically create a new picklist value, and the record will fall under the new picklist value section in the Kanban view. 

Follow the steps below to achieve our case in Zoho CRM:

1. Create a Custom Picklist Field in the Deals module.
2. Set Up a Workflow.
3. Add a Deluge Function within a workflow.
4. Configure the Workflow.
   

1. Create a Custom Picklist Field in the Deals Module

• Go to Setup > Customization > Modules and Fields.
• Select the Deals module and the desired layout where you want to add the picklist.
• Click on New Fields and then Add New Field.
• Select Picklist as the field type, name it "Closing Month", and add a list of months (In this post, only three months have been added for example purposes).
  

                                  

• Click Done to save the new picklist field.

2. Set Up a Workflow

• Navigate to Setup > Automation > Workflow Rules.
• Click on Create Rule, select the Deals module, and name the workflow in the Rule Name.
• Set the rule to trigger on record creation or update.

                               

The workflow triggers based on the value of the Closing Date in the Deals module, executing the function when the Closing Date is not empty.

3. Add a Deluge Function within a workflow

You can either create a custom function or you can associate an existing one. Below is the Deluge code used within the workflow. 

1. //To map months with Numbers
2. month = {1:"Jan",2:"Feb",3:"Mar",4:"Apr",5:"May",6:"June",7:"Jul",8:"Aug",9:"Sep",10:"Oct",11:"Nov",12:"Dec"};
3. //To retrieve the Deal record
4. dealRecord = zoho.crm.getRecordById("Deals",dealRecordID);
5. info dealRecord;
6. //To retrieve the Closing Date
7. closingDate = dealRecord.get("Closing_Date");
8. info closingDate; 
9. //To get the predefined value from the closing month
10. closingMonth = month.get(closingDate.month());
11. closingYear = closingDate.year();
12. //To Format the Month and Year from the Closing Date
13. picklistValue = closingMonth + " " + closingYear;
14. info picklistValue;
15. //Retrieving Current Picklist Values
16. Dealsfield = invokeurl
17. [
18. url :"https://www.zohoapis.com/crm/v7/settings/fields/5725767000003664513?module=deals"
19. type :GET
20. connection:"zohocrm"
21. ];
22. info Dealsfield;
23. picklistValues = Dealsfield.get("fields").get(0).get("pick_list_values");
24. info picklistValues;
25. //Checking if the Picklist Value Already Exists
26. flag = false;
27. for each  option in picklistValues
28. {
29. if(option.get("display_value").equals(picklistValue))
30. {
31.   flag = true;
32.   info flag;
33. }
34. }
35. //Adding a New Picklist Value if It Doesn't Exist
36. if(flag == false)
37. {
38. requestBody = Map();
39. requestList = List();
40. requestData = Map();
41. picklist = list();
42. picklistobj = Map();
43. picklistobj.put("display_value",picklistValue);
44. picklist.add(picklistobj);
45. requestData.put("pick_list_values",picklist);
46. requestList.add(requestData);
47. requestBody.put("fields",requestList);
48. info requestBody + "";
49. updateField = invokeurl
50. [
51.   url :"https://www.zohoapis.com/crm/v7/settings/fields/5725767000003664513?module=deals"
52.   type :PATCH
53.   parameters:requestBody + ""
54.   connection:"zohocrm"
55. ];
56. info updateField;
57. }
58. //To update the Deal Record
59. requestBody = Map();
60. requestList = List();
61. requestData = Map();
62. requestData.put("Closing_Month",picklistValue);
63. requestList.add(requestData);
64. requestBody.put("data",requestList);
65. info requestBody + "";
66. dealreecordUpdate = invokeurl
67. [
68. url :"https://www.zohoapis.com/crm/v7/Deals/" + dealRecordID
69. type :PUT
70. parameters:requestBody + ""
71. connection:"zohocrm"
72. ];
73. info dealreecordUpdate;

4. Configure the Workflow

Create a custom function by clicking the New Function or associate an existing one to the workflow. In our case, the deluge program has already been written and configured (associated) to the workflow. 

                            

• Under the workflow actions, select Function and choose the function you created.
• Ensure that the function is set to run when the workflow is triggered.
  

Creating a Deal with a Closing Date of January 2nd (Using an Existing Picklist Value)

                                               

Creating a Deal with a Closing Date of April 1st (Adding a New Picklist Value)

The new picklist value, which was not a value previously, has now been added to the picklist.

You can add values to a picklist field using the PATCH Field API. To remove an option from a picklist, use the Update Custom Layout API. Refer to the Sample input to mark picklist options as unused section in the Layouts API documentation.​

Cheers!!!

Related Links

• Configuring Workflow Rules
• Workflow Scenarios
• Workflow Suggestions by Zia
• FAQs: Workflow Rules
  
• Functions

Additional Links

• Zoho CRM V6 APIs
• Zoho CRM V7 APIs

Previous Kaizen:  #153 Interpreting Zoho CRM GraphQL schema  | Kaizen Collection

• Topic Participants

• Subramanian K

  

• Vigneshwaran K

  

• Garron Helman

• Ishwarya SG

  

• Alan Majhail

• Sticky Posts

• Kaizen #197: Frequently Asked Questions on GraphQL APIs

  🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Kaizen #198: Using Client Script for Custom Validation in Blueprint

  Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Celebrating 200 posts of Kaizen! Share your ideas for the milestone post

  Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs

• Kaizen #193: Creating different fields in Zoho CRM through API

  🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Client Script | Update - Introducing Commands in Client Script!

  Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands

• Recent Topics

• Updating Subform Record from other Form

  Just wanted to ask how to properly approach this. I have 2 forms and would like to trigger an auto update on the subform once record submitted. block below only updates 1 row for each recordRow in input.AV_System { AssetRecord = Site_Asset_Services[SOR_No

• Zoho Books - Hide Convert to Sales Order if it can't be used.

  Hi Books team, I noticed that it is not possible to convert a Quote to a Sales Order when a Quote is not yet marked as accepted. My idea is to not show the Convert to Sales Order button when it is not possible to use it, or show it in a grey inactive

• How do I bulk archive my projects in ZOHO projects

  Hi, I want to archive 50 Projects in one go. Can you please help me out , How can I do this? Thanks kapil

• Cross-Data Center Collaboration and / Or allowing users to choose DC

  Dear Zoho Cliq Support Team, We are writing to request a significant enhancement to Zoho Cliq that would greatly benefit our geographically dispersed development team. Current Challenge: Currently, Zoho Cliq automatically routes users to specific data

• New Mandatory One-Click Unsubscribe Link Overshadowing Custom Unsubscribe Link

  I was recently informed by Zoho CRM Support that they are now mandated by the large email service providers like Google and Yahoo to provide a one-click unsubscribe option in the header (not the body) of all mass emails. I have a custom unsubscribe link

• Send / Send & Close keyboard shortcuts

  Hello! My team is so close to using Zoho Desk with just the keyboard. Keyboard shortcuts really help us to be more efficient -- saving a second or two over thousands of tickets adds up quickly. It seems like the keyboard shortcuts in Desk are only for

• Is it possible to register webhooks in Zoho CRM using API?

  Hello, I am trying to register a webhook in Zoho CRM programmatically (using the API). Specifically, I want to register a webhook that is fired when new Contacts are created in the CRM. I was able to setup a webhook using the UI, by creating a rule that

• Calls where the local audio is shared, have echo

  When another user is sharing their screen with audio, I get echo from my own voice. We tested this with multiple users, with different audio setups, and there's no obvious way to fix it. Is this a bug you could look into, or are we missing something?

• Update application by uploading an updated DS file

  Is it possible? I have been working with AI on my desktop improving my application, and I have to keep copy pasting stuff... Would it be possible to import the DS file on top of an existing application to update the app accordingly?

• Markdown support, code cells...

  Hi Zoho I'd like to vote for a feature that markdown is supported with: Headings Code highlighting Quoteblocks ... Furthermore a inline card(like inline sketch card) for special text like Code would be great. And just to add my vote as well for "Tags"!

• Minimise chat when user navigates to new page

  When the user is in an active chat (chatbot) and is provide with an internal link, when they click the link to go to the internal page the chat opens again. This is not a good user experience. They have been sent the link to read what is on the page.

• How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

  How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

• Reports: Custom Search Function Fields

  Hi Zoho, Hope you'll add this into your roadmap. Issue: For the past 2yrs our global team been complaining and was brought to our attention recently that it's a time consuming process looking/scrolling down. Use-case: This form is a service report with

• Zoho Projects app update: Voice notes for Tasks and Bugs module

  Hello everyone! In the latest version(v3.9.37) of the Zoho Projects Android app update, we have introduced voice notes for the Tasks and Bugs module. The voice notes can be added as an attachment or can be transcribed into text. Recording and attaching

• zurl URL shortener Not working in Zoho social

  zurl URL shortener Not working in while creating a post in Zoho social

• In the Zoho CRM Module I have TRN Field I should contain 15 digit Number , If it Contain less than 15 digit Then show Alert message on save of the button , If it not contain any number not want to sh

  Hi In the Zoho CRM Module I have TRN Field I should contain 15 digit Number , If it Contain less than 15 digit Then show Alert message on save of the button , If it not contain any number not want to show alert. How We can achive in Zoho CRm Using custom

• Power of Automation::Streamline log hours to work hours upon task completion.

  Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-

• Zoho Bookings know-how: A hands-on workshop series

  Hello! We’re conducting a hands-on workshop series to help simplify appointment scheduling for your business with Zoho Bookings. We’ll be covering various functionalities and showing how you can leverage them for your business across five different sessions.

• Custom report

  Hello Everyone I hope everything is fine. I've tried to To change the layout of the reports, especially the summary page report, and I want to divide summary of each section in the survey but I can't For example: I have a survey containing five different

• Zoho Journey - ZOHO MARKETING AUTOMATION

  I’ve encountered an issue while working with a journey in Zoho Marketing Automation. After creating the journey, I wanted to edit the "Match Criteria" settings. Unfortunately: The criteria section appears to be locked and not editable. I’m also unable

• Custom Fields in PDF outputs

  I created a couple of custom fields. e.g Country of Origin and HS Tariff Code. I need these to appear on a clone of a sales order PDF template but on on the standard PDF template. When I select "appear on PDFs' it appears on both but when I don't select

• How to create a Service Agreement with Quarterly Estimate

  Hello, I'm not sure if this has been asked before so please don't get mad at me for asking. We're an NDIS provider in Australia so we need to draft a Service Agreement for our client. With the recent changes in the NDIS we're now required to also include

• Change Currency symbol

  I would like to change the way our currency displays when printed on quotes, invoices and purchase orders. Currently, we have Australian Dollars AUD as our Home Currency. The only two symbol choices available for this currency are "AU $" or "AUD". I would

• Zoho Social - Post Footer Templates

  As a content creator I often want to include some information at the end of most posts. It would be great if there was an option to add pre-written footers, similar to the Hashtag Groups at the end of posts. For example, if there is an offer I'm running

• Allow to pick color for project groups in Zoho Projects

  Hi Zoho Team, It would be really helpful if users could assign colors to project groups. This would make it easier to visually distinguish groups, improve navigation, and give a clearer overview when managing multiple projects. Thanks for considering

• Zoho Books - Quotes to Sales Order Automation

  Hi Books team, In the Quote settings there is an option to convert a Quote to an Invoice upon acceptance, but there is not feature to convert a Quote to a Sales Order (see screenshot below) For users selling products through Zoho Inventory, the workflow

• Can't find imported leads

  Hi There I have imported leads into the CRM via a .xls document, and the import is showing up as having been successful, however - when I try and locate the leads in the CRM system, I cannot find them.  1. There are no filters applied  2. They are not

• Custom Button Disappearing in mobile view | Zoho CRM Canvas

  I'm working in Zoho CRM Canvas to create a custom view for our sales team. One of the features I'm adding is a custom button that opens the leads address in another tab. I've had no issue with this in the desktop view, but in the mobile view the button

• The connected workflow is a great idea just needs Projects Integrations

  I just discovered the connected workflows in CRM and its a Great Idea i wish it was integrated with Zoho Projects I will explain our use case I am already trying to do something like connected workflow with zoho flow Our requirement was to Create a Task

• Zoho Projects MCP Feedback

  I've started using the MCP connector with Zoho Projects, and the features that exist really do work quite well - I feel this is going to be a major update to the Zoho Ecosystem. In projects a major missing feature is the ability to manage, (especially

• Function #10: Update item prices automatically based on the last transaction created

  In businesses, item prices are not always fixed and can fluctuate due to various factors. If you find yourself manually adjusting the item rates every time they change, we have the ideal time-saving solution for you. In today's post, we bring you custom

• email template

  How do I create and save an email template

• Enhancements in Portal User Group creation flow

  Hello everyone, Before introducing new Portal features, here are some changes to the UI of Portals page to improve the user experience. Some tabs and options have been repositioned so that users can better access the functionalities of the feature. From

• How do I filter contacts by account parameters?

  Need to filter a contact view according to account parameter, eg account type. Without this filter users are overwhelmed with irrelevant contacts. Workaround is to create a custom 'Contact Type' field but this unbearable duplicity as the information already

• Can I add Conditional merge tags on my Templates?

  Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter

• email moderation issue when email is sent in the name of a mail group

  Symptom: an email that is sent by a mail group moderator in the name of a moderated mail group is held back for approval. Reproduction: Create a moderated mail group with members and moderators. Allow that mails can be sent in the name of the group (extended settings). Send an email to the group as a group moderator, but in the name of the group. This mail is held back for moderation which is unexpected. Expected: A mail sent by group moderator to a moderated group are not held back for moderation

• blank page after login

  blank page after logging into my email account Thanks you

• Always display images from this sender – Is this feature available?

  In Zoho mail, I had my "Load external images" setting set to "Ask me", and that's fine. That's the setting I prefer. What's not fine though is I always need to tick "Display now" for each email I get, regardless if I've done that multiple times from several

• Function #9: Copy attachments of Sales Order to Purchase Order on conversion

  This week, we have written a custom function that automatically copies the attachments uploaded for a sales order to the corresponding purchase order after you convert it. Here's how to configure it in your Zoho Books organization. Custom Function: Hit

• Free webinar: Security that works: Building resilience for the AI-powered workforce

  Hello there, Did you know that more than 51% of organizations worldwide have experienced one or more security breaches, each costing over $1 million in losses or incident response? In today’s threat landscape, simply playing defense is no longer enough.

• Next Page