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
------------------------------