how to auto populate the cost center field value from caller/user to incident form using the business rule

Naresh44
Giga Contributor

Hi all,

I tried auto populating the 'cost center' field value from users table,  using the getReference method in business rule for incident form, but it didn't worked at all.

Please help me in retrieving the value of the cost center field value in the incident form

 

1 ACCEPTED SOLUTION

Hi Naresh,

 

As suggested by Ankur above won't work in business rule as g_form.getReference() are client specific side options to be used.

Try using below business rule that runs After Insert on required table & make sure you have correct field name passed.

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

    // Add your code here
    current.location = current.caller_id.location;

    current.cost_center = current.caller_id.cost_center;

    current.state = current.caller_id.state;

    current.city = current.caller_id.city;

    current.country = current.caller_id.country;
	
	current.update();

})(current, previous);

View solution in original post

25 REPLIES 25

Did you mistakenly mark other answer as correct? As I see same script was provided before from my end.

Also don't use current.update()

it is not required if you use before insert/update BR

If my answer solved your issue, please mark my answer as Correct & 👍Helpful based on the Impact.

Regards
Ankur

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

Hi Naresh,

 

As suggested by Ankur above won't work in business rule as g_form.getReference() are client specific side options to be used.

Try using below business rule that runs After Insert on required table & make sure you have correct field name passed.

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

    // Add your code here
    current.location = current.caller_id.location;

    current.cost_center = current.caller_id.cost_center;

    current.state = current.caller_id.state;

    current.city = current.caller_id.city;

    current.country = current.caller_id.country;
	
	current.update();

})(current, previous);

Hi Jaspal singh,

Thanks for your response.

But still state/province, street and cost center fields are not autopopulating.

Please help me

Thanks & regards

Naresh Uppu

 

Can you kindly confirm if 

caller_id is a refrence field to User table. 

Also, if fields state, location, cost-center exists on User table or not.

Yes it is referenced to the user table and there are state, location, cost center field on the user table.

I have added them manually but didn't created any duplicate fields.