- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2020 12:27 PM
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?
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2020 12:59 PM
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);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2020 08:03 AM
Nevermind - I see Jaspal's code above that checks for a Budget Key with similar properties as the one being inserted before creating it.
If you have other ways of creating Budget Key records you may want to make that an on-insert/update business rule on the Budget Key table to reject duplicates.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2020 12:42 PM
Thanks Ben! This did the trick for me, I appreciate the clear explanation.