Need help in onchange client script

[Shahida07]

I have location filed in form.When I am changing the location field it should check if that location has group in cmn_location table.if it has a group then I should get popup message like do not submit request.How to do this.

I tried this but it is not working

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

    if (isLoading ) {

        return;

    }

        var location = g_form.getDisplayValue('u_location');

        var gr=new GlideRecord('cmn_location');

        gr.addQuery('full_name',location);

        gr.query();

alert(location);

        if(gr.next())

        {

            alert('location');

            varGroup=gr.group;

            if(Group!='')

            {

                spModal.alert('Selected Location has group .');

            }

        }

}

[Maddysunil · Accepted solution]

@Shahida07 

Please below updated code:

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

    var location = g_form.getDisplayValue('u_location');
    var gr = new GlideRecord('cmn_location');
    gr.addQuery('full_name', location);
    gr.query();

    if (gr.next()) {
        var Group = gr.group; // Corrected variable name
        if (Group !== '') { // Check if group is not empty
        alert('Selected Location has group.'); // Corrected alert message
        }
    }
}

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks

[Sohail Khilji]

Hi @Shahida07 

You cannot use glide record in client script. You have to create a script include to check if the condition matches... And get the response back to client script and do the validation.

[Shahida07]

can you help me with the script please.

[Shahida07]

var LocationChecker = Class.create();

LocationChecker.prototype = {

    initialize: function() {

    },

    checkCoordinatorGroup :function(location)

    {

        var locationGr=new GlideRecord('cmn_location');

        locationGr.addQuery('name',location);

        locationGr.query();

        return true;

    },

    type: 'LocationChecker'

};

CS:

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

    if (isLoading) {

        return;

    }

    var location = g_form.getValue('u_location');

    var ga = new GlideAjax('LocationChecker');

    ga.addParam('sysparam_name', 'checkCoordinatorGroup');

    ga.addParam('location',location);

    ga.getXMLAnswer(function(response)

    {

     if(response=='true')

   {

    alert('test');

       }

        });

    }