Your client has a list that they want to use as a lookup to pre-populate a text field with default data based on information from another field’s dropdown value.

In other words, we want to create a cascading dropdown, but instead of the second dropdown being dropdown, we want it to be a text field.

This post has been edited as a better solution to the problem has been found.

Create a calculated field with the formula:

setOfficeNumberControlValue(lookup("Location", "ID", LocationControl, "Phone"));

Then in your custom JavaScript, add the function:

function setOfficeNumberControlValue(value){
     NWF$('#'+OfficeNumberControl).val(value);
}

How does this work?

By including LocationControl (a list lookup control) in the Nintex Runtime lookup function, this calculated field will be run every time the value of LocationControl changes. This retrieves the value from the “Phone” column of the lookup list “Location” and passes the results into setOfficeNumberControlValue

It’s also worth noting that the above is clearly not production ready code. You should be testing for errors and you might want to generalize things a bit, this is merely a demonstration.

As mentioned, this post has been edited, below is the original post. I’ve left it here as reference only.

With a little setup, this is all the JQuery you’ll need to get this functionality.

NWF$(document).ready(function(){
NWF$('#'+LocationControlID).change(function(){
setTimeout( function(){
NWF$('#'+CityControlID).val(NWF$('#'+CityDefaultID).val());
},1000);
});
});

And here’s the little bit of setup required:

1. Create our initial List Lookup Control, just do this however you want the field set up. Be sure to name your control and in advanced settings, set Store Client ID in JavaScript variable name to Yes and set a variable name (in the example, this is our LocationControlID).
2. Create our text field, again, be sure to store the Client ID (CityControlID).
3. Crete a calculated field to actually get our information. Our Formula gets set to: lookup(“ListToLookup”,”ID”,LocationControl, “ColumnToRetrieve”). It’s important to note here that LocationControl is the name of the first control that we created, it might also be worth noting that the field that we’re filtering on is ID, not the displayed value of the lookup control (even if you’ve connected the text to a field). Now place this calculated field on top of the control that we would like to set the default for, and click the ‘Send to Back’ button. This will effectively hide the control. Note that hiding the control with a rule, or setting Visible:No will result in the calculated field not being calculated, and thus your information will not be retrieved. Once again, be sure to set the Client Side ID (CityDefualtID)

Now let’s go over the JQuery in more detail:

NWF$(document).ready(function(){
//on the LocationControl’s change event (this assumes LocationControl is a dropdown)
NWF$('#'+LocationControlID).change(function(){
//wait 1 second for our calculated field to retrieve the value from the list
setTimeout( function(){
//set the value of the control we want prepopulated to the value of the calculated field
NWF$('#'+CityControlID).val(NWF$('#'+CityDefaultID).val());
},1000);
});
});

It is also worth noting that the time that you should be waiting will depend on different factors, the lookup call has to return a value before we proceed, so play around with the number to find what works.

And that’s that, you’ve got a text field that works as a cascading drop down.

Cheers,

Anthony