New functions in formula builder in Zoho CRM

New functions in formula builder in Zoho CRM

Dear Customers,

We're happy to share some formula functions that will boost your application and bring a new level of functionality. Whether you're working with strings, dates, times, or numbers, these formula functions are designed to make your life easier.
Let's dive into some examples.​
​

​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.​
​

​Whats Next?​

  • Automatically recalculate formulas involving the Now() function
  • Support for formula fields inside other formula expressions
​
​To know more about the formula functions in Zoho CRM, click ​here​.​
​
​Thanks,​
​Zoho CRM Team​



      • Sticky Posts

      • Enrich your CRM data and keep them updated

        You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot.  For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing

      • New capabilities for custom buttons: Elevate UX and CX with just a click!

        Dear Customers, We hope you're well! We're happy to announce enhancements we've made to buttons. Buttons in Zoho CRM are a simple yet versatile customization tool. It offers great usability for CRM users, enabling them execute important actions as required.

      • Introducing Zia Presentation in Zoho CRM

        ----------------Moderation 3.0, Date: 10th May'24--------------------------------------- Zia's Presentation feature is now available for orgs in US, EU, IN, CN, JP, and AU DCs. Orgs., with Enterprise or Ultimate editions with 20+ user licenses can access

      • Zoho CRM Digest - February 2024

        We're thrilled to bring you the February digest, packed with exciting product updates and engaging discussions from the Zoho CRM Community. Keep reading to stay in the loop! Product Updates: Zia Enhancements Be it Tasks, Calls, or Meetings, Zia's activity

      • Canvas templates can now be shared with different CRM organizations

        ----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help