Is it possible to use List View in Nintex form to populate controls? I want to implement this functionality that when a user selects an item in the list view, the system populates a text box with information from the selected record.
Solved! Go to Solution.
What I mean is, for example look at this form:
I want when the user selects an item, it'll take the order_number from the list view and populate it in the form control.
I think that it is possible by using a calculated value. In the formula of this calculated value, you can use the lookup function to get the order number of the selected item. Then to display the result of the calculated value in your field, look at this :
To hide your calculated value, you can use a formatting rule which condition is : true.
Hope this helps
this is the formula: setmycontrol(lookup("ContractsList", "ID", order_number, "Order_number"))
where contractslist is the list title, ID is the column, order_number is the id value, order_number is the output i want to get from the list.
and this is the JS function:
NWF$('#' + myControlID).val(value);
Have you tried the formula without "setmycontrol" to test if it correctly shows the order number in the calculated value control ?
I run the lookup function without calling the JS script and I get no result, this is the function I used lookup("ContractsList", "ID", order_number, "Order_number") but when I set the order_number value manually it returns a result. I have ensured that I'm using the same data type as in the list.