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.

[e__rajesh_badam]

Thank you @J Siva i.e., Correct and it is populating date now but format taking is in opp format when loading

Table data:

Incident reflection: