Forum Discussion

AndrewOrner's avatar
AndrewOrner
Qrew Cadet
7 years ago

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

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? 
Formulas and functions

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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's avatar
    KurtJohnson
    Qrew Member
    6 years ago
    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"