Skip to main content
Question

Converting Non-User Name Fields

  • January 7, 2026
  • 0 replies
  • 68 views

Forum|alt.badge.img

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?

 

Forum|alt.badge.img
  • Quickbase Alumni
  • February 20, 2026

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?