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
mhamberg1mhamberg1 

add picklist with thousands of values

We would like to create a multi-picklist "County" field with all of the counties found in the United States. Unfortunately that means that we would need to have about 3100 different values in our picklist .

I know that with multi-select picklists you can only have a maximum of 150 values.

 

Is there a way to store this information otherwise?

Is there a way around it using Apex or is the best way to do this to be forced into creating some kind of custom object solution?

 

any help would be appreciated.

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

3100 values - can you imagine having to scroll through that picklist? I suggest a custom object and use a lookup field. This way you have an easy way to search the counties and a better user experience.

 

Hope that helps,

Sati

All Answers

shillyershillyer

3100 values - can you imagine having to scroll through that picklist? I suggest a custom object and use a lookup field. This way you have an easy way to search the counties and a better user experience.

 

Hope that helps,

Sati

This was selected as the best answer
vikmacvikmac

Hey

 

With that, can we select more than 1 value from lookup. I think NO.

 

Is there any alternative for this ?