Business Rule Insert

[Avinash Dubey2]

Create a Business Rule which will trigger when new record will be inserted in Incident table then create a new record in Customer Incident table 

[Community Alums]

Hello,

Here what is "Customer Incident table". Are you talking about any third party tool. If yes then it needs integration.

Regards,

Akshay 

[Voona Rohila]

Hi Avinash

Can you explain in detail of your requirement?

[Avinash Dubey2]

Customer Incident  Table:

Table Name - Customer Incidents
Fields - 
Inc Number - autogenrated number
Parent Inc Number- number
Short Description - String 250 Mandatory
Description - HTML Mandatory
State - Choice (values same as incident State field values)
Category - Choice ( Same as Incident Category field values)
Subcategory - Choice ( Same as Incident Category field values)
Caller - Reference ( ref to sys_user table filter only active records)
Assignment Group - Reference - (ref to sys_user_group table)
Assigned to - reference - (ref to sys_user table)
Additional Comments - Journal input ( same as incident)
work notes - Journal input

Detail statement :

Create a Business Rule which will trigger when new record will be inserted in Incident table then create a new record in Cusetomer Incident table with below values 
Parent Inc Number, Short Description, Description, State, Category, Subcategory, caller
*Inc Number should be autogenerated.
Once record is inserted show info message on form with new Inc number which will be created on Customer Incident table.

[Community Alums]

Hello @Avinash Dubey 

Create Business Rule  on incident table. PFB screen shot. 

then write script PFB sample script. Kindly add your customer table name and map all required fields as I have shown some examples

Sample script for easy copy paste - 

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

	var gr = new GlideRecord('customer_incident'); //enter customer incident table name
    gr.newRecord();
	gr.category = current.category;
	gr.state=current.state;
	gr.description=current.description;
	gr.short_description=current.short_description;
	gr.parent_incident=current.number;
	gr.caller=current.caller;
	//similarly mapp all required fields.
	gr.insert();
   gs.addInfoMessage("The customer incident " + gr.number +" has been created");

})(current, previous);

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact. 

Thanks
Akshay Kangankar