Skip to main content

Auto populating custom field in Zoho CRM using criteria

I saw this question in the Zoho forums and thought I'd respond:
Is there way to auto-populate a field given a set of criteria?

For example, I'd like all Potentials that close between a set of dates (i.e. between 1/1/2015 and 5/1/2015) to automatically populate the same text in a custom field I've called "Group."

My Answer

  1. void   modify_group_for_jim_based_on_closing_date  ( int potential_id   )
  2. potential = zoho.crm.getRecordById("Potentials",input.potential_id);
  3. the_closing_date=(potential.get("Closing Date")).toDate();
  4. date_window_1=("1/1/2015").toDate();
  5. date_window_2=("1/5/2015").toDate();
  6. date_window_3=("1/6/2015").toDate();
  7. date_window_4=("1/11/2015").toDate();
  8. potential_map=map();
  9. if((the_closing_date  >=  date_window_1)  &&  (the_closing_date  <=  date_window_2))
  10. {
  11. potential_map.put("Group","Group 1");
  12. }
  13. else if((the_closing_date  >=  date_window_3)  &&  (the_closing_date  <=  date_window_4))
  14. {
  15. potential_map.put("Group","Group 2");
  16. }
  17. else
  18. {
  19. potential_map.put("Group","Unknown Group");
  20. }
  21. potential_id_str=input.potential_id.toString();
  22. updatedPotential = zoho.crm.updateRecord("Potentials",potential_id_str,potential_map);
  23. info "Response: " + updatedPotential;


Popular posts from this blog

Getting current time in a specified timezone using Deluge script

Recently I was working on a custom function for Zoho CRM which required me to get the current time in a specified timezone. I assumed that zoho.currenttime would give me the time based on the timezone chosen in the organisation settings but discovered that it always gives it to you in PST. The Zoho Partner team gave me this snippet to solve the problem: current_time_in_timezone = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", "Australia/Sydney").toTime("yyyy-MM-dd'T'HH:mm:ss"); If you need the current date, do: current_date_in_timezone = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", timezone).toDate(); To figure out what you can put in for the timezone part, refer to

searchRecords with multiple criteria in Zoho CRM API

NB: this blog post is no longer relevant as API v2 lets you use searchRecords with multiple criteria :) I discovered something really cool tucked away in the Zoho CRM forums today. For the history, check out this thread . In summary, the searchRecords API task in Zoho CRM is impossible to use if you have multiple criteria and in general it's pretty annoying to get the single criterion right. In the forum thread, Zoho Support advised that you can actually use getRecords with a view name. This feature is not documented on the getRecords page at all but I can confirm it works:D This is really, really cool. It's going to make my life as a Zoho dev much easier! Instead of having to do something really inefficient and ugly like: leadRecords = zoho.crm.searchRecords("Leads","(Created Time|<|" + yesterday_date +")",fromIndex,toIndex); for each ele in leadRecords { lead_source = ele.get("Lead Source"); createTime=(ele.g

Debugging Deluge script in Zoho Creator/Zoho CRM

Deluge is a powerful language that simplifies a ton of things, e.g. database lookups. But I have to say, it's very painful to debug. Interpreting longish scripts takes ages, error messages are obtuse if they exist at all and even the hints in the IDE don't always help (ever tried using containsIgnoreCase based on the auto-complete suggestion?). Here are my tips for debugging code when it's not working. 1. Split your code up into small custom functions. Nothing's more painful than waiting 30 seconds for a really long (say 1000 lines) HTML page to save and only then get feedback on a syntax error. I've got a few apps that are like this and it's not fun to work with at all. I haven't seen any improvements in the compile speed over the last few years, so my conclusion is that it's always best to write most of your logic code as small custom functions and then build that up in the HTML page so that you'll get quick feedback on syntax errors. 2. If