How do I combine two single line fields using a formula field?

How do I combine two single line fields using a formula field?

You can use Zoho CRM formula fields to set up fields that can populate dynamically calculated data based on the values returned from other standard or custom fields. For example, you want to combine the First Name and Last Name fields in the Contacts module:

  1. Go to Setup > Customization > Modules and Fields and select the Contacts module.
  2. Click on the layout you want to use and drag and drop the formula field onto the layout editor.
  3. Enter the details as follows:Field label: Full Name
    Formula return type: String
  4. We use the 'concat' function to combine two string values. Insert the following expression: Concat(${RefContacts.First Name},' ',${RefContacts.Last Name})

    • Related Articles

    • Examples of Formula Field

      Formula Fields can be complicated sometimes. So, here are examples that will help you understand the usage of these types of fields in Zoho CRM. IF ELSE Statement Example: If field name contains 'Golf Only 1 Meal', then return 265 ; Else if field ...

    • Creating Formula Fields

      Formula fields are used to calculate different types of values, including numeric values, text values, date values, etc. Formula fields and their resulting return value have certain data types associated with them and there are specific operators ...

    • Concatenate two fields — (Combining two field values onto a third field)

      There are times when it is necessary to combine two separate field values into a single field. In such instances, we can concatenate two separate fields from the same module with the use of a custom function. For example, in one of the modules, we ...

    • Building Formula Fields

      The Zoho CRM formula fields enable you to define fields that can populate dynamically calculated data based on the values returned from other standard or custom fields. For instance, an insurance company may need to determine, if the provided date of ...

    • Functions in Formula Fields

      Function performs a specific operation on values that you specify and generates a new value. To compose a function, you need to type the function name, followed by a set of parentheses(). The Zoho CRM formula type custom field supports four different ...