AJX script to Auto Populate UserID

[Annette Kitzmil]

Hello,

I have a requirement to auto fill the user fields based on a reference field on our table.  I am still missing something because it shows the answer of Null and I am not see why.  Below are my two scripts.

AJAX / Script Include:

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

if (isLoading || newValue === '') {

        return;

    }

    var ga = new GlideAjax('clientUtilsCustom');

      ga.addParam('sysparm_name', 'getUserLanID');//this calls the AJAX script

      //ga.addParam('sysparm_LanID', '');//this would be for the user_name which is the LanID

      ga.getXML(getResp);

}

function getResp(response) {

    alert(response.responseXML.documentElement.getAttribute("answer"));

    g_form.setValue('user_id',response.responseXML.documentElement.getAttribute("answer"));

}

Client Script:

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

if (isLoading || newValue === '') {

        return;

    }

    var ga = new GlideAjax('clientUtilsCustom');

      ga.addParam('sysparm_name', 'getUserLanID');//this calls the AJAX script

      //ga.addParam('sysparm_LanID', '');//this would be for the user_name which is the LanID

      ga.getXML(getResp);

}

Thank you for any assistance on this.

function getResp(response) {

    alert(response.responseXML.documentElement.getAttribute("answer"));

    g_form.setValue('user_id',response.responseXML.documentElement.getAttribute("answer"));

}

[Sandeep Rajput]

@Annette Kitzmil Instead of posting the script include code, you posted client script twice. Can you provide the code of script include. 

[Annette Kitzmil]

My apologies...

getUserLanID: function() {

        var LanID = this.getParameter('sysparm_LanID');

        LanID = gs.getUser().getRecord().getValue('user_name');

        var openedBy = new GlideRecord('sys_user');

        openedBy.addQuery('user_id', LanID);

        openedBy.query();

        if (openedBy.next())

            gs.addInfoMessage('AK: ' + LanID);

        return LanID;

    },

[Ranjit Nimbalka]

Hi @Annette Kitzmil ,

Please try below code:-

Server side code

getUserLanID: function() {
        var LanID = this.getParameter('LanID');
        var openedBy = new GlideRecord('sys_user');
        openedBy.addQuery('user_id', LanID);
        openedBy.query();
        if (openedBy.next())     
        return (JSON.stringify(openedBy);
    },

  client side code:-

function onLoad(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
        return;
    }
   
    var ga = new GlideAjax('clientUtilsCustom');
      ga.addParam('sysparm_name', 'getUserLanID');//this calls the AJAX script
      ga.addParam('sysparm_LanID', '');//this would be for the user_name which is the LanID
      ga.getXML(getResp);
 
}
function getResp(response) {
    var answer=response.responseXML.documentElement.getAttribute("answer"));
      answer= JSON.parse(answer);
    g_Form.setValue('name', answer.name)
   
}

Regards,

Ranjit

[Annette Kitzmil]

Very close, now I get this: