Formula for user initials

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
Is there a formula that would give me a user's initials? 
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi,

There isn't a formula function that directly calls a users initials but there are some formula choices that can help to tease out the user's initials so long as they put in their name in the standard format. This can be done in a Formula - Text field that is drawing the information from a User field. For example the below formula uses the Formula Function UserToName to turn a user field into that users name, displayed first name and then last name. Then it uses the Right and Left functions to essentially parse down the name that is returned to just the letters you are looking for. In this instance the first letter of the first name and the first letter of the last name. This could be confused by a middle name if a user has chosen to add one. In that case it would require a slightly different formula. 

Left(UserToName([User Field]), 1) & Left(Right(UserToName([User Field]), " "), 1)

Something like this formula should help you to get close to the results you are looking for. You would just replace User Field where it appears in the formula with the name of your own user field in your application. I hope this helps to point you in the right direction.