Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Formula for user initials

Is there a formula that would give me a user's initials? 
  • 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.