How to create a field that returns a specified value based on a related field in Sugar CRM?

Here is my situation:

I currently have the following setup in my record view on one of my modules (lets call it Estate_Orders for the sake of this post)

My Goal is to be able to make the "Joint Venture" field related to the "Office Number" field. Every record has a different office number and a corresponding Joint Venture name. These two fields are directly correlated.

For example: Office Number: 841 is equal to Joint Venture: Real Estate Corp, LLC

My Issue is that I am unsure of how to create this formula in the Sugar Studio. Clearly I am very new at this and would appreciate any and all guidance on how to best implement this!!

Have a wonderful 2020

-Ryan

Parents

0 Patrick McQueen over 4 years ago

Hi Ryan Siwinski,
Please review this article and let us know if it helps.
https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Sugar_Logic/Sugar_Logic_Walkthrough_Related_Module…
EDIT: Chris Raffle's answer below addresses the specific nature of the "based on another field value," which I recognize as a fundamental detail in the question. His is, in my opinion, the right answer. Using the dropdown in that way, you can essentially create a switch.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Patrick McQueen over 4 years ago

Hi Ryan Siwinski,
Please review this article and let us know if it helps.
https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Sugar_Logic/Sugar_Logic_Walkthrough_Related_Module…
EDIT: Chris Raffle's answer below addresses the specific nature of the "based on another field value," which I recognize as a fundamental detail in the question. His is, in my opinion, the right answer. Using the dropdown in that way, you can essentially create a switch.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data