[MIGRATED TO ONEDRIVE] Replacing User IDs with cataloger initials in Analytics

Owned by Leanne Finnigan (Unlicensed)
Last updated: Mar 22, 2024 by Holly Tomren
1 min read

MIGRATED TO ONEDRIVE: Replacing+User+IDs+with+cataloger+initials+in+Analytics


Use case: In the "Modified by" column, I want to be able to see a catalogers' initials rather than their user ID.

Solution: Add the "modified by" column to the report, select 'edit formula' and enter the following:

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("Physical Item Details"."Modified By",'910135016','HN'),'915144202','LF'),'908663101','CDC'),'909413966','MRTL'),'915252914','MKD'),'910061693','CP'),'915628432','HT'),'909818183','EL'),'916241818', 'EGC')


You can add replacement functions to this by appending ,'USERID','INITIALS') and prepending REPLACE(