Forum Discussion

AngelaTillman1's avatar
AngelaTillman1
Qrew Member
5 months ago

Converting Non-User Name Fields

I am trying to convert a field that is not a user field to be able to read first name, middle name, last name. I have a field that reads last name, first name middle name/initial (Smith,John Q). I want a field where I can convert it to read as John Q Smith. I have found a formula that I think may work but when I try it, it just shows the original format (Smith,John Q). Is there something I need to update or another formula to use to accomplish this?

 

formula name

2 Replies

  • TomShannon5's avatar
    TomShannon5
    Qrew Member
    4 months ago

    Can you describe the "...field that reads last name, first name middle name/initial?"  

    Is that a formula field text reading from three regular text entry fields, first name, etc? 

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 months ago

      Try this as a formula text field.

      var text PartOne = Part([my last first field], 1, ",");

      var text PartTwo = Part([my last first field], 2, ",");

      List(" ", Trim($PartTwo), Trim($PartOne))