Skip to main content
Question

Text Formula Fields to a Bullet List

  • October 31, 2018
  • 0 replies
  • 60 views
I want to create a summary of updates to my projects.  So, I have three Update fields and I want the list to look like this:
? Update 1
? Update 2
? Update 3

Here is my current formula:  List("?",[Update 1],"?",[Update 2],"?",[Update 3])

And here is the result:
Kim's first update???Kim's second update???Kim's third update

I want each of these on a separate line, but when I use <br> the formula builder doesn't like it.  Plus, my first bullet isn't showing up.  

Any ideas?
Thanks!
Kim

    This topic has been closed for replies.

    Try this as a Formula Text field

    The \n is the carriage return character, similar to <br>, but <br> will only work on Rich Text field types.

    So the separator will be the new line, then a bullet, but if we have some data then we also need to add that first bullet to the first entry on the list.


    var text VerticalMissingFirstBullet = 
      List("\n�",[Update 1],[Update 2],[Update 3]);
      
    If($VerticalMissingFirstBullet <>"", "�" & $VerticalMissingFirstBullet)

    • anomDiebolt
    • Registered
    • October 31, 2018
    Try this:

    "<ul>" &
      "<li>" & [Update 1] & "</li>" &
      "<li>" & [Update 2] & "</li>" &
      "<li>" & [Update 3] & "</li>" &
    "</ul>"
    Dan's solution would be a Formula Rich Text field type.
    • KimberlyGaston
    • Author
    • Registered
    • October 31, 2018
    Dan's solution worked perfectly!  Thank you so much!!
    Terms & ConditionsAccessibility statement