Skip to main content
Question

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

  • November 6, 2018
  • 0 replies
  • 129 views
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? 
    This topic has been closed for replies.

    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"


    • KurtJohnson
    • Registered
    • July 18, 2019
    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"
    Terms & ConditionsAccessibility statement