How can I auto populate 'street', 'city', 'state', 'zip' on a record producer from a referenced location?

Scott Raymond2 · ‎05-21-2020

I have a variable on a catalog item, 'location_name_ref', that is a reference to the cmn_location table. I have a single line text variable, 'site_address'. I believe an onChange script is needed to pull the 'street', 'city', 'state', 'zip' label display values from the 'location_name_ref' selection to the 'site_address' variable, but I'm not sure what that code looks like. We have something similar from a previous employee that pulls a user's email from a different reference variable to a single line text variable:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if(!isLoading && oldValue != newValue){

g_form.getReference('tech_contact_ref', getUserInfo);

}

function getUserInfo(userInfo){

g_form.setValue('technical_contact_email',userInfo.email);

}

For clarity, I would like to select ABC as the referenced location and have it auto populate the street, city, state, and zip from that location in another variable.

Community Alums · ‎05-21-2020

Hi Scott,

Try the below onChange client script on 'location_name_ref' variable.

function onChange(control, oldValue, newValue, isLoading) {
	if (isLoading) {
		return;
	}

	//Type appropriate comment here, and begin script below
	if(newValue == ''){
		g_form.clearValue('site_address');
	}else{
		var location = g_form.getReference('location_name_ref', callBack);
	}
}
function callBack(location){
	var site = location.street;
	var city = location.city;
	var state = location.state;
	var zip = location.zip;
	var address = site+"\n"+city+"\n"+state+"\n"+zip;
	
	g_form.setValue('site_address', address);
}

View solution in original post

Ankur Bawiskar · ‎05-22-2020

Hi Scott,

I agree with Mike's comment using GlideAjax is much more efficient than using getReference() with callback method

Please consider marking appropriate reply as ✅Correct & 👍Helpful.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Manasi4 · ‎02-22-2022

Hi I want the answer of below question If any state is selected then cities present in that state should be populated in city variable ?