Need to Populate Date based on selection of the show Name

[e__rajesh_badam]

Hi ,

In Incident form Show Impacted (reference field ) and Show Start Date are two columns and These two columns are part of one Table only.

When I select the Show Name in show impacted column then it need to display related Show Date in Show Start Date field.

Instead it is showing value as undefined when selecting particular show name even after it has the date.

Please provide suggestions.

Script:

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

   var userObject = g_form.getReference('u_show_impacted', doAlert); // doAlert is our callback function

}

function doAlert(userObject) { //reference is passed into callback as first arguments

   g_form.setValue('u_show_start_date', userObject.u_show_start_date);

}

[J Siva · Accepted solution]

Hi @e__rajesh_badam 

Try below script.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }
    var userObject= g_form.getReference("u_show_impacted", doAlert);


    function doAlert(userObject) {
        
        g_form.setValue('u_show_start_date', userObject.getValue('u_start_date')); //Make sure to use the correct field name
        
    }
}

NOTE: While setting the date value you are not picking the correct field name. Check that. Also please share the snap of your onchange client script configuration.

As per my script, you onchange client script should be configured on "Show impacted" field and UI type should be "All"

Regards ,

Siva

[Ankur Bawiskar · Accepted solution]

@e__rajesh_badam 

you should have script when value changes so do this and not when form loads

Ensure all field names are correct

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading) {
        return;
    }

    if (newValue == '')
        g_form.clearValue('u_show_start_date');

    if (oldValue != newValue)
        var userObject = g_form.getReference("u_show_impacted", doAlert);

    function doAlert(userObject) {
        g_form.setValue('u_show_start_date', userObject.getValue('u_start_date'));
    }
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@e__rajesh_badam 

Please debug if script include is getting called, what came in alert in client side?

share your both the scripts

[e__rajesh_badam]

Hi @Ankur Bawiskar ,
No alerts are populating.

Here is the scripts

Client Script:

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

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

        return;

    }

    var ajax = new GlideAjax('Dtetimeutils');

    ajax.addParam('sysparm_name', 'getDateValue');

    ajax.addParam('sysparm_inc', newValue);

    ajax.getXML(getDate);

    function getDate(response) {

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

        alert('date is' + userObject.u_show_start_date);

        g_form.setValue('u_show_start_date', answer);

        alert('answer');

    }

}
Script Include (client callable)

var Dtetimeutils = Class.create();

Dtetimeutils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

 getDateValue: function() {

        var sysId = this.getParameter('sysparm_sysid');

        var rec = new GlideRecord('u_show_impacted');

        if (rec.get(sysId)) {

            return rec.u_start_date.getDisplayValue();

        }

    },

    type: 'Dtetimeutils'

});

[Ankur Bawiskar]

@e__rajesh_badam 

did you add gs.info() in script include and see if the function was called?

script include and client script are in same scope?

I believe I already answered your question, please debug further and enhance if any changes required

If my response helped please mark it correct and close the thread so that it benefits future readers.

[e__rajesh_badam · Accepted solution]

Hi @Ankur Bawiskar ,

Thank you so much for your quick assistance and I achieved it with your initial code itself by adding date format conditions (bold and Underlined).

Here is the Script for reference

Client Script:

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

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

        return;

    }

    var userObject = g_form.getReference('u_show_impacted', updateShowStartDate);

    function updateShowStartDate(userObject) {

        // g_form.setValue('u_show_start_date', userObject.getValue('u_start_date'));

        var startDate = new Date(userObject.getValue('u_start_date'));

        var show_start_date = formatDate(startDate, g_user_date_format);

        g_form.setValue('u_show_start_date', show_start_date);

    }

}

[J Siva · Accepted solution]

Hi @e__rajesh_badam 

Try below script.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }
    var userObject= g_form.getReference("u_show_impacted", doAlert);


    function doAlert(userObject) {
        
        g_form.setValue('u_show_start_date', userObject.getValue('u_start_date')); //Make sure to use the correct field name
        
    }
}

NOTE: While setting the date value you are not picking the correct field name. Check that. Also please share the snap of your onchange client script configuration.

As per my script, you onchange client script should be configured on "Show impacted" field and UI type should be "All"

Regards ,

Siva