Truncate Text Field (Help with writing a formula)

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hello!
I need help :)

I have a multi-line text field for notes. I need this field in my report but in the report I only want to show the first 150 characters in the field (so the rows aren't so tall when the text wraps). I'm not sure there is an easy way to do this?

My thought is to create a "mirror" field which only displays the first 150 characters and use that new field in my reports?

Thoughts and guidance are appreciated. Thank you!!
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
The low tech solution would be this as a new field

Left([My notes field],150) & if(length([my notes field])>150, " and More ...")
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
Thank you SO MUCH!!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Thx for letting me know it worked.