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]

I tested it on my instance and is not giving any error currently. It's creating a new copy with the next autonumber generated.

[Abhinay Erra]

Here you go

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

var gr= new GlideRecord("table name");

gr.newRecord();

gr.insert();

}

[veena_kvkk88]

Hi Abhinay,

Wouldn't this create just a new record(not a duplicate) with default values?

[Abhinay Erra]

Oops I misread completely. Here is the code for creating a copy

var gr= new GlideRecord('table name');

gr.get(current.getValue('sys_id'));

gr.setWorkflow(false);

gr.insert();

[Abhinay Erra]

For the next number to be padded use this script

var gr= new GlideRecord(current.getTableName());

  gr.get(current.getValue('sys_id'));

  gr.number=getNextObjNumberPadded();

  gr.setWorkflow(false);

  gr.insert();