Discussions

Expand all | Collapse all

Formula for user initials

  • 1.  Formula for user initials

    Posted 01-08-2018 19:33
    Is there a formula that would give me a user's initials? 


  • 2.  RE: Formula for user initials

    Posted 01-08-2018 21:35
    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.