{"id":5790,"date":"2023-12-28T03:30:39","date_gmt":"2023-12-28T03:30:39","guid":{"rendered":"https:\/\/tst-blog.myenterprise.in\/?p=5790"},"modified":"2025-01-13T09:56:45","modified_gmt":"2025-01-13T09:56:45","slug":"add-custom-field-in-the-subpanel-from-relationship-table","status":"publish","type":"post","link":"https:\/\/www.bhea.com\/blog\/add-custom-field-in-the-subpanel-from-relationship-table\/","title":{"rendered":"SugarCRM Customization: A Step-by-Step Guide to Create A Custom Field in The Relationship Table"},"content":{"rendered":"\n

This blog is intended for SugarCRM developers aiming to create a custom field in the subpanel from the relationship table. Let\u2019s explore the significance of customization in SugarCRM. When certain requirements cannot be met through personalization or configuration within Sugar, code-level customization becomes essential. Such customizations may involve expanding the out-of-the-box functionality by extending the SugarCRM code or integrating SugarCRM with third-party applications using RestFul API services. <\/p>\n\n\n\n

The people who are new to SugarCRM first they should go through the end user guide<\/a>, admin guide<\/a> and then only they can learn the SugarCRM custom development because it requires some understanding about how the application works and what and all the default features are available and how the SugarCRM can be personalized and configured by using Sugar default developer tools.<\/p>\n\n\n\n

Now let us understand what is the importance of this blog. We all know that we have the Many to Many relationship from Opportunities to Contacts by default in Sugar. So one Contact can have multiple Opportunities and similarly one Opportunity can be associated with multiple contacts. So let us see an example how the role field in the subpanel plays a vital role here.<\/p>\n\n\n\n

We all know that we have the Many to Many relationship from Opportunities to Contacts by default in Sugar. So one Contact can have multiple Opportunities and similarly, one Opportunity can have multiple contacts.
So let us see an example how the role field in the subpanel plays a vital role here.<\/p>\n\n\n\n

\n\t<\/div>\n\n\n\n
\n\n\n\n

How does the Contacts Role Field under Opportunities play a significant role in SugarCRM?<\/h3>\n\n\n\n

In SugarCRM, each Opportunity can be related to one or more contacts that are displayed in the subpanel on the Opportunities record view. The Contacts subpanel allows users to select an opportunity-specific role (e.g. Primary Decision Maker, Business Evaluator, etc.). Based on the role of the contact, will help us to decide how the individual contact will be the factor into the buying decision for the current Opportunity.<\/p>\n\n\n

\n
\"SugarCRM<\/figure>\n<\/div>\n\n\n

The same contact can be linked to multiple Opportunities and can have different roles for each specific opportunity. In this case we cannot create the field in the studio in the Contact. This role field should be only for Opportunity Subpanel.<\/p>\n\n\n\n

Let us take an example how it works in real time. For instance, Person A might be the Technical Evaluator for Project ABC and the Primary Decision Maker for Project XYZ. This shows how one person handles different jobs in various projects. The role field custom development allows us to record and distinguish these varied roles across different projects. By using this field, we can easily identify and manage the diverse roles a person plays in various projects.<\/p>\n\n\n\n

Creating Custom Subpanel Fields Through Customization for Many-to-Many Relationships in SugarCRM<\/h3>\n\n\n\n

This blog will guide you through creating a custom dropdown field in the Members subpanel under the Meetings Module. Imagine a scenario where there\u2019s a Many-to-Many relationship between Meetings and Members \u2013 meaning multiple members can attend various meetings, and each meeting can have multiple attendees.<\/p>\n\n\n\n

The \u2018role\u2019 field here serves as a useful indicator to mark whether a member attended a specific meeting or not. When we establish a Many-to-Many relationship between these modules, SugarCRM automatically generates metadata and relationship files in both modules\u2019 vardefs.<\/p>\n\n\n\n

However, since this field is part of a relationship, you can\u2019t create it using tools like Studio or Module Builder. This has to be done through custom code development only. Adding small code snippets into specific files will help achieve this customization as mentioned in the below steps.<\/p>\n\n\n\n

Adding the field in the Subpanel Module<\/h4>\n\n\n\n

To display the field in the subpanel, we need to add it to the metadata file. Follow these steps:<\/p>\n\n\n\n