Need to Populate Date based on selection of the show Name

e__rajesh_badam · ‎04-02-2025

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);

}

e__rajesh_badam · ‎04-02-2025

@Ankur Bawiskar could you please help me on it.

Ankur Bawiskar · ‎04-02-2025

@e__rajesh_badam

check what came in alert?

Is that record having date in it?

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
    alert('date is' + userObject.u_show_start_date);
    g_form.setValue('u_show_start_date', userObject.u_show_start_date);
}

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

e__rajesh_badam · ‎04-02-2025

Just on the form loading (without selecting Show Impact value )only it is showing as Date is undefined

Ankur Bawiskar · ‎04-02-2025

@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.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post