Applying UpdOnlyIfNulls property in Constrain Pick List

To constrain the list of values of a picklist field (Eg: ‘Status’) based on another picklist (Eg: ‘Type’) field value of business component (Eg: ‘Contact’) in multi organization environment.

 

Normally, whenever a field value have to be constrained on another field, both the fields have to be mapped to hierarchical pick lists and pick maps will be configured so as to constrain the values. Following is alternate approach that can be followed using UpdOnlyIfNulls object definition of Pickmap

 

 

As Mentioned below, create new calculated fields which will have value based on Organization and ‘Type’ field value

 

 

 

Map the new hierarchical picklist to ‘Status’ field as follows:

 

Create following pick map for ‘Status’ field

 

Create following for pickmap ‘Type Calc’ created above

 

NOTE:‘UpdOnlyIfNulls’ is to disable the constraint when the constraining field value is null, using a calculated field as the field for the constraint pick map.

 

The list of values in Data Administration àList of Values setup can be made as below: