How to auto populate location in REQ

[SN2024]

Hi, 

Can someone please advise how I can configure REQ form to populate location based on the "Requested for" user?

I have been able to create business rule to populate the location for the new requests but for the existing ones I can't figure out what I need to select in Form Builder under location to make it work.

I have tried dot walking in location, dependent field to the "Requested for" location but that didn't work.

Thank you for your help.

[Rafael Batistot]

Hi @SN2024 

Consider create an OnChange Client Script

• Table: sc_request
• Type: onChange
• Field name: requested_for
• script

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

// Get the location of the selected requested_for user
var ga = new GlideAjax('GetUserLocation');
ga.addParam('sysparm_name', 'getLocation');
ga.addParam('sysparm_user', newValue);
ga.getXMLAnswer(function(response) {
if (response) {
g_form.setValue('location', response);
}
});
}

Now Create the Script Include:

• Name: GetUserLocation

• Client Callable: (Check this!)

• Script:

var GetUserLocation = Class.create();
GetUserLocation.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getLocation: function() {
var userID = this.getParameter('sysparm_user');
var userGR = new GlideRecord('sys_user');
if (userGR.get(userID)) {
return userGR.location.toString();
}
return '';
}
});

[mattmm]

Have you considered running a simple background script 

var gr = new GlideRecord('sc_request');
gr.addNullQuery('location')       //Only where locaiton is currently empty
gr.query();

var count = 0;

while(gr.next()) {
    var user = new GlideRecrod('sys_user');
    if (user.get(gr.requested_for)) {
        if (user.location) {
            gr.location = user.location;
            gr.update();
            count++;
        }
    }
}

gs.print('Updated ' + count + ' sc_request records with location from requested_for user.');

[Prasanna_Patil]

Hi @SN2024 Try using onchange client script and script include for it..

[Shubham_Jain]

@SN2024 

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
g_form.getReference('requested_for', function(user) {
g_form.setValue('location', user.location); // use .location for reference field
});
}