AnsweredAssumed Answered

How do I filter  a dropdown list based on another field's value?

Question asked by Tony Appel on Jan 12, 2015
Latest reply on Jan 14, 2015 by Tony Appel
Working in sugar 6.5x soon to migrate to 7.5.

Need:  I have a multiselect dropdown list that I would like to filter in place based on a value selected in another field.

Example "long" drop down list:

XXX - Xyz Value
XXX - Xyza Value
YYY - Xyz Value
YYY - Xyza Value

Other field dropdown:


So, When a user selects XXX from the 'other' field I would like the 'long' list to only display values that begin with "XXX"

Is this possible with the formula builder? IF so, how?

Thanks in advance.