I have created a form and need to populate a lookup field based on a previous selection.
This is the example.
I have a form that has client information. The client information form has 5 statements provided by the client.
In the evaluation form, we select the client from a lookup field. The next field needs to look up the 5 statement from the client information form based on the client that was selected.
I have used the following script with limited the success. My issue is while it does find the value, when the value is selected the field resets to blank instead of leaving the selected value.
net = Clients [ID == input.Client];
Select_Goal:ui.add(net.Goal_1.getall());
Select_Goal:ui.add(net.Goal_2.getall());
Select_Goal:ui.add(net.Goal_3.getall());
Select_Goal:ui.add(net.Goal_4.getall());
Select_Goal:ui.add(net.Goal_5.getall());
Select_Goal:ui.add(net.Goal_6.getall());
Select_Goal:ui.add(net.Goal_7.getall());
Select_Goal:ui.add(net.Goal_8.getall());
Select_Goal:ui.add(net.Goal_9.getall());
Select_Goal:ui.add(net.Goal_10.getall());