New line code in formula rich text field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi, I'm trying to add an image thumbnail and text together on a report, and want the text to be under the image. With the formula rich text field below, the image and text show but the text is currently displaying to right of image, not below. I'm trying "\n" to force a new line after the image but it is not working. Thanks

"<img height=\"150\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e10/v0\" />" & "\n" & [My Text Field]
Photo of Gary Boyd

Gary Boyd

  • 840 Points 500 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
replace the "\n" with "<br>"

The \n works on a regular formula text field but for Rich Text you need to use the HTML equivalent. 

<br> means break to a new line.
Photo of Gary Boyd

Gary Boyd

  • 840 Points 500 badge 2x thumb
Thanks for such a quick response. Your solution worked.