Forum Discussion

KimberlyGaston's avatar
KimberlyGaston
Qrew Cadet
7 years ago

Text Formula Fields to a Bullet List

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

  • 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)

  • Try this:

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