Understanding Custom Field Limitations and Functionalities in Pipedrive
Custom fields are an essential feature in Pipedrive, allowing users to customize their CRM according to their requirements. To optimize their use, it's important to understand their limitations, constraints, and functionalities.
Key Limitations and Constraints for Custom Fields
Numeric Custom Fields
14-Digit Limit: Numeric custom fields in Pipedrive are restricted to a maximum of 14 digits. If your data exceeds this limit, it’s advisable to use a text field instead. ,
Long Text Fields
For text values exceeding 255 characters, use the 'Long Text' custom field type. This feature is designed specifically to handle longer texts efficiently.
Plan-Level Constraints
If you downgrade your Pipedrive plan and exceed the custom field limits allowed by the new plan, the affected fields will remain in your account but will not be editable until the excess fields are deleted. Importantly, no data in these fields will be lost during this time.
Using Custom Fields in Insights
Custom fields can play a critical role in creating reports:
Formula Fields in Reports: Number, money, and formula custom fields can be used in the "Measure by" section of your Insights reports. For example, if you’ve created a formula to calculate "Gross Margin" (e.g., deal value minus purchase costs from an integrated app), you can report on this field in Insights. Ensure your integrations are populating the necessary input fields for accurate reports.
Best Practices and Recommendations
For Numeric Constraints: Consider using text fields for longer numeric values to avoid hitting the 14-digit limitation.
For Data Management During Downgrade: To ensure data is not lost or inaccessible, plan carefully for any changes to your account tier. Delete unnecessary custom fields to comply with new plan limits if needed.
For Reporting Needs: Leverage formula and calculated fields in Insights for improved analysis and decision-making capabilities.
By understanding and effectively managing these limitations, users can make the most out of Pipedrive’s powerful custom field features while maintaining their CRM’s integrity.