Record Collection Tips
If anyone ever sales they've never written bad code they are either lying or they are God himself.
Ok this was a very short list of tips. But, I plan on adding to it later. Anyone, else have code "yucks" from the past and your present solution POST IT! Doesn't have to be about record Collection.
Get Started. Write Away!
I starting using Zoho in Feb of 09 and like almost everyone that comes to Zoho Creator; I was looking for a way to make my business processes better. This led me to the wonderful world of Deluge Script!
I would like to Deluge Script learning curve, well, less curvaceous for many of the new DS'ers out there. One aspect about Deluge Script that I immediately picked up on and enjoyed is how you do looping and record collection..
For you scripting novices out there. Zoho has done a VERY great job on making loops and record collection for us EASY!
Here's a really basic loop in JAVASCRIPT....
for(var=startvalue;var<=endvalue;var=var+increment)
{
}
Here's the same basic loop in Zoho
for each variable in myRecordCollection
{
//do this
}
NOW, the other uber wonderful thing that I fell in love with! RECORD COLLECTION! Ok, first let me just say how annoyed I get when Deluge Script developers (with very little experience outside DS) start complaining about missing features and what not. Well, let's talk about what Zoho Creator ABSOLUTELY NAILED!
Do you know how nice we ZC users have it in regards to collecting records?
DS let's you write both client side and server side scripting ALL IN ONE. Normally, a regular developer has to write his html views, forms, user input actions, event listeners all in javascript, html and css THEN call a server side language script which connects to a database, creates a query, executes the query, formats the query data into the desired format, and sends it back to the client! ugh!
Yes, yes. I know all the rebuttals about separating your app into say an MVC (model, view, controller) architecture, using frameworks with ORM capabilities making SQL queries obsolete and so on. BUT, for the small business IT guy that needs a quick solid solution, you can't beat the simplicity of the inline DS query.
Also, might I just say how nice it is to write my queries in ECMA' esque language! While I do know $jquery, javascript, SQL, and PHP. It's just nice having this cute little DS language to do "most" of what I need it to do.
Ok, on to the guts..
Because ZC caters to the novice developer with very little experience in web development, one often sees many mistakes made in how DS is used. I was THIS GUY! Here are some of my embarrassing past practices and how I do it now. ZC employees and power users have a good smirk or laugh at my expense
Collecting based on one field with many values
Before :
myRecords = records[first_name == "John" || first_name == "Sue" || first_name == "Charles"]
Now :
myList = {"John","Sue","Charles"};
myRecords = records[first_name in myList]
OR Even
myRecords = records[first_name in {"John","Sue","Charles"}];
Making a list out of record fields
Before : (YUCK!)
myList = List();
for each r in records
{
if(field == "value")
{
myList.add(r.field);
}
}
Now : (AVOID THE LOOP)
myRecords = records[field == "value"];
myList = myRecords.field.getALL();
Making a unique list out of record fields
Before :
myUniqueList = List();
for each r in records
{
if(!myUniqueList.contains(r.field))
{
myUniqueList.add(r.field);
}
}
Now : (take the collection offline)
myUniqueList = {};
myRecords = records;
myFieldList = myRecords.field.getAll();
for each r in myFieldList
{
if(!myUniqueList.contains(r))
{
myUniqueList.add(r)
}
}
NOTE : Haven't tested to see whether this is actually a performance gain but it seems that looping through a list is faster than looping through records.
Updating records in one form based on another.
Before : THE WORST!
for each r in form1
{
if(r.field1 == "value")
{
form2Record = form2[field2 == r.field1];
form2Record.field2 = "New Value";
}
}
Before : a little better by removing if operator and reducing size of records before loop. Also, USE THE ID along with a stored related id (don't forget to set the number fields char limit to 25)!
for each r in form1[field1 == "value"]
{
form2Record = form2[form1_id == r.ID];
form2Record.field2 = "New Value";
}
Now : Waaaay BETTER
form1Records = form1[field1 == "value"];
form1RecordList = form1Records.ID.getAll();
form2Records = form2[form1_Id in form1RecordList];
form2Records.field2 = "New Value";
Creating a "record reduce" based on many table values related to another.
Before : never thought about it :)
Now :
lastNameRecords = namesForm[last_name != ""] sort by Added_Time desc range from 1 to 100;
lastNameList = lastNameRecords.last_name.getAll();
locationRecords = locationsForm[open == "yes"]
locationsList = locationsRecords.location.getAll();
//new members in open locations
lastHundredMembers = members[last_name in lastNameList && location in locationsList];
Ok this was a very short list of tips. But, I plan on adding to it later. Anyone, else have code "yucks" from the past and your present solution POST IT! Doesn't have to be about record Collection.
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
Stephen Rhyne
George Baltatescu
Yogendra Babu
edbradburn
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
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: HitKaizen #8 - Handling Recurrence and Participants in the Events Module via API
Hello everyone! We are back this week with an exciting post—Handling recurrence and participants in the Events module through API. First things first—What is the Events module? "Events" is a part of the Activities module in Zoho CRM. An event is an activity that happens at a given place and time. You can find Events on the user's Zoho CRM's home page, Activities home page, Calendar, and in other related records. What are the types of Events? Events are of two types—Recurring and non-recurring events.Marketer’s Space - Get Holiday-Ready with Zoho Campaigns
Hello marketers, Welcome back to another post in Marketer’s Space! Q4 is packed with opportunities to connect with your audience - from Halloween, Black Friday, and Cyber Monday, to Thanksgiving, Christmas, and New Year. In this post, we’ll look at howPersonalized demo
can I know more about the personalized demo we are construction company andCan I collect email addresses in a form??
Can I add new subscribers to my email list (hosted in FloDesk) when they check a box and add their email address on a Zoho form?Zoho CRM Android app updates: Kiosk and multiple file upload support for subforms
Hello everyone, We've rolled out new enhancements to the Zoho CRM Android app to bring better mobile CRM experience and efficiency. Let's take a quick look at what's new: Kiosk Multiple file uploads for subforms Kiosk Kiosk is a no-code tool in Zoho CRMAlerts for mentions in comments
We are testing the use of Writer internally and found that when a user is mentioned in a comment, there is no email alert for the mention. Is this something that's configurable, and if so, where can we enable this option?Standard Payment Term is not pulled from account to quotation
Hey Team There seems to be something off. I do have "Net 30" as my default payment term in Zoho Books for my customers. If, from the customer overview or quote section, I create a new Quotation, the payment terms field stays blank and doesn't get theOAuth integration issues
I'm experiencing persistent OAuth errors when trying to connect Make with Zoho API. I've tried multiple approaches but keep encountering the following issues: First error: 'Invalid Redirect Uri - Redirect URI passed does not match with the one configured'Zoho Mail Android app update: Manage folders
Hello everyone! In the latest version(v2.9) of the Zoho Mail Android app update, we have brought in support for an option to manage folders. You can now create, edit, and delete folders from within the mobile app. You can also manage folders for the POPvalidation rules doesn't work in Blueprint when it is validated using function?
I have tried to create a validation rule in the deal module. it works if I try to create a deal manually or if I try to update the empty field inside a deal. but when I try to update the field via the blueprint mandatory field, it seems the validationGet Zoho Mail API working (including DRE Connector, Oauth Token, ZUID, ZOID & ACCOUNT_ID)
Disclaimer: I’m not a professional coder! Do you need to use Zoho Mail API? Me too. It lets you do all sorts of things — like reading the complete header of an email, or forwarding an email with its attachments — which is what I wanted to do. But settingRevenue Deferrals
Does ZOHO books and subscriptions handle Revenue Deferrals?Can I make a website open inside Zoho whenever I log in?
Hi Zoho Team, Every day, I check a few websites for updates, for example, Rojgar--result, where I see the latest government job results and notifications. I was wondering if there’s any option in Zoho to make a website like that open inside Zoho wheneverKaizen #214 - Workflow APIs - Part 2
Welcome back to another week of Kaizen! Last week, we discussed how Zylker Cloud Services used the Workflow APIs to discover and audit all the automations in their CRM, listing every workflow, checking triggers, and understanding their automation limits.Playback and Management Enhancements for Zoho Quartz Recordings
Hello Zoho Team, We hope you're all doing well. We would like to submit a feature request related to Zoho Quartz, the tool used to record and share browser sessions with Zoho Support. 🎯 Current Functionality As of now, Zoho Quartz allows users to recordZoho CRM Community Digest - September P1 | 2025
Hello Everyone! September's Here! Before we jump into product updates, and community highlights, here's a quick spotlight! Zoho has launched a Professional Sales Rep Certification course on Coursera, tailored for sales professionals to strengthen theirUpload my theme.
Hello. I would like to upload my own theme, this one: https://themeforest.net/item/panagea-travel-and-tours-listings-template/21957086 Is it compatible and where I upload it? If not I will hire a developer, what do I have to ask when I search for one?Product Updates in Zoho Workplace applications | September 2025
Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this September. Zoho Mail Attach email as EML file in Compose Effortlessly attach emails as EML file in Compose by simplyVehicle Tracking
we have GPS devices that installed on our vehicles, and we would like to know if it's possible to get vehicle live location data from the GPS device To Zoho Creator App. Thank You🤝 Rencontres, partage et inspiration au Zoho Community Meetup de novembre
Chers utilisateurs, Bonne nouvelle 🎉 : notre Meetup Zoho Community approche, et nous serions ravis de vous y voir ! 📍 Toulouse : le 25 novembre 📍 Lyon : le 27 novembre (🎯 Il ne reste que quelques places !) Que vous soyez débutant ou utilisateur avancé,Need Help Mapping GST Registration Number Field Between Zoho Books & Zoho CRM + Slow Sync Issues
am facing an issue with field mapping between Zoho Books and Zoho CRM. I want to map the GST Registration Number field from the Customer module in Zoho Books to a custom GST field inside the Accounts module in Zoho CRM. However, I am getting a warningNotification received when self-assigning tickets
When I assign tickets in Zoho Desk the relevant agent gets a notification email. When assigning myself a ticket in Zoho Desk, I get a notification email. Now, as I am the person who assigned the ticket to myself, getting a notification in this regardNouveauté dans Zoho Writer - Création de documents et de modèles assistée par l'IA
Zia, l’assistant IA de Zoho Writer, soutient les utilisateurs dans l’amélioration de leur écriture et la création de contenus : correction orthographique et grammaticale en temps réel, suggestions adaptées au contexte, détection du plagiat, révisionsSession Expired
I constantly get "Session Expired" and need to relogin or close and open the application again. This gets really frustrating during the day. Is this something that can be solved? This really makes me want to leave the app as it is no go to need to reopenIntegrate your Outlook/ Office 365 inbox with Zoho CRM via Graph API
Hello folks, In addition to the existing IMAP and POP options, you can now integrate your Outlook/Office 365 inbox with Zoho CRM via Graph API. Why did we add this option? Microsoft Graph API offers a single endpoint to access data from across Microsoft’sDisable Buttons for Users with Profiles without permission
Hey, I've noticed that users without permission of setting up things in the marketplace, can still see the icon: On a click, you see this: It would be way better, if they couldn't see this menu icon at all. (Aside from the fact that it completely misplacedMapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually
Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be ableZoho Analytics - Make text clickable in underlying data
Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on theCredit Management: #5 Advanced Refund Policy
You're subscribed to a well-known SaaS design tool. You've used it to manage your team's projects, create marketing visuals, brochures, and so on. But your needs change over time. Your company may switch to another tool or hire an in-house designer whoExported Slide Image Lacks Portion of the Background Image
This does not always happen, but when I export (or "download") the rendered image of a slide, it sometimes lacks a portion of the background image. I created a sample slide deck to demonstrate it and shared it with the admins. It is also publicly availableHow to create a Zoho Mail extension similar to Outlook's OnSend add-in?
Hi, I want to create a Zoho Mail extension similar to Outlook’s OnSend add-in. The extension should: Let the user select headers and footers from a taskpane while composing an email. When the user clicks Send, the extension should: Automatically insertEffective Inbox Organization: Folders vs Tags in Zoho Mail?
I'm exploring the best ways to organize a busy inbox, especially when managing multiple clients or project using Zoho Mail. I’d love to know what works best for others: 1. Do you prefer **folders** (possibly with sub-folders) for each client or project?Piss poor service in Support in Domains and email
Srijith Narayanan B contacted me today. Very pleasant fellow. Just didn't want to tell him how bad your support service is. You help the person, but you leave before we can finish the next stage. Which causes a lot of frustration. It's been 8 days nowZoho Mail android app update: Block & reject future emails, Report phishing, Spam alerts, Suspicious URL detection
Hello everyone! In the most recent Zoho Mail Android app update, we have brought in support for the following features: Block & reject future emails Report Phishing Spam alerts in the mail details screen. Suspicious URL detection. Block & reject futureZohomail does not support additional fields in mailto links
Hello, I set up Zohomail as default composer in Firefox according to manual here: https://www.zoho.com/mail/help/defaultcomposer.html#alink2 Later, I wanted to use this functionality to answer in a Linux mailing list thread using mailto link: mailto:xxxxx@kernel.org?In-Reply-To=%3C727o0521-q24p-s0qq-66n0-sn436rpqqr1p@example.com%3E&Cc=xxxxx%example.org&Subject=Re%3A%20%5BPATCH%20v2%28%29Emails not being received from a particular domain
Cannot receive any emails sent from atco.com Domain is in the spam whitelist so should be no reason for it not to be coming through. Have filed a ticket and besides a generic response of we are looking at it - it seems there is no actual support workersEmail address for forwarding is not saving and there's no confirmation ema
Steps to reproduce: 1. Enter my forward email in the email forward section of the account 2. Click save 3. See a notification stating saved successfully 4. Refresh the page, no forward email is saved 5. No email confirmation received at the forwardingThis domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details
This is the error i keep getting when trying to use my Zoho Domain Mail. This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details Find attached. I hope this can be resolved very quickly so i can go on and makeAuto CC - Moving Departments
We have Auto CC e-mail replies to your support mailbox enabled. We have two departments: Helpdesk (helpdesk@domain.com) Delivery (delivery@domain.com) If we create a Helpdesk ticket, and reply, replies are CC'd to helpdesk@domain.com (OK) We then moveNext Page