Get Reference of a record from look up select box

[Gokul Nath]

Hi All,

I have a requirement, of finding the reference record selected in other field and populating into a reference field

Field 1 type: Lookup Select Box

Field 2 Type: Reference

Both have same tables configured,

when i select a record in field 1, the reference record should be populated in the second field which is not happening, please help with your suggestions

[Mohan raj · Accepted solution]

Hi @Gokul Nath ,

To populate the record in reference field based on lookup select table like this

by using on change client script:

field name : field 1

script :

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

   //Type appropriate comment here, and begin script below
	var field1 = g_form.getValue('field_1');
	g_form.setValue('field_2',field1);
   
}

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.

Regards,

Mohan.

[Mohan raj · Accepted solution]

Hi @Gokul Nath ,

To populate the record in reference field based on lookup select table like this

by using on change client script:

field name : field 1

script :

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

   //Type appropriate comment here, and begin script below
	var field1 = g_form.getValue('field_1');
	g_form.setValue('field_2',field1);
   
}

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.

Regards,

Mohan.

[Gokul Nath]

Hello @Mohan raj 

Thanks for the response, but unfortunately, it doesn't seem to work for me.

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

   //Type appropriate comment here, and begin script below
	var field1 = g_form.getValue('please_indicate_the_ticket_number_related_to_this_request');
	g_form.setValue('please_indicate_the_ticket_number_related_to_this_request_v1',field1);
   
}

Alert is bringing up the case number

But the field is not setting the value as you get it

[Gokul Nath]

Hello @Mohan raj 
Your script worked on making few configuration change to look up field, Thanks for the time

[Pavankumar_1 · Accepted solution]

Hi @Gokul Nath  ,

You can achieve it through only onchange catalog client script or client script +script include.

1. Onchange Client Script

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    g_form.setValue('variable_2_for_case', g_form.getValue('variable_1_for_case')); //add your variables
}

or you can try below option aswell

2. You can achieve it through client script + script include.

client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var ga = new GlideAjax('getCaseValue'); //script include name
    ga.addParam('sysparm_name', 'getDetails'); //function name
    ga.addParam('case_number', newValue); //passing value to server
    ga.getXMLAnswer(setdetails); //callback funtion
    function setdetails(response) {
        g_form.setValue('variable_2_for_case', response);//add your reference variable name
    }

}

Script Include: Make client cabble is true.

var getCaseValue = Class.create();
getCaseValue.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getDetails: function() {
        var num = this.getParameter('case_number');
        var grCase = new GlideRecord("sn_customerservice_case");
        grCase.addQuery("number", num);
        grCase.query();
        if (grCase.next()) {
            return grCase.sys_id.toString();
        }
    },
    type: 'getCaseValue'
});