Formula URL Line break /n not functional with Text - Multi-Line field

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
Hi- 

I'm attempting to use the following formula to prepopulate a new record form with a multi-line "Description" (where Description is FID 7). 

URLRoot() & 
"db/" & [_DBID_XXX] 
& "?a=API_GenAddRecordForm"
&"&_fid_7=" & "Test description line 1"&"/n"&"Test description line 2"

My goal is that the _fid_7 value in the new record for would read: 
Test description line 1
Test description line 2
Instead, it's populating as:
Test description line 1/nTest description line 2

Am I missing a urlencode or something? 
Photo of AO

AO

  • 304 Points 250 badge 2x thumb

Posted 1 month ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
It will work as a if you are updating a Rich Text field type using the <br> as the new line character.


I could not get it to work with a regular text field.

URLRoot() & 
"db/" & [_DBID_XXX] 
& "?a=API_GenAddRecordForm"
&"&_fid_7=" & "Test description line 1"&"<br>"&"Test description line 2"