Business Rule - Create copy of current item?

[Edwin Fuller]

Hello everyone

I need to create a duplicate of the current item whenever a field is answered a certain way; Is this possible using business rule script? The duplicate would get created when the field "survey_question_1" equals "New ask based on response". Examples would be great!!

Current Business Rule script

var gdt= new GlideDateTime();

current.actual_completion_date.setValue(gdt);

if (current.survey_question_2 == 'New Ask based on response') {

}

[veena_kvkk88]

Hi Edwin,

It would be an after business rule and goes something like this: (Untested code)

var gdt= new GlideDateTime();
current.actual_completion_date.setValue(gdt);
if (current.survey_question_2 == 'New Ask based on response') {
       current.insert();
}

This would create an exact copy of the current record, if you need any changes, that can be incorporated as well. (Related lists won't be carried over - additional scripting required)

Edit: Unless there are any primary key violations. In that case you can assign new values for those fields and then insert.

[veena_kvkk88]

When I try this, it works but is giving an exception because the business rule is firing out a second time after the duplicate is created. (Since the duplicate will have the same choice as well)

The only solution I can think of is: Writing this as an after update business rule, so that it won't run again when new record is inserted. The drawback is that this won't take effect on insert. Let's hope other community experts have a better solution for this.

[Edwin Fuller]

Thanks - Do you know how to get the next number up?

[veena_kvkk88]

Try this:

1. var gdt= new GlideDateTime();  
2. current.actual_completion_date.setValue(gdt);  
3. if (current.survey_question_2 == 'New Ask based on response') {  
4.         current.number = getNextObjNumberPadded();
5.         current.insert();  
6. }