I’ve created a table that has a unique number for each Worker at each Site Visit working for each company. The unique number looks like this Wxxxx-SVxxx-Orgxxx.
I then have a formula field that removes the Worker ID and leaves SVxxx-Orgxxx.
I need to copy from that SV-Org field only the unique SV-Org numbers. I was trying to figure out a way to compare values across records, but I’m at wits end.
Any ideas? Could I do this via script?