Forum Discussion

WadeMyers1's avatar
WadeMyers1
Qrew Trainee
4 years ago

List function in Rich Text Formula field

I am importing data from one table to another. I have a few fields of information with moderate value, enough that I don't want to simply lose them, but not enough to need as individual fields.

I created a rich text formula field to merge the data. I want the form to display it as a list, with one label and field then a line break resulting in a next row. I thought the below formula could make that happen, but it just concatenates into a continuous line. What's wrong with this formula?

List("\n",
"Previous ESM ",[ESM],
" Previous PM "&[PM],
" Previous Account Mgr. "&[Account Manager],
" Previous Project Code "&[Project Code],
" Previous Project ID "&[Project_ID],
" Practice "&[Practice]

------------------------------
Wade Myers
------------------------------
  • The character for a new line is \n for a regular formula text field and if using a Rich Text formula fields, it  needs to be the html <br> character.

    List("<br>",
    "Previous ESM ",[ESM],
    " Previous PM "&[PM],
    " Previous Account Mgr. "&[Account Manager],
    " Previous Project Code "&[Project Code],
    " Previous Project ID "&[Project_ID],
    " Practice "&[Practice]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • The character for a new line is \n for a regular formula text field and if using a Rich Text formula fields, it  needs to be the html <br> character.

    List("<br>",
    "Previous ESM ",[ESM],
    " Previous PM "&[PM],
    " Previous Account Mgr. "&[Account Manager],
    " Previous Project Code "&[Project Code],
    " Previous Project ID "&[Project_ID],
    " Practice "&[Practice]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------