Not able to cascade a picklist ( State & City )

[SnehaSahay]

Hi , I am a beginner and trying to work around "How to cascade a Picklist" but while doing so the below error is throwing : 

Casescenario :

Step 1 : 2 Picklist created ( State as Parent and City as Child with Picklist values )

Step 2 : Both the Picklist assigned to MDF object ( Business Unit ) 

Step 3 : While cascading Picklist the below error is reflecting , dont know why ?

Looking for support

[Cristian_Ocampo]

Hi @SnehaSahay,

Looks like you have to validate "field criteria" in the object definition for the city field. Please follow the steps provided in this KBA 2352794 - How to create cascading MDF picklists? 

If this information helped you, please, Accept as Solution.

Cristian Ocampo

[WaqasAnjum]

The error you're encountering seems to be related to the configuration of cascading picklists in your system. This type of error typically occurs when there is a mismatch or misconfiguration in the way the picklists are set up and referenced. Here’s a step-by-step guide to help you troubleshoot and resolve the issue:

Step-by-Step Troubleshooting

1. Verify Picklist Creation:

   • Ensure that both the 'State' (parent) and 'City' (child) picklists have been created correctly with all the necessary values.

2. Assign Picklists to MDF Object:

   • Confirm that the picklists are correctly assigned to the MDF object 'Business Unit'.
   • Check that the fields cust_state and cust_city are correctly configured to use the State and City picklists respectively.

3. Check Field Criteria:

   • The error indicates an issue with the field criteria configuration for cascading the picklists. Review the criteria to ensure they are correctly set up.

4. Review the Cascading Configuration:

   • Ensure that the cascading configuration is set up properly in the system. This typically involves specifying the source field (parent picklist) and the destination field (child picklist).
     

     Detailed Steps:

     Step 1: Verify Picklist Values

     • Go to the picklist management section and verify that the values for both 'State' and 'City' are correctly defined.

     Step 2: Assign Picklists to MDF Object

     • Navigate to the MDF object definition for 'Business Unit'.
     • Ensure that the cust_state field is configured to use the 'State' picklist and the cust_city field is configured to use the 'City' picklist.

     Step 3: Check Field Criteria

     • Review the field criteria setup for cascading picklists:
       • Ensure that the sourceFieldName is correctly specified as the field that contains the parent picklist values (in this case, it should be cust_state).
       • Ensure that the destinationFieldValue is correctly specified to match the child picklist field (in this case, cust_city).

   • Step 4: Configure Cascading Picklists

     • Go to the cascading picklist configuration section.
     • Add a new cascading rule if it’s not already created.
       • Set Source Field to the parent picklist field (cust_state).
       • Set Destination Field to the child picklist field (cust_city).
       • Map the parent picklist values to the corresponding child picklist values.

     • Example Configuration:

       Parent Picklist (State)

       Value Label

       CA	California
       TX	Texas

       Child Picklist (City)

       Value Label Parent Value (State)

       LA	Los Angeles	CA
       SF	San Francisco	CA
       ATX	Austin	TX
       DAL	Dallas	TX

   • Field Criteria Example:
     sourceFieldName: 'cust_state'
     destinationFieldValue: 'cust_city'
     defaultDestinationValue: ''

   • Common Pitfalls:

     • Incorrect Field Names: Double-check that the field names used in the cascading configuration match the actual field names in the MDF object.
     • Case Sensitivity: Ensure that the field names are case-sensitive and match exactly.
     • Picklist Value Mapping: Ensure that every parent picklist value has a corresponding child picklist value mapped correctly.

     By following these steps, you should be able to resolve the cascading picklist error. If the issue persists, please provide more details about your configuration, and I'll be happy to assist further.