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
------------------------------
Original Message:
Sent: 02-02-2023 21:15
From: Barbara Alvarez
Subject: 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
------------------------------