Refresh values of Child drop-down based on Parent drop-down fields

👨‍💻 Development Help
1

Hi all,

I have designed a parent drop-down, and two child drop-down field.

Field A is parent, field B is child of A and field C child of B.
I have succesfully selected values based on the dependecies among them but i have an issue regarding “refresh” of child’s values.

For example:

  • Field A has 3 values

    • New  New
    • InProgress  In Progess
    • Completed  Completed

  • Field B has 4 values

    • New_000  n/a
    • InProgress_001  Action1
    • InProgress_002  Action2
    • Completed_000  n/a

  • Field C has 4 values

    • New_000_000  n/a
    • InProgress_001_Success  Success
    • InProgress_001_NonSuccess  Non Success
    • InProgress_002_Success  Valid
    • InProgress_002_NonSuccess  Invalid
    • Completed_000_000  n/a

So, I proceed on this:

  • Select value ‘InProgress’ on field A

  • Field B displays values based on value ‘InProgress’ of field A
     Action1
     Action2

  • Select value ‘Action1’ on field B

  • Field C displays values based on value ‘Action1’ of field B
     Success
     Non Success

That works perfect. But, if i changed my selection on field A (for example) to ‘New’ the child dropdowns are still indicating the values of the previous selection i.e. fields don’t change values according to my new selection.

Is there any “trigger” to do that ? Any suggestion ?

Thank you in advance.

Ars

2

Please post:

  1. image with definition of each dropdown (take the image from the dropdown editor)
  2. image with the definition of each field (takethe image from Studio)
3

Hi amariussi,

Please find attached the requested images.
I hope to manage find out a solution !!!

Regards,

Ars

4

Please check these two forum posts to learn how to use dynamic dropdowns:

https://suitecrm.com/forum/suitecrm-7-0-discussion/9222-dynamic-dropdown-creation#32672

https://suitecrm.com/forum/suitecrm-7-0-discussion/2694-conditional-dropdown-list-s-options-help#10746

5

Hi,

Nice but I have already read them.
So, it seems that the screenshots you asked were unnecessary !!!

In any case thank you for your reply.

6

The screenshots were useful to see what you have done.

In the past I remember having a problem whereas slave dropdowns wouldn’t be updated automatically. I have searched my notes but couldn’t find the solution. I will continue searching tomorrow, and if I find something I will post it.