What is the best way to deal with multi-tier dependent picklists?
Please note the below-stated considerations
I know that a controlling field can have values up to 300 and that if a field is both a dependent picklist and a controlling field, it will not be able to contain values more than 300 (where 1 and 3 are the issue).
Another thing is that the maximum picklist value is up to 1k only.
Solution workarounds are as follows:
I have heard of approaches used as they type VF page and Platform Cache to auto-complete or suggest, but this is way overkill. LWC..but it would not handle this many permutations. A custom metadata type approach links each custom metadata type to each other, but updating the picklist value changes all the time, which is not feasible. I thought of using a concat of all four picklist fields and implementing them in a custom object to validate against, which will be based on what they select for all four picklists. Still, the limitation is that the user will not be able to know whether they selected the correct combination or not.
Does anyone know how to deal with this?
You can represent these selections via data, which might be a much more straightforward approach. You can look up to each by creating an object for each level. By using Lookup Filters, you make sure that you are selecting children who correspond to the parent. Getting this approach to work with LWC will be of moderately low effort if you have any dev resources available; this much from experience.