in catalog form i need to autopopulate field like location, phone no etc.

[Gillerla Rajesh]

in catalog form i need to autopopulate field like location, phone no etc. i written script include and client script.

but it's not fetching value.

[Chetan Mahajan · Accepted solution]

Hello @Gillerla Rajesh ,

               try below code

Client Script :

// Client script for onChange on change of requestor 
function onChangeUser() {
    var requester = g_form.getControl('requester'); // Replace 'requester' with the actual  field name

    // Create a GlideAjax instance and specify the script include name
    var ga = new GlideAjax('CustomUserUtils'); // Replace 'CustomUserUtils' with your actual script include name
    ga.addParam('sysparm_name', 'getUserInfo'); // script include function name
    ga.addParam('sysparm_user', requester);
    ga.getXML(getResponse);
    
function getResponse(response) {
        var answer = response.responseXML.documentElement.getAttribute('answer');
        if (answer) {
            var userInfo = JSON.parse(answer);
            g_form.setValue('location_field', userInfo.location);
            g_form.setValue('phone_number_field', userInfo.phone_number);
        }
}

Script include : make sure it should be client callable

getUserInfo: function() {
        var userId = this.getParameter('sysparm_user');
        var userInfo = {};

        var userGR = new GlideRecord('sys_user');
        if (userGR.get(userId)) {
            userInfo.location = userGR.location.getDisplayValue();
            userInfo.phone_number = userGR.phone.getDisplayValue();
        }

        return JSON.stringify(userInfo);
    },

Kindly mark correct and helpful if applicable 

[Gillerla Rajesh]

    Can u tell me here 

userInfo.location = userGR.location.getDisplayValue();

      userInfo.phone_number = userGR.phone.getDisplayValue()

user info.loc, user info.phone_number is user defined one right like variable.

[Harish Bainsla]

Please refer this link and make modification as per your need .

https://www.servicenow.com/community/developer-forum/how-to-auto-populate-caller-email-and-caller-ph...

[Aman Kumar S]

Hi @Gillerla Rajesh ,

I think what Chetan suggested will work for you, there is one more approach which you can use which is the no code way, which is Catalog Data Lookup.

Please follow below link for the same:

https://www.servicenow.com/community/developer-articles/catalog-data-lookup-definition-on-any-table-...