Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I have a text field that is 16 characters.  The first 12 characters are redundant, so I want to build a formula field based on the field that only shows the last 4 characters.  Is this possible?

Photo of JRogerson

JRogerson

  • 370 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
No problem

Mark a new formula text field

Right(trim([my 16 character field]),4)
Photo of JRogerson

JRogerson

  • 370 Points 250 badge 2x thumb
perfect, thanks.