Making sub subcategory dependent on subcategory and category.

[sanjeevkalia]

Hi Folks,

I have a requirement of adding a new field on the change request form called "Sub Subcategory".

We already have "Category" and "Subcategory" fields on the change form and subcategory is dependent on category. This is OOB functionality.

Now this new filed "Sub Subcategory" should be dependent on Category.Subcategory. So basically the choice list for "Sub Subcategory" should refresh based on the value of "Category" and then the "Subcategory" both.

I am able to make this new field "Sub Subcategory" depend on "Subcategory" but it then ignores the value of Category that is selected.

How can this be achieved?

[Deepak Ingale1]

Hi Sanjeev

If you already have subcategory dependant on category then it should show up only when dependent category is chosen. Applicable for sub subcategory as welll. Could you pls provide some screen captures to get a idea of what is missing in ur case?

[sanjeevkalia]

Hi Deepak,

I am attaching 2 screenshots for you.

Sub Subcategory is only dependent on Subcategory, but I want it to be dependent on first Category and then Subcategory.

Thanks for looking in to this.

Regards,

Sanjeev

[Tanaji Patil · Accepted solution]

Hi Sanjeev,

You just need to make the sub-subcategory dependent on subcategory as you did in the screenshot.

If I am not understanding wrong, your subcategory depends on category and your sub-subcategory depend on subcategory.

category > subcategory > sub-subcategory

So depending on the selection in the category field your subcategory choices are displayed and based on the selection in subcategory your sub-subcategory choices will be available.

In short your sub-subcategory depends on both category as well as your subcategory.

If you want a choice to be displayed in the subcategory for two values in the category then create two choice records in subcategory for each value in category. Similarly with sub-subcategory field.

For e.g. lets take

Category - Category 1

                              Category 2

                              Category 3

Subcategory - Subcategory 1 (when Category 1 or Category 3 selected)

                                        Subcategory 2 (when Category 2 selected)

                                        Subcategory 3 (when Category 1 selected)

Sub-subcategory - Sub-subcategory 1 (when Category 1 and Subcategory 1 or Category 1 and Subcategory 3 selected)

                                                    Sub-subcategory 2 (When Category 2 and Subcategory 2 selected)

Now in the choice list of Subcategory field you need two records with Label 'Subcategory 1' but with different values (lets say values are Subcategory 11 and Subcategory 31), one for Category 1 and one for Category 3.

Again in the Sub-subcategory choice list you should have two records with label 'Sub-subcategory 1' but with different values, one should have dependent values as Subcategory 11 and another should have Subcategory 3(value of Subcategory 3).

I hope this helps you

Thanks,

Tanaji

[sanjeevkalia]

Thanks Tanaji. Works smoothly, but a lot of data entry.