Selectbox jdbc binder, How to include additional column values apart from text,value?

 
1
0
-1

Selectbox jdbc binder, How to include additional column values from external source apart from text,value?  

For eg. how do I pull customer address information along with id & name in the select box and populate the target form elements id, name & address?  

 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi, you can try using the AJAX Subform

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

        Hey there Suresh,

        A select box alone cannot hold more values than just the value and label for each selection.

        However, you can take advantage of "Dependency based on Grouping". You can find this setting by editing your selectboxes, going to Advanced Options, you will find the "Dependency" tab.

        With this useful setting, you can configure such where, by selecting a site, you can retrieve and populate all the necessary fields such as your address, city, state, and more.

        How this works is where after configuring your dependencies and grouping values, the dependent fields will read the value in your "Site" field (preferably a primary key or unique value to identify the correct row in your db), and populate accordingly.

        You can find more information about Select Box - dependency field here : Select Box

        Hope this helps!

          CommentAdd your comment...