Create location in cmn_location table, from Catalog item form.

[Dipika4]

Create location in cmn_location table, Whenever user will select others in the location field, new field will display to provide new location details like street, city, state, country, postal code. For this requirement I am using onSubmit catalog client script and script include but this is not working.

Client Script:

function onSubmit() {

   var obj = {

            "location": g_form.getValue("new_location"),

            "line": g_form.getValue("new_line1"),

            "tdaLocationCode": g_form.getValue("new_TDALocationCode"),

            "city": g_form.getValue("new_city"),

            "stateProvince": g_form.getValue("new_stateProvince"),

            "country": g_form.getValue("new_country"),

            "postalCode": g_form.getValue("new_postalCode")

        }

    var ga = new GlideAjax("UserOnboardingNonTGELocation");

    ga.addParam('sysparm_name', 'createLocation');

    ga.addParam('sysparm_location', JSON.stringify(obj));

    ga.getXML(getLocationDetails);

    function getLocationDetails(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        alert(answer.toString());

}

}

Script Include:

var UserOnboardingNonTGELocation = Class.create();

UserOnboardingNonTGELocation.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

createLocation: function(){

    var param = this.getParameter('sysparm_location');

    var newLoc = JSON.parse(param);

    gs.info("location "+newLoc.newline.toString()); //Even this log in not running.

    gs.info("location1 "+ newLoc);

        var newline = "";

        newline = newLoc.line.toString();;

        var newtdaLocation = "";

        newtdaLocation = newLoc.tdaLocationCode.toString();

        var newcity = "";

        newcity = newLoc.city.toString();

        var newstate = "";

        newstate = newLoc.stateProvince.toString();

        var newcountry = "";

        newcountry = newLoc.country.toString();

        var newcode = "";

        newcode = newLoc.postalCode.toString();

        var newlocation = "";

        newlocation = newline +", "+ newcity+ ", "+newstate;

var location_new = "";

        var grl = new GlideRecord('cmn_location');

        grl.initialize();

        grl.street = newline;

        grl.u_tda_location_code = newtdaLocation;

        grl.city = newcity;

        grl.state = newstate;

        grl.country = newcountry;

        grl.zip = newcode;

        grl.name = newline + ", " + newcity + ", " + newstate;

        location_new = grl.sys_id;

        grl.insert();

        return location_new;

},

    type: 'UserOnboardingNonTGELocation'

});

Kindly guide if anyone implemented something similar to this.

[AnveshKumar M]

Hi @Dipika4 

This request will not reach your Script Include as the form will submit immediately after the GlideAjax call.

Try the following catalog client script, whether the request reached the Client Callable Script Include or not.

function onSubmit() {
   var actionName = g_form.getActionName();
   var obj = {
            "location": g_form.getValue("new_location"),
            "line": g_form.getValue("new_line1"),
            "tdaLocationCode": g_form.getValue("new_TDALocationCode"),
            "city": g_form.getValue("new_city"),
            "stateProvince": g_form.getValue("new_stateProvince"),
            "country": g_form.getValue("new_country"),
            "postalCode": g_form.getValue("new_postalCode")
        }
    var ga = new GlideAjax("UserOnboardingNonTGELocation");
    ga.addParam('sysparm_name', 'createLocation');
    ga.addParam('sysparm_location', JSON.stringify(obj));
    ga.getXML(getLocationDetails);
    return false;

    function getLocationDetails(response) {
        var answer = response.responseXML.documentElement.getAttribute("answer");
        g_form.submit(actionName);
    }
}

Please mark my answer helpful and accept as a solution if it helped 👍✔️