Related list question

[Cirrus]

Hi,

On a demand form we have a related list called Affected Cost Centre where users can select one or more cost centres associated with the demand record. There is now a requirement to have the primary cost centre as a field on the demand record, so we have created a new reference field. Is there a way to relate the two, such that if the user selects  CC123 in the new field, CC123 is automatically added to the related list?

Thanks

[Cirrus]

The script was wrong as I suspected The following async on insert resolved:

(function executeRule(current, previous /*null when async*/) {

    var gr = new GlideRecord('task_cost_center');

    gr.initialize();

    gr.cost_center = current.u_cost_code;

    gr.task = current.sys_id;  

    gr.insert();

}

   )(current, previous);

[AndersBGS]

Hi @Cirrus ,

Create you got it resolved - otherwise please see below solution:

I created the reference field u_cost_code in my PDI:

Created the relationships between dmn_demand and task_cost_center:

And created the business rule to updated the related list whenever the cost code is not empty:

(function executeRule(current, previous /*null when async*/) {
    // get the current demand costcenter
    var costCenter = current.u_cost_code;
    if (costCenter != '') {
        var cost = new GlideRecord('task_cost_center');
        cost.initialize();
        cost.task = current.sys_id;
        cost.cost_center = current.u_cost_code;
        cost.insert();
        gs.addInfoMessage('Cost center ' + current.u_cost_code + ' has been added to affected cost centers');
    }
})(current, previous);

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders  

[Anil Lande]

Hi,

It is not possible with OOB related list.

Please check below link to set filter condition on OOB related list.

https://docs.servicenow.com/bundle/vancouver-platform-user-interface/page/use/using-forms/task/t_Cre...

Or another way is to create custom relationship and add the filter criteria to show record as per your requirement.

https://www.servicenow.com/community/now-platform-articles/how-to-create-scripted-relationships-or-d...