Dependent Field- Display Based on two separate list values?

Question

The following documentation shows a user how to create a dependent field based on a list value, which is incredibly helpful!

http://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Sugar_Logic/Dependent_Field__Display_Based_on_List_…

For our use case, we need the field to be dependent on two different list values. Values one "Relationship Type" = Current Client and "Industry" = Lender. If both are true, I want the field to appear.

Is it possible to write a formula to fulfill this need?

Thank you!

Kayla Ebert · Accepted Answer

Hi Kayla Ebert , I am happy to read that you found my article incredibly helpful. Dependent fields appear when the function/formula returns true. The and() function returns true when all embedded functions/variables return true. Therefore, design the formula for each field separately, then embed them both in an and() formula like: and(isInList($field1,createList (" Value1 "," Value2 ") ),isInList($field2,createList("Value1","Value2"))) The above spelled out in a different way, just in case the comma separator is hard to identify in the above example: and(x,y) where x = isInList($ field1 ,createList (" Value1 "," Value2 ") ) and y = isInList($ field2 ,createList(" Value1 "," Value2 ")) I hope this is helpful, too!