How to copy one record field value to another record

[F_bio Santos]

Hi everyone, I have a field called "Process Managers" which has a value by default, if I change the "default value" it will only change for the records that get created after this change, is there any way to make the other records get the value of the one that was created in last ?

[Peter Bodelier]

Hi @F_bio Santos 

You'll have to use a background script, or fix script to query the records and update from there.

var records = new GlideRecord('table_name');
records.addQuery('process_managers', '!=', 'oldValue');
records.query();

records.setValue('process_managers', 'newValue');
records.updateMultiple();

[F_bio Santos]

Hi @Peter Bodelier can this be done with a BR ? So that we dont need to do the background script everytime the default value changes.

Is there any way to get the default value of a field ?

[Peter Bodelier]

I don't think it's a good idea to create a Business Rule on the dictionary table.

I suppose it is possible, but I wouldn't do it.

At best create a scheduled script, which queries that dictionary field daily, and to your logic from there.

[F_bio Santos]

I will try the scheduled script