fill fields in form from another table join by select box

 
1
0
-1

Hi, I am new in Joget, I am using Joget V7. community Edition.

I have 2 tables Equipments and WorkOrders, where WorkOrder's form has a select box field with choose form binder, it has all the EquipmentName, I can select, change it and work without problem. I need to get another information from the same Equipment table (customer and location), but really I can´t get this information.

Probably there are simples ways to do that but I can't do works, I have tried with hash variables in this way:

#form.Equipment.Customer[13545341284545435]# and it works, but when I try replace the ID field with something like that It doesn't work  #form.Equipment.Customer[{form.WorkOrder.SelectFieldUnitName}]#

Thank you so much for your help.


    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Maybe you can use JDBC Options Binder to populate the select box.

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

        Hi Matthew again, I can solved it, I am using other solution, but your help show me the way. I just created four select box and then when I select the UnitName select box, another boxes filled by cascade by ID, really I would like text fields but really I spent a lot of time trying to solve this, so I need continue and ASAP test your option or leave this one. 

        Thanks you so much.


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

          Hi Matthew, thanks for your answer, I will check and try. I will keep in touch

            CommentAdd your comment...