Menu

Best way to build a 4-level dependent classification in Salesforce when Level 2 values repeat across Level 1?

Reading 0:00
15s threshold

Hey everyone,

I need some architectural advice on how to best implement a multi-level dependent selection on object.

Let me explain using a simple analogy (clothing):

Level 1 (Category): Pants , Dress , Shirt

Level 2 (Material): Leather , Linen , Polyester — These exact same values repeat under every single Level 1 category.

Level 3 (Model): Depends on the combination of both Level 1 and Level 2.

For example: Pants + Leather = Rave Pants , Leather Shorts .

Dress + Leather = Bodycon Leather Dress , Mini Leather Dress .

Level 4 (Issue / Reason): Depends on the specific model (or combination of Category + Material + Model).

Pants + Leather + Rave Pants = Broken Zipper , Cracked Leather , Missing Buckles .

Dress + Linen + Summer Dress = Shrunk After Wash , Torn Seam .

Since standard dependent picklists only look at the immediate parent (Level 3 only knows about "Leather", losing the context of whether "Pants" or "Dress" was selected at Level 1), I'm looking for the cleanest way to build…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.