Using Nintex Forms 2016 for SharePoint and SharePoint Server 2016.
I have custom list "Places" with columns Number, RefNumber, Contact, and others. Places contains many rows and needs to be added to occessionally. I want to have my form structured such that upon adding a row in Places automatically adds the new item to the choice dropdown.
I am using a form as a dashboard which displays column data based on which Place is selected.
What works (have to add new Place.Number to Choice dropdown manually):
Control - Choice | Location: values are copied from Places.Number and selected from a dropdown.
Control - Calculated Value | Display: lookup("Places","RefNumber",Location,"Contact")
Display correctly shows Contact for the selected Location.
What does not work (desire to have dropdown update when new Place is added):
Control - List Lookup | Location: column Places.Number selected from a dropdown.
Control - Calculated Value | Display: lookup("Places","RefNumber",Location,"Contact")
Display remains blank.
Can anyone shed some light on this for me?
Thank you.
have look on parseLookup() runtime function
lookup control evalutes to ID#;Value
the parseLookup() function picks either ID or Value out of it which you can then use as a value to filter by