Automatically and dynamically select the 2nd drop box option based on the 1st drop box choice.

 
1
0
-1

Hi experts. How do I automatically select the 2nd drop box option based on the 1st drop box choice? 

I am currently trying to do dynamically change the option for drop box. I have since the videos in Youtube, however, most are based on the type → option. What i am trying to do is the version version which is option → type. For example

Drop box 1 : Apple, Strawberry, Lemon, Banana, Grape, Blueberry
Drop box 2 : Red, Yellow, Purple


When I select apple or strawberry then the 2nd drop box automatically select red. When I select Lemon, Banana then the 2nd drop box automatically select yellow. etc...


How do I do it? is there a possibility of multiple variables in the grouping section of Options (Hardcoded)??


Thank you in advance

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Build a separate form with 2 fields (fruit and color). Add all the required fruits and their colors in it. You may use list to see which one your already have. Using CRUD would be a good option.

      Now when you select the fruit Using selectbox in your new form, you can use Ajax subform to get the color that was stored against that fruit.

      For further details, read and understand ajax subform functionality.

        CommentAdd your comment...
      1.  
        2
        1
        0

        Store the colors against fruits in a table and use ajax subform to get the color based on the fruit selected. 

          CommentAdd your comment...
        1.  
          1
          0
          -1

          Hi Anas

          Can you clarify this sentence "Store the colors against fruits in a table"? How to do that?

          Sorry I am new to this app.

            CommentAdd your comment...