
Hello everyone!
What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel, right? How about keeping a tab on their birthdays from your business tool, Zoho CRM? And how about automating greetings just in case you are too pressed for time to leave a personal note? Besides, this reduces the possibility of your missing out wishing some of your clients. Cool, right? Let me just show you a simple hack that lets you automate birthday greetings to your customers!
Here are the steps:
1. Create a birthday wish template:
Go to Settings->Setup->Customization->Templates->Create a template for Leads/Contacts. You have three options to create birthday templates.
(a)
Pre-defined templates:
Find a few pre-defined birthday templates from Create a template - >C
elebration.
(b)
Customized templates: Find a few basic models from Create a new template -> Basic
(c)Customized templates using HTML: Go to 'Insert HTML' option on the top right corner
in the template gallery. Add or edit your code.
2. Create a workflow to automate sending the birthday greetings.
a) Go to Settings->Setup->Workflow rules->Create a rule for Contacts.
b) Define the time and date on which the workflow must be triggered, and pick the Date of Birth field.
c)Choose the date of execution as Date of Birth field
d)Set the Execution cycle as Every year.
e) Set the "Which records" to “All records” (Or define specific groups and choose to send birthday wishes to that specific clientele (https://www.zoho.com/crm/help/automation/workflow-rules.html - Locate Set rule criteria)
3. Define an action to trigger emails to customers on their birthdays.
Go to Instant action->Send alerts->Choose the birthday template just created->Email recipient is “Contact/Lead: email and save the workflow. This automation rule sends greetings to your contacts every year on their birthday.

4. Personalize emails to important clients by creating a custom view showing upcoming birthdays. This is done using formula fields. Let me walk you through the steps:
1. Go to Setup->Modules->Contacts. Drag and drop a Formula field and paste this in the expression and name it as “Month of Birth” and save the formula.
Month(${Contacts.Date of Birth})
This formula extracts the month of the date of birth and updates it in this formula field.
Then, drag and drop another formula and paste the below expression and name it as “Day of birth” and save the formula and the layout.
Dayofmonth(${Contacts.Date of Birth})
This formula extracts the day of the date and updates it in this formula field.

Similarly, consider the above image as reference and create another formula using Dayofmonth(${Contacts.Date of Birth})
2. Go to Contacts module—>List view drop down at the top left—>Create view.
3. Give the criteria as “If “Month of Birth” is 1 and name this view as January and add Day of Month and Month of birth columns in the view.
4.Sort the day of month in the ascending order.

Now, all the birthdays that fall in January is listed in this view. Create 11 other views for each month. If you feel the custom views are flooding the drop down, just edit this custom view on the 1st of every month and change the month of birth criteria alone. If you have any queries on this, do leave a comment below. Will be happy to help you with it!
Recent Topics
Making money out of Zoho Sheets - How?
Hello, Suppose I come up with a brilliant Zoho Sheet that I want to sell to other people, can I do this? How? Thanks.
Adding Columns to Reports
Hi, Is it possible to choose fields to be added as columns in the reports? Thank you.
Sudden Layout Issue After Last CSS Update for ZML (Temporary Fix Inside)
Hi, Our clients have noticed today that every section laid out with ZML suddenly shows an unwanted top padding/blank space that interrupts the user screens. It appears that Zoho has changed the default CSS for the .zcp-col.zcp-panel-rowtype-auto element.
What are people using to send Service based emails?
Zoho Campaigns is for marketing. Users can unsubscribe from these emails. Service based emails need to be delivered and can without the worry of Can-spam act. What are people using to send service based emails? My mailing list is derived from a database
Client Script also planned for Zoho Desk?
Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field
Introducing Zoho Commerce 2.0 — It's more than just selling!
Hello! We are proud to launch Zoho Commerce 2.0, a reimagination of how online businesses look, feel, and function. This launch is both timely and symbolic, as we reaffirm our commitment to empowering small and medium enterprises with powerful, yet simple-to-use
Kits: Option to Hide Associate Items on Documents
The new Kit type of Composite Item is very helpful, and we're already using it in several different ways. One problem is that there seems to be no way to hide the components on some documents, including Package Slips. There is an option given in settings
Unable to display field label from a hidden Single Line Textbox in Description
Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, and
An Exclusive Session for Zoho Desk Users: AI in Zoho Desk
A Zoho Community Learning Initiative Hello everyone! This is an announcement for Zoho Desk users and anyone exploring Zoho Desk. With every nook and corner buzzing, "AI's here, AI's there," it's the right time for us to take a closer look at how the AI
Email for customer to provide payment information
Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?
Ticket Automatically Created from Closed Chat
Is there a way to prevent a ticket being create for every chat.... or at the very least have it automatically closed.
I want to Show the product list based on the drop Down
in quotation app , amc form form i have Department drop down field and in subform i have loop up field item description taken from the anothe app PRO I want to show the product list look up based on the deparment selected example if they selected deparment
Bad User: Authenticated but not connected
Zoho CRM cannot send/receive emails and it appears as if it may be an api configuration change either via Zoho or MS. Does anyone have information on how to fix this error message? I am admin on all my accounts. Zoho and MS are blaming each other.
Zoho + ERP (SAP)
First of all: I'm using Zoho CRM and I have complete right that it's a brilliant solution for sales force. But, in my new job, doesn't exist a CRM system and I want propose Zoho CRM. In the company, we're using a ERP (SAP), a few time ago. I would like to know about integration between Zoho CRM and ERP (SAP), as possible? How I can do that? Regards, Renato Lima
Lookup fields
Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules
Sort data in Pivot Table
Is it possible to sort by a data field. I can gruop and filter, but I culdn't find how to sort the results. Tank You.
Inventory Barcode Creation - Add Picture of Item
Hi I am trying to set up bar code labels and include a picture of the item on the label - any idea on how to add that field to the barcode generator?
Shared Snippets Everyone
Hi, Now that the Shared Snippets have been released and I think will be the most used feature implemented in 2023 :) Creating and Using Snippets in Ticket Responses - Online Help | Zoho Desk Maintain consistency in ticket responses with shared snippets
Please Enable Snippets for Agents Adding Comments
Snippets and templates are currently enabled for agents when they use the reply functionality. There is currently no way to add a template or snippets when an agent comments. This is really weird. Our agents don't use the reply functionality, only the
Topics assigned to Contacts in Campaigns
I have yet to find an efficient way to assign topics to contacts in campaigns with the new system in place. We have daily contacts added to our system through various forms and we have to manually go in and add topics to contacts before each email campaign
CRM Email Insights Not Working - Status not Changing
I used to be able to see if a customer opened/read an email in CRM, but I no longer get those status changes inside their record. I have everything enabled and I am sending the email from CRM. The experience center has the status' enabled as well. Any
Product and Service
Hi guys, there is a difference between layout of product and service if Long Description field have some kind of text. Please see screenshot 1 for Service here: https://prnt.sc/7xWwPKd29nWP for Product here: https://prnt.sc/LGmtVd_U6H7q As you can see
The Urgent Need for Native Brazilian Payment Integrations: PIX and Direct Bank Connections
Hello Zoho Team, I am writing to emphasize a critical functionality gap for Zoho Books in the Brazilian market: the lack of modern, native payment gateway integrations. The current options are insufficient. The Mercado Pago integration, for instance,
Better implementation of Item Category on Invoices and Estimates
1) I have added Item Category as a custom field. Honestly, this should be a native part of the item itself, and either required, optional, or not used. 2) When entering an item on an invoice, you have to enter the first character(s) of the item, otherwise
Try CRM for everyone button in the way of workflow
Please consider using the bottom bar for offers. Using the top bar for offers like "Try CRM for everyone" really gets in the way of my day to day workflow.
Zoho Signature, "For Demo Purpose Only Powered by Zoho Sign"
How to disable this text on the documents for signature. "For Demo Purpose Only Powered by Zoho Sign"
Zoho CRM email formatting issues
I have been having a hard time with formatting email templates. It feels like Zoho email is "fighting my edits." It refuses to change size, font, etc. Sometimes, the template looks great, then when the email gets sent, it looks completely different- some
Weekly Tips : Seamlessly collaborate with Share Drafts in Zoho Mail
Ever found yourself stuck wondering how to get input on an important email draft without actually sending it? Maybe you want a teammate’s feedback or approval from your manager—without exposing sensitive info. Or perhaps you are working across different
How to Share a workdrive folder outside organization ?
Hi, Earlier we were using Google Suite and were able to share the google drive folders with external organization ( Auditors , marketing collaterals ) as most of them had a personal gmail account they were able to access it without any issue. How can
Zoho CRM Account Duplication via Credit Application Form
Hi, We send a credit application link to our customers via email, which is managed through Zoho Campaigns. When a customer submits the form, it automatically creates a new account in Zoho CRM. We would like to know how to stop this from creating duplicate
Multi file upload
Hi, I just wonder if one could upload multiple files in one shot, say between one and three files, without adding multiple File Upload fields? Thanks, Alalbany
Flexible Milestone Invoicing
If your Zoho Projects portal is integrated with Zoho Invoice/Books, you can now create an invoice for your milestones. You can enable it under Integration Preference and invoice milestones regardless of the project's billing type. For instance, consider
The get records i am getting produts that show in the show in the sub form item list field
The get records i am getting produts that show in the show in the sub form item list field if(input.Department != null) { // Get filtered records once creator_ptid = zoho.creator.getRecords("harshadgroup","item-master","All_Products","Department == \""
Incorrect Handling of XLSX data
Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. format
Add Zoho Form Submission as Attachment to Zoho CRM Deal using Zoho Deal ID
Hi Zoho team, I have a Zoho Form in which one of the fields will be hidden but will be defaulted with the Zoho Deal ID. Once the form is submitted, I want to reattach the submitted form (and another uploaded file field) into Zoho CRM Deals record. The crazy part is that Deal Name and Stage are the only two fields available for mapping. I have the actual Deal ID. Why can't I just use that. Can you please fix it so that I can properly attach the submission using Zoho Deal ID instead of name/stage (which
Workdrive on Android - Gallery Photo Backups
Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma
Displaying related quotes in sales order and back
Hi, My colleague liked to see to which sales orders, the quote has been converted. Quote shows Invoices, but not SO. Same, they would like to see the quotes in the sales order, as they can see invoices, packages, shipment, How can we achieve this ? Thank
Payment link showing as malicious
We've had a few customers who have been unable to pay invoices as the payment link (the domain is zohosecurepay.eu) is showing as a malicious website in their browser. Could anyone help with this please?
Side bar menu
It would be great if you could stop the auto collapse of expanded menus when selecting a different module. It would save a lot of mouse clicks for a lot of users that frequently switch between sales & purchases as we do, it's easier to collapse them manually when not required !
Export Invoices to XML file
Namaste! ZOHO suite of Apps is awesome and we as Partner, would like to use and implement the app´s from the Financial suite like ZOHO Invoice, but, in Portugal, we can only use certified Invoice Software and for this reason, we need to develop/customize on top of ZOHO Invoice to create an XML file with specific information and after this, go to the government and certified the software. As soon as we have for example, ZOHO CRM integrated with ZOHO Invoice up and running, our business opportunities
Next Page