Auto update column in Incident table

[Kalpesh Kalgutk]

Hi,

I would like to write a script to update a column when a specific subcategory is selected in Incident table.

Could you please assist me with this?

Thank you.

[ShubhamGarg · Accepted solution]

Hello @Kalpesh Kalgutk ,

You can put below line of code in your Business Rule -> 

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

// Add your code here
var session = gs.getSession();
var URL = session.getUrlOnStack();
//gs.info(URL);
current.COLUMN_NAME = URL;

})(current, previous);

Reference documentation - https://developer.servicenow.com/dev.do#!/reference/api/washingtondc/server/c_GlideSessionScopedAPI

If my response helps you in any way, kindly mark this as Accepted Solution/Helpful and help in closing this thread.

Regards,

Shubham

[ShubhamGarg · Accepted solution]

Hello @Kalpesh Kalgutk ,

You can put below line of code in your Business Rule -> 

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

// Add your code here
var session = gs.getSession();
var URL = session.getUrlOnStack();
//gs.info(URL);
current.COLUMN_NAME = URL;

})(current, previous);

Reference documentation - https://developer.servicenow.com/dev.do#!/reference/api/washingtondc/server/c_GlideSessionScopedAPI

If my response helps you in any way, kindly mark this as Accepted Solution/Helpful and help in closing this thread.

Regards,

Shubham

[ShubhamGarg]

Hello @Kalpesh Kalgutk ,

Have you happened to check my solution to your problem statement?

If my response helps you in any way, kindly mark it as Accepted Solution/Helpful and help in closing this thread.

Regards,

Shubham

[Kalpesh Kalgutk]

hi@ShubhamGarg 

I checked, but it's not working.

[ShubhamGarg]

To help you further, Is it possible for you to share the code you have written?

Regards,

Shubham

[Kalpesh Kalgutk]

Hi @ShubhamGarg  thank you and sorry.

I removed the code because it wasn't working and I'm exploring alternative methods to complete the task.

But I can provide more details about the requirement. We created a SharePoint form for updating records, and I want to update the link to this form in the `u_sharepoint` column which we created in the incident table. I have created a fixed URL property under the `sys_properties` table with the value `"www.sharepoint.com="`. The updated column should contain the current incident number appended to the URL after the `=` sign, forming a link like `www.sharepoint.com=INC12345`.