How can i Allow user to update only perticular Field in a table from data source?

Ankit Kumar6
Tera Contributor

‎05-24-2024 05:00 AM

Hi Team,

In the current scenario, the user exports data from the servicenow table into an Excel spreadsheet, makes updates to the spreadsheet, and then loads it back into ServiceNow. The requirement is that when the user uploads the Excel file, only one field in servicenow (suppose field name is  Approval )should be updated. If the user makes changes to other columns in the Excel spreadsheet, those changes should not be applied to the ServiceNow table.

How can i do this?please help

0 Helpfuls
  • 170 Views
1 REPLY 1

Ratnakar7
Mega Sage
Mega Sage

‎05-24-2024 05:40 AM

Hi @Ankit Kumar6 ,
Create Import Set Table and the Transform Map, In the transform map, add a transform map script to ensure only the "Approval" field is updated. Here’s an example script:

(function runTransformScript(source, map, log, target) {
    // Only update the Approval field
    target.approval = source.approval;
})(source, map, log, target);


Thanks,

Ratnakar

0 Helpfuls