Discussions

Expand all | Collapse all

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

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

     
    Posted 11-06-2018 17:17
    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? 


  • 2.  RE: Formula URL Line break /n not functional with Text - Multi-Line field

    Posted 11-06-2018 22:11
    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"




  • 3.  RE: Formula URL Line break /n not functional with Text - Multi-Line field

    Posted 07-18-2019 13:45
    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"