fill fields in form from another table join by select box
Confluence User - 03 Nov, 2022
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.
forms;selectbox