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

  • 1
  • 2
  • 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

  • 356 Points 250 badge 2x thumb

Posted 9 months ago

  • 1
  • 2
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"


Photo of Kurt Johnson

Kurt Johnson

  • 206 Points 100 badge 2x thumb
The following syntax works fine within a Text Multi-Line field... noticed you had a "/n" instead of the appropriate "\n"... wrap that with URLEncode()

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