Custom Function: Searching Events in the current month - with record count
I hate to be a bother to the fine folks here, but I'm stuck in another function. GOAL: write a custom function to count the number of Meetings each person in Contacts has for the current month, then push that count to a field in the contact record.
Spent about 6 hours trying different versions of the function, none work. Original code below. I think I might have to use CoQL query for the function, but was hoping to avoid it. Never used APIs.
Attempts so far: Tried to iterate in various forms & found out Deluge doesn't support iterative loops with increments. Found out CRM deluge doesn't support count() for a collection, it's only applicable to Creator according to help docs. And the integration task "zoho.crm.searchrecords" only supports equals and starts with as criteria, so I can't search "in" the current month.
Then I thought about using intersect(). But now currently thinking, in natural language: "for each name in Contacts, select query search Meetings this month where Event_Title contains name" and return count of record, I assume using size().
So, maybe I need to use a "for each" loop on Contacts with a CoQL select query for meetings in the current month where the Event_Title field contains the contact's name.
Really frustrating as a non-dev. I'm sure there's multiple ways to do it but I can't figure it out due to search criteria limitations. Makes me feel stupid, and it feels like there's information missing from the help documents.
Original Code (trying to iterate, mistakes and all):
- Startdate = zoho.currentdate.toStartOfMonth();
- Enddate = Startdate.addMonth(1);
- eventlist = zoho.crm.searchRecords("Events","Start_DateTime : in : this month");
- myList = eventlist.toList();
- for each rec in clients
- {
- name = rec.getJSON("Last_Name");
- ident = rec.getJSON("id");
- sessioncount = 0;
- for each meeting in myList
- {
- title = meeting.getJSON("Event_Title");
- if(title.contains(name) == true && title.contains("training") == true) //this line would NOT work if "eventlist" was still a collection variable, so I had to convert it to List variable
- {
- sessioncount +=1;
- }
- }
- mp = Map();
- mp.put("Scheduled Sessions",sessioncount);
- info name;
- info sessioncount;
- info mp;
- //update = zoho.crm.updateRecord("Contacts",ident,mp);
- //info update;
- }
Obviously problems there. Now trying to use the CoQL api, but I've never done APIs before.
Relevant code below. You can see several versions of the searchRecords task based on different community/help docs, but none seem to work.
Code below just tries to return ALL the Meetings in the current month to get proof of concept. Returns Invalid Query. Sessioncount should be 116, but returns 4... I have no idea where that's from.
- //eventlist = zoho.crm.searchRecords("Events","(Start_DateTime:equals:"+Startdate.toString("yyyy-MM-dd")+")");
- eventlist = zoho.crm.searchRecords("Events",{"select_query":"SELECT Event_Title FROM Events where Start_DateTime in'"+Startdate+"'"});
- //eventlist = zoho.crm.getRecords("Events",1,400,query_map);
- //myList = eventlist.toList();
- queryMap = Map();
- queryMap.put("select_query", "select Event_Title, Start_DateTime from Events where Start_DateTime in '"+Startdate+"'");
- response = invokeurl
- [
- url :"https://www.zohoapis.com/crm/v3/coql"
- type :POST
- parameters: queryMap.toString()
- connection:"crmconnection_all"
- ];
- info response;
- sessioncount = eventlist.size();
- info sessioncount;
Does anybody have an approach they could share? I've pulled my hair out!
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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
New to Bigin?
Topic Participants
Matt Warner, MSc.
Hugh Marshall
Andres
Sticky Posts
Function #46: Auto-Calculate Sales Margin on a Quote
Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it'sZoho CRM Functions 53: Automatically name your Deals during lead conversion.
Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One suchUser Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)
Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.Custom Function : Automatically send the Quote to the related contact
Scenario: Automatically send the Quote to the related contact. We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please followFunction #50: Schedule Calls to records
Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Weekly Tips : Take Control of Your Sent Emails using Outbox Delay
Ever clicked “Send” on an email, then instantly realized you forgot something—like a file, an attachment, or even made a small typo? It happens more often than you'd think. Wouldn’t it be helpful if your email waited a little before actually going out?Format of data after export to spreadsheet
Dear Zoho, can you explain to me what is the point of a report exporting to XLSX if the format of the amounts that will be created there is in text format and not suitable for anything? Why do I need data in a sheet with which nothing more can be doCustomer Payment
Seprate voucher required for cash and bank .You can not authorized any one to enter cash payment .In statement clearly shown is it bank receipt or cash recipt .how to add previous month purchase bill and claim ITC
Hello we have a unclaimed ITC bill of April (we didn't claim it in may as seller didn't uploaded his gstr1 ) when we trying to file gstr 3b in june month we noticed the bill has been uploaded (april bill) .how to change the filing month of that aprilDeluge security enhancements
Hello everyone, At Deluge, security is a top priority, and we're continuously working to enhance the platform's safety and reliability. As part of our ongoing commitment to secure coding and industry best practices, we're rolling out key updates to howHow do I set users up to only send emails using org emails?
We run marketing campaigns for multiple clients and strictly send emails using the official organization addresses provided by each client. However, we've encountered several instances where users unintentionally send emails from their own company accounts—aopen multiple notes at a time.
Hey there, New to Notebook and liking it, but one thing that's really a bother is not being able to open more than one note at a time, either in a new window or in a new tab. Often times, I like to copy/paste from one note to another or compare draftsLet’s Talk Recruit: Forms that think before you do!
Welcome back to our Let's Talk Recruit series. In our previous post, we shared highlights from our community meetups held across India. This time, we’re talking about something that often gets overlooked but makes a huge difference once you set it upPEPPOL Support Needed for Zoho Books in Europe
I'm reaching out to discuss the urgent need for PEPPOL support in Zoho Books for European users. With Belgium mandating B2B e-invoicing via PEPPOL starting in 2026, many of us are struggling to manage invoices without this integration. While Zoho BooksAllow Equity Accounts to be Used for Expenses
Currently, when entering an Expense or Bill, the Expense Account (account to be debited) allows for accounts in any of these categories to be chosen: COGS Expense Other Current Liability Fixed Asset Other Current Asset Noticeably missing are Equity Accounts.メール一括配信の未送信のメールについて知りたい
メール一括配信の後の、未送信のメールの数は添付のようにシステムから連絡がくるのですが それらの対象者を知りたい。レポートなど一覧で知りたい。 また配信対象者なのに（担当者、リード）の メールの履歴に配信したメールの件名でさえ表示されないのはどう理解したらよいのか知りたいです。 また、これらの人をレポートで一覧で出す方法を教えてください。把握したいためです。How do I add the time zone for the each recipient/subscriber
Hi, I've read that Zoho allows for emails to be sent at a certain time based on the recipient's time zone. How do I add the time zone for the each recipient/subscriber? Thanks!Zoho Formsから獲得した見込み客をSaleIQでトラッキングし、そのトラッキング情報をCRMに集約することは可能でしょうか？
Zoho formsを活用しています。 Zoho CRM、Zoho SalesIQと連携するよう設定しており、Zoho formsから獲得した見込み客の情報はCRMに連携されるのですが、トラッキング情報はZoho CRMの見込み客データ内の 関連リスト 訪問-Zoho salesIQ にデータが反映されません。※添付画像参照ください 考えられる原因や対策などありましたら教えていただけないでしょうか。 よろしくお願い致します。Find and Merge Duplicates to trigger webhook
My sales team uses the Find and Merge Duplicates feature often to cleanup records in the CRM. We use webhooks to signal to our internal tools database when new Contacts are created, updated, or deleted, in order to keep our DB in sync with Zoho CRM. However,Marketer’s Space: Using Zoho CRM Data for Dynamic Content and Personalization in Zoho Campaigns
Hello Marketers! Welcome back to Marketer’s Space. Do you want to send emails or SMS that feel less like mass messages and more like one-on-one conversations? By integrating Zoho CRM with Zoho Campaigns, you can pull in rich customer data and use it toAdd Attendees to Session months before the Event
I need to manually add Attendees to Sessions right away for an event that's taking place in 6 months so that the Speaker can communicate with them in advance of the event. How can this be done?Override Auto Number field?
We are preparing to migrate from Salesforce. In Salesforce, we auto-generate a unique number on our Opportunities (Potentials). If the Opportunity results in a contract, we use that unique number as the Contract number. There are some situations whereSwitching hosts while meeting is occuring
We had a team meeting in Zoho Meetings this morning, but the person listed as the host had to leave the meeting early. We looked for an option to set me to host, but didn't see the option, and we incorrectly assumed that it would be like Zoom in thatRefund Form Can’t Reverse “Bank Charges” Line — Throws Off Reconciliation
Zoho, When we pay a vendor, the Payment screen lets us add a “Bank Charges” amount (we post a $1 processing fee there). Perfect. But on the Refund popup there’s no matching field, so the refund can only return the net expense. If our processor sends backTrigger for Validation Rules
Currently in Zoho CRM we can set a trigger for workflows, blueprints etc in a custom deluge function But Validation Rules are missing For example if I run a custom function to update a record, it bypasses the validation rules It would be really beneficialZOHO Desk blocking emails from creating tickets
Hi We have been noticing some issues since last week ZOHO Desk is not creating a ticket which is still in our affiliate mail box.how to install desk
how to install deskHow to turn off ability to share Knowledge-base article with social networks
Is there a way to deactivate the link at the bottom of a Knowledge-base article so that it can not be shared via Facebook or Twitter?Automatically Hide Unauthorized Sections from Agent Interface in Zoho Desk
Hello Zoho Desk Team, We hope you're doing well. We’d like to submit a feature request regarding the user experience for agents in Zoho Desk who do not have permission to access certain sections of the system. 🎯 Current Behavior At present, when an agentIs there a way to prevent a user from removing a payment method on a live, recurring subscription?
As it stands, if you allow users to remove payment methods, they can do so on live subscriptions. This leaves the sub without a payment method. The user should be able to REPLACE the card with a new one, but not remove all payment methods. We have hadAssistance Required: Report Export to Excel and WorkDrive Upload via Deluge
I'm working on automating a scheduled workflow in Zoho Creator that needs to run weekly. The goal is to: Export a report from Zoho Creator in Excel (.xls or .xlsx) format, and Upload the exported file to a specific folder in Zoho WorkDrive using a DelugeUseful enhancements to Mail Merge in Zoho CRM
Dear Customers, We hope you're well! We're here with a set of highly anticipated enhancements to the Mail Merge feature in Zoho CRM. Let's go! Mail Merge in Zoho CRM integrates with Zoho Writer to simplify the process of customizing and sharing documentsHow can I see the actual copy sent to the specific contact?
I have setup a journey in Marketing Automation and created addition of contact in a specific list as the trigger, emails are sending to the contacts, but I can't see the actual copy sent to any specific contact in the list. Please guide me, where canClient Script for Task Module
When do we expect the client script for the tasks module?Formula Fields inside of Blueprint Transitions
We would like to have formula fields inside of blueprint transitions. We type in currency fields and would like to see the result inside of a formula field. Our use case: Send out a price for XY 1. Filling out cost fields 2. See gross profitinventory based on bills and not physical stock
Hello, I have noticed a very annoying issue with zoho books/inventory. I use composite items. If I have an sub assembly item on back order, I am unable to make up the composite item, even when I have received the goods and it is in my stock. I have to convert the PO into a BILL in order for the item to show as 'Accounting Stock'. The problem is that the supplier Invoice is not shipped with the goods, but can follow even a week later. So I have to make the bill have a 'dummy name and number' untilUsing Zoho Inventory for managing Item compatibilities
Use case: Using Zoho Inventory for managing (as an example) aftermarket car parts, where a single part can suit many makes, models and years. How do most businesses assign and manage compatibility for each part? Do ZI users typically do this using multi-selectUnable to enter manual journal entries in AR/AP.
Hi there, i am facing some problem relating to AR/AP. I want to make some entries in AR/AP through manual journal. for example. some time I send cash 500 to Mr. A (Customer) for any purpose and then after 2 or 3 days Mr. A returned back 700 to me andQuestions regarding WorkDrive
Here are my questions regarding WorkDrive: Does WorkDrive have a limit on the number of downloads? What will happen if a file is downloaded excessively? Does WorkDrive have any restrictions on download speeds? Are there any limitations on downloadingHow to record tips from customers
I run a cleaning service business and on occasion customers include a tip with their check payment. How can I record the amount paid for service and the tip separately? Any amount over the invoice is looked at as an overpayment and suggest a credit noteMulti-currencies in Zoho Books
I'd like to request multiple currencies in Zoho Books. I have customers paying in USD, CAD, CNY. I need to bill customers in these currencies too. I can set up a base currency, and then set up a exchange-rate table to convert these currencies.I want refund of Zoho standard subscription on WEB payment
Hi, Kindly help to refund the WEB payment made on 13/07/2025 for Zoho standard annual subscription. I didn't find the software useful for my project. RegardsIs Conditional display of field(s) possible in a Canvas Customer Portal?
Is Conditional display of field(s) possible in a Canvas Customer Portal? How?View Linked Subscription on Invoice list
When looking at the list of invoices in billing is it possible to see the subscription that an invoice is for. This would allow you to see if it's a subscription a customer is behind on, or they simply haven't paid a one time invoice.Recording Credit Card Fees when Recording Payment for Bills
It seems I am unable to record credit card fees when paying a bill. I pay close to 100% of my bills with a company credit card via online portals. I'm happy for the CC fess to be recorded as Bank Charges but it will not allow that field to be used ifNext Page