function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
swaarnimswaarnim 

Workaround for controlling field with more than 300 values

Problem:

The maximum number of values allowed in a controlling field is 300. In addition, if a field is both a controlling field and dependent picklist, it can't contain more than 300 values.

 

Use case:

We are using "City" as a custom pick list field. it is controlled by "States" custom pick-list field Now we have another custom pick list field of "Pin codes/Zip codes". These should be controlled by "City". But the limitation of 300 values of controlling field wont allow us since the city values are over 700 and could grow further.

 

What is the work around, is there any provision of asking for additional value limit to Salesforce

 

Thank You

Aaron@MeginfoAaron@Meginfo

I doubt Salesforce can raise the limit to the level that meets your requirement, you may have to consider VF component + Apex/Ajax.

swaarnimswaarnim

Please can you guide me on the Apex code where the resulting filed is a multi select pick list contolled by this city picklist.

Also please guide on VF.

 

City is an picklist controlled by state with 700 values.

 

Pincode is a multiselect picklist. it has been added with some values and will be added on a regular basis as the network of operations increase for the customer.

 

now we need to develop relationship between the two such that the city becomes controlling for pincodes.