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.
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 :
Re: Using Nintex Form Runtime Lookup Function to populate a textbox
To hide your calculated value, you can use a formatting rule which condition is : true.
Hope this helps
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 have tried it however, it doesn't recognize my control's ID. It says its undefined? although I've set it.
Can you give me more details ?
Which formula have you populated in the calculated value ?
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 ?
yes, now after I did that, it shows and disappears the calculated value. also, the lookup control value resets.
It disappears? That's strange.
When it shows something, does it show the expected value in the "order_number" 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.
The problem was in retrieving value from the lookup control without using parselookup function. It's all good now.
Might be a silly question but how did you retrieve the selected value of the listview control?
I've used JS
Do you perhaps have the code you used to retrieve the selected value in a list view?
I am trying to achieve the same functionality as Shaika but unfortunately I can't seem to find some of the things mentioned above.
Don't hesitate if you need more help, my explanations may be confused...
Thanks for your speedy reply Caroline.
I do understand what you are saying as i have implemented the similar functionality using visual studio in the past.
Do you perhaps have a link to an article where someone has done something similar in the past to help speed development on my side.
Unfortunately, i don't know any article that deals with something similar...
Thanks in advance.
PS: I've also voted for multiple filtering of the List Lookup control. A variation would be to also be able to specify a CAML Query based on control values on the form.
Sorry for the delay.
Have you been able to do it?
No problem Caroline,
Great, thanks for your feedback !
Retrieving data ...