Discussions

 View Only
  • 1.  How do I extract only the Last Name from a USER name?

    Posted 02-02-2023 21:15
    I want to compare the last name of the USER to the last name of another field.  

    Thank you

    ------------------------------
    Barbara Alvarez
    ------------------------------


  • 2.  RE: How do I extract only the Last Name from a USER name?

    Posted 02-03-2023 01:56
    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
    CTO
    gotomyerp, LLC
    ------------------------------