Data Types in Zoho CRM

In Zoho CRM modules, a variety of field types are available, enabling you to collect and manage a broad spectrum of customer data. Here's a quick reference summarizing the common data types:

• text : Used for short text entries like names, addresses, or short descriptions, the text field is a string type field that can store up to 255 characters, including alphanumeric characters and special characters.
  
• textarea (multiline) : Used for longer text entries, the multiline field in Zoho CRM is a string field that supports alphanumeric and special characters up to 32000 characters, making it suitable for storing extensive content such as terms and conditions or detailed descriptions.
  
• email : Used to store email addresses, ensuring proper format and validation.
  
• phone : Used to store valid phone numbers with up to 30 characters, ensuring proper format and validation.
  
• picklist : Lets you choose a value from a set of predefined options, accepting all alphanumeric and special characters
  
• multiselectpicklist : Allows you to select multiple valuesfor the field, accepting all alphanumeric and special characters.
  
• date :  This field accepts date in yyyy-MM-dd format.
  
• datetime : This field accepts both date and time information in yyyy-MM-ddTHH:mm:ss±HH:mm format.
  
• integer (number) : This field is a 32-bit signed integer that accepts up to 9 digits.
• currency : Used for amount fields, this field is stored as a 64 bit signed floating point, and accepts up to 16 digits. Refer here for more details on the available rounding options.
  
• double : Used for decimal numbers, useful for number and calculations requiring precision, this field is stored as a 64-bit signed floating-point.
• percent : Used for percentage values and accepts up to 5 characters, including the sign and decimal point.
• bigint (long integer) : This field is a 64-bit signed integer, that accepts up to 18 digits.
• boolean (checkbox) : Used for boolean values, ie, true/false.
  
• website (URL) : Accepts valid URLs with alphanumeric characters, up to 450 characters in length.
  
• lookup : Used to create a relationship between records. In our APIs, this field will be represented as a JSON Object containing the id and the display label.
• multiselectlookup : This field allows you to create a many-to-many relationship between two modules in Zoho CRM. When you use a multiselectlookup field, linked records are stored in a separate module with lookup fields that reference the two related modules.
• userlookup :  Used to establish a lookup to the user module. In our APIs, this field is represented as a JSON Object containing the id and the display label.  The linked records are stored in a separate module, containing lookup fields for the two related modules.
• ownerlookup : Used to identify and assign the record's ownership to a specific user within the organization.
  
• multi_user_lookup : Allows association of multiple users to a module record.
• subform : A secondary form or table that enables you to add multiple line items to a primary form or record.  A separate module will be automatically created for the subform, with a lookup pointing to the parent module.
• imageupload : Used to associate images with a record.
  
• fileupload : Used to associate files with a record.
  
• multi_module_lookup : Used to establish lookup relationships with more than one module.

Leveraging Samples from the Zoho CRM GitHub Repository

Assigning Values to Different Field Types using Zoho CRM SDKs

Assigning values to Custom Fields:

---

Previous Post : How to navigate to another page using Client Script | Kaizen Collection : Home