Discussions

Expand all | Collapse all

Text Formula Fields to a Bullet List

  • 1.  Text Formula Fields to a Bullet List

    Posted 10-30-2018 23:38
    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



  • 2.  RE: Text Formula Fields to a Bullet List

    Posted 10-31-2018 11:06
    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)



  • 3.  RE: Text Formula Fields to a Bullet List

    Posted 10-31-2018 11:10
    Try this:

    "<ul>" &
      "<li>" & [Update 1] & "</li>" &
      "<li>" & [Update 2] & "</li>" &
      "<li>" & [Update 3] & "</li>" &
    "</ul>"


  • 4.  RE: Text Formula Fields to a Bullet List

    Posted 10-31-2018 11:28
    Dan's solution would be a Formula Rich Text field type.


  • 5.  RE: Text Formula Fields to a Bullet List

    Posted 10-31-2018 14:39
    Dan's solution worked perfectly!  Thank you so much!!