Update multiple records with replacement user in multiple tables

[RandiReyna]

Hi All,

Could use some guidance on how to best approach this scenario. I have hundreds of records in different tables within the audit management application. When a user leaves the company and a new person is brought in, how do I replace the previous user listed in all records with the new user? The fields on each form are list fields that can have multiple users. Can this be done automatically? The client will need to do this capability when moved to production.

Any help is appreciated!!

[shun6]

Hi @RandiReyna ,

I often use Fix Script for data patch.

Like below article, create a system property and store values (tables you want to update) .

Then you can update each table's field value by gliderecord.

Solved: How to query multiple tables via one GlideRecord - ServiceNow Community

Thanks.