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

[Ankit Kumar6]

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

Thanks

Ankit

[Arpan Baishya]

Hi @Ankit Kumar6,

Apart from the mapping between the source and target fields, there is a need to define a coalesce field if not already done. You can use a field (or a combination of fields) that can uniquely identify records as the coalesce field to ensure updates to the existing records and prevent duplicates from getting created. 

In fact, you can add the following script as an onBefore script to the transform map to explicitly prevent any record inserts.

if (action == 'insert') 
  ignore = true;

You can read more here.

Hope this helps.