Zoho CRM: New functions in formula builder

Zoho CRM: New functions in formula builder

​String Formula​

CaseInsensitiveEquals​
  • Description: Compares two strings in a case-insensitive manner.
  • Example: CaseInsensitiveEquals('asdf', 'AsDf') returns true​
Example:​
​Imagine you have a database with contact information where entries may differ in capitalization. Using the CaseInsensitiveEquals function, you can check if the primary email addresses and the secondary email addresses are one and the same or equal​
​

IsEmpty​
  • Description: Checks whether the value is empty or not.
  • Example: IsEmpty('') returns true
Example:​
​A sales team capturing leads and opportunities in Zoho CRM can use the IsEmpty function to ensure that the "Lead Source" field is populated for each lead to track the effectiveness of marketing campaigns accurately. The IsEmpty function identifies records with missing information, enabling proactive data management practices.​
​

DateBetween​
  • Description: Returns the time between two dates.
  • Example: DateBetween(Newdate(2022,02,10,11,30,'AM'), Newdate(2023,02,19,11,30,'AM'),'years') returns 1
​​Example:​
​By applying the DateBetween function with two fields, that is, the subscription date field and the renewal date field, you can determine a user's subscription duration.​
​

​DateTime Formula Functions​

Dayofweek​
  • Description: Returns the day of the week for the given date.
  • Example: Dayofweek(April 5th 2023) returns "Wednesday"
Example:​
​You can use the Dayofweek function to get the weekday data of a field, like, Due Date. . Once you have the weekday information, you can schedule reminders accordingly.​


Dayofmonth​
  • Description: Returns the number corresponding to the day of the month for the given date.
  • Example: Dayofmonth(April 5th) returns '5'
​Example:​
​By using the Dayofmonth function, the marketing team can schedule promotional emails, social media posts, and in-store events based on the day of the month to align with customer purchasing behaviors and maximize campaign effectiveness.​


Dayofyear​
  • Description: Returns the number corresponding to the day of the year for the given date.
  • Example: Dayofyear(April 5th 2023) returns "95"
​
Example:​
​A marketing team organizing an annual conference can schedule the conference date, plan pre-event promotions, and track registrations and attendee engagement throughout the planning process leveraging the Dayofyear function.​


FromTimestamp​
  • ​Description: Creates date time from timestamp.​
  • ​Example: FromTimestamp(1581066895) returns Feb 7, 2020 02:44 PM
​Example:​
A retail company using the FromTimestamp function can leverage the FromTimestamp function in Zoho CRM to convert timestamps from order creation and shipment notifications into date-time formats, facilitating accurate order tracking and timely delivery management.

​Numeric Formula Functions​

IsPositive​
  • Description: Checks if the number is positive.
  • Example: IsPositive(-345) returns false
​Example:​
​A sales team within a company is achieving quarterly sales targets and increasing revenue generation across product lines. The sales manager using the IsPositive function can analyze sales metrics, assess sales team performance, and monitor revenue trends by determining whether sales figures meet predefined positive criteria​


IsNegative​
  • Description: Checks if the number is negative.
  • Example: IsNegative(-345) returns true
Example:​
​Using the IsNegative function, a finance department can monitor negative expense reports, identify negative expense values indicating refunds or credits, and analyze spending patterns to control costs.​
​

Round​
  • Description: Rounds the number to the nearest value based on the specified precision.
  • Example: Round(3.8) returns 4
​Leveraging the Round function in Zoho CRM enables organizations to round pricing values, revenue projections, and financial metrics to the nearest specified precision, facilitating precise calculations and strategic planning.​

    • Related Articles

    • Zoho CRM: The Canvas Record Form for Enhanced Customization

      Zoho announced Zoho Crm innovation with Canvas functionality now extends to record forms, enabling you to personalize record entries with the power of Canvas! Enhancing CRM Interactions with CanvasIn the heart of any CRM lies the ability to manage ...

    • Zoho CRM: New Assignment Rules

      Zoho CRM is introducing a new feature to make assignment rules even more flexible and powerful. Administrators can now automate the assignment of records based on specific criteria. These criteria can be related to the fields in the record or the ...

    • Zoho CRM : Compliance Made Easy for Email Authentication

      We are introducing you with significant updates to enhance email authentication and verification processes across Zoho CRM and other Zoho services. These changes aim to bolster security, ensure compliance with industry standards, and improve user ...

    • Zoho CRM: Global Sets

      Hello all, We are thrilled to announce Global picklists, a much awaited feature for CRM Admins! As administrators who implement and manage CRM solutions, you may have dealt with picklists that are present across multiple modules and have the same ...

    • Zoho CRM: Introducing Rollup summary

      Hello All, We hope you're well! We're here with an exciting update that goes right into CRM's core capabilities. It's called the Rollup summary. Let's go! Your CRM is a vast database with well-connected data sources, where you can access both the ...