Need to create catalog item to create/update/delete custom table data

[Rajyalakshmi]

Hi Team,

I need to create catalog item to create/update/delete custom table data ,could you please suggest good practice.

[AndersBGS · Accepted solution]

Hi @Rajyalakshmi ,

Not quite understand your question. You can off course create a catalog item, and then setup rules on the backend to create/update/delete.... What have you tried so far and where do you get stuck.

[sumityadav8]

Hii @Rajyalakshmi,

I understood your use case. I actually got the same question in an interview.
To achieve this, you need to create a Record Producer with 3 variables:

1. Table (Reference → sys_db_object)

2. Description (String)

3. Caller (Reference → sys_user)

Below is the script I used for mapping the variables dynamically.
You can apply the same logic:

// Ensure variable names match those defined in the Record Producer
var selectedTable = producer.select_table;
var caller = producer.caller;
var description = producer.short_description;

if (selectedTable == 'incident') {
var inc = new GlideRecord('incident');
inc.initialize();
inc.caller_id = caller;
inc.short_description = description;
inc.insert();
action.setRedirectURL(inc);
current.setAbortAction(true); // Prevent default record creation

} else if (selectedTable == 'problem') {
var prob = new GlideRecord('problem');
prob.initialize();
prob.caller_id = caller;
prob.short_description = description;
prob.insert();
current.setAbortAction(true); // Prevent default record creation
}

If this helps, please mark the answer as helpful in the ServiceNow Community 

[Rajyalakshmi]

I have created catalog item with set of variables ,and implemented flow using create /update /delete record actions .It is working as expected .flow actions are very useful with no code ,able to achive requirement.