Business Rule Inserting 2 Records - Only want to Insert 1 Record

[Carter1]

Hi all,

I am writing an after insert/update business rule on a table (u_example) that is creating a record on another table (u_budget_key). This business rule is running only when my field, Budget Key is empty.

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

var key = new GlideRecord('u_budget_key');
	key.initialize();
	key.u_gl = current.u_gl;
	key.u_vendor = current.u_vendor;
	key.u_cc = current.u_cc;
	key.insert();


})(current, previous);

The script is working, but instead of only inserting one record, there are 2 duplicate records added to the other table. Can anyone help me diagnose why?

[Carter1]

Hi Jaspal,

There are no other business rules that run on the same table with that condition. I was able to get it to work from what Ben sent. Thanks anyways!

[Jaspal Singh · Accepted solution]

Great to know it worked.

Also, what I meant was condition not necessarily has to be the same check if there is something that runs on update & when it runs for the record which it runs for has Budget Key empty or not.

In addition you could also check below once that runs after insert/update

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

var key = new GlideRecord('u_budget_key');
key.addQuery('u_gl',current.u_gl);
key.addQuery('u_vendor',current.u_vendor);
key.addQuery('u_cc',current.u_cc);
key.query();
if(!key.next()) //if not then insert
{
	key.initialize();
	key.u_gl = current.u_gl;
	key.u_vendor = current.u_vendor;
	key.u_cc = current.u_cc;
	key.insert();
}

})(current, previous);

[Carter1]

Jaspal,

This worked, thanks a ton!!

[Carter1]

Hi Jaspal,

This is actually still outstanding, I thought that I had solved it. The solve that Ben came up with actually populates the Budget Key field. I want to have this field remain empty. 

There are no other business rules running on the same table with the condition Budget Key | is empty

[Michael Jones -]

Do this need to run on both insert and update? I think the "on update" is causing it to trigger a second time. You could add key.setWorkflow(false); before the insert and see if that helps!

Hope this helps!

If this was helpful or correct, please be kind and click appropriately!

Michael Jones - Proud member of the CloudPires Team!