Forum Discussion

BarbaraAlvarez1's avatar
Qrew Member
2 years ago

How do I extract only the Last Name from a USER name?

I want to compare the last name of the USER to the last name of another field.  

Thank you

Barbara Alvarez

1 Reply

  • To do this:
    • Create a new Formula - Text field
    • Put in the following formula: Trim(Part(UserToName([Quickbase User]),2," "))
    Where [Quickbase User] is the field where your Quickbase user is.

    UserToName would convert the Quickbase user to the <First Name> <Last Name> 
    Part would get the second part of the name on the <space> delimiter, which results in the last name. 

    Now you can use that value to compare it with any other field.

    George Khairallah
    gotomyerp, LLC