Copy Field Contents from sys_id

[amacqueen]

I have a user field that I've created which I use to give each user record a unique ID as I have a lot of cleaning up to do to ensure to integrity of our user database - imported from our previous incident management application.

Up to now I have been running a background script to populate this field with the sys_id of the user record from SN as that uniquely identifies each record. Rather than having to manually update this I would like it to be automatic so I have tried creating the new field as a reference field to sys_id however because of the nature of that field's attributes it becomes hidden from view.

Does anyone have any suggestions as to how I might get this automated and visible.

TIA

[ravali6]

HI Jim,

I had a similar doubt. I understand what you are doing but how can we force run a business rule, yout 4th point
4. run your script on the records one last time to populate the new field for existing records.

Can we do that?

[Jim Coyne]

Angus said he has a Background Script that he has been running to update the field. What I meant was once the field and Business Rule were in place, that script needs to be run in order to update any "existing" records that do not have that field populated (and none would to begin with). Once the BR is there, it will handle any new records, but the old ones still need to be updated.

[amacqueen]

It's working perfectly Jim. many thanks

[ravali6]

Yup thanks a lot Jim for the help.