Governance, Risk, and Compliance (GRC)

 View Only

 Dependent picklists controlled by related object fields

Daniel Valle Contreras's profile image
Daniel Valle Contreras posted Mon April 21, 2025 01:04 PM

Hi team,

I'm implementing a solution with OpenPages 9.0.0.4, basically I want to either hide or show options from an enumerated string field, based on the selection in a field of a related object.

For instance,

assume I have two objects X and Y where X is parent of Y.

Both objects shares an enumerated multi/value string field called Type with the values A, B, C, ..., Z.

If a set the Type from X to [A, B] and then,

I associate X as parent of Y, I expect to see only [A, B] values available for Type in Y, instead I see the whole list from A to Z.

Is there a way I can achieve such kind of behavior?

Thanks in advance for the help.

Ian Sankey's profile image
Ian Sankey posted Mon May 12, 2025 08:46 AM

It is not possible to restrict the list of values that appear for the same eunmval field in object Y.  You could use a calculation to SET the same values on Y that are set in X, but then the field is not editable on Y.  I assume you want the user to be able to pick all or a subset of the values selected on X?

Another option would be to use a CALCULATION to set the values on the same ENUMVAL on Y, but add a view rule to not display this field on Y.  Add a second separate ENUMVAL field for object Y which has the same values as the other ENUMVAL, and setup a dependent picklist to only show the same values that are selected on calculated field.   This way, you only see the subset from X to choose from.

Related Content