WadeMyers1
4 years agoQrew Trainee
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
------------------------------
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
------------------------------