Field type | Merge from module | Mark as mandatory | Show tool tip | Read only | Others |
Single line | Yes | Yes | Yes | If Merge from module is enabled | |
Multi-line | Yes | Yes | Yes | If Merge from module is enabled | |
Phone | Yes | Yes | Yes | If Merge from module is enabled | |
Number | Yes | Yes | Yes | If Merge from module is enabled | Maximum digits allowed |
Currency | Yes | Yes | Yes | If Merge from module is enabled | Maximum digits allowed, Number of decimal places, Rounding option |
Checkbox | Yes | Yes | Yes | Yes | Enable by Default |
Email | Yes | Yes | Yes | If Merge from module is enabled | |
Date | Yes | Yes | Yes | If Merge from module is enabled | |
Date/ Time | Yes | Yes | Yes | If Merge from module is enabled | |
Picklist | No | Yes | Yes | No | Picklist type (local or Global set) |
Multi-Select | No | Yes | Yes | No | |
User | No | Yes | Yes | No | |
File Upload | No | No | Yes | No | Upload multiple files |
Query Field Types | Maximum Limit |
Text Fields (Single Line, Email, Phone, Multi Line, URL, and Auto-Number) Multi-line maximum limit is 25 Auto-number maximum limit is 1 | 100 |
Number Fields (digits without decimal) | 40 |
Decimal, Percentage, Currency Fields | 60 |
Date Fields | 50 |
Date/Time Fields | 50 |
Checkbox | 80 |
Long Integer Fields | 35 |
Encrypted Fields (Encrypted field count is inclusive of Number and Text (Single Line, Email, URL, and Phone) fields) | 10 |
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.