Using Option Sets to change color based on User's name

Need help
1

I would like to use an option set that sets the color of a background based on the current user’s name.

For example, if we have a user named Adam, I would like the background color to be set dynamically using the first letter of his name ‘A’. If a user was named Bob, then it would set the background color based on the first letter ‘B’.

I have an option set that has 26 letters for the display (A through Z), and an attribute for Color for the HEX code. I am just not sure how to setup the dynamic color using an expression. I can extract the current user’s first name:trimmed 1:uppercase to get the letter, but I don’t know how to apply the correct color from the option set.

Can anyone point me in the right direction?

2

Hi there, @doug4… I just made a quick example, and this expression appears to do what you described.

color
color893×471 36.3 KB

Hope this helps.

Best…
Mike

3

Mike,

Thank you very much, this worked perfectly. I’m not sure how long it would have taken me to figure this out, but let’s just say I wasn’t too close.