Ryan Siwinski

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

Discussion created by Ryan Siwinski on Jan 9, 2020
Latest reply on Jan 28, 2020 by Chris Raffle

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