combine fields using formula rich text

This looks so much better now! Thanks again Mark.

I modified this slightly to achieve the following result:



Now I am trying to line several of these up in an additional formula rich text field with this formula:

List(" ",
[Overall_combo] , [Back_combo] , [Neck_combo] , [L Shoulder_combo] , [R Shoulder_combo] , [L Elbow_combo] , [R Elbow_combo] , [L Wrist_combo] , [R Wrist_combo])

For some reason, they are displayed stacked one on top of the other like a totem pole:



Any idea how I can get these to display in line horizontally?

What is happening is that the field is getting wrapped - maybe because its on a report and Quick Base is  trying to fit the columns across the page without side to side scrolling,

You can do this

List "_", etc



to avoid the wrapping, but the "look" might bother you and also it will still try to wrap a double word like

R Elbow

What happens on a report if you take away a bunch of columns off the report so this field has lots of room.

This is on a form within it's own section. I tried adding the underscore in place of the space in the formula list, but get this result:

Oh, so you want the icons to be horizontal?  can you post your complete code?_

Sure:

List("_",
[Overall_combo] , [Back_combo] , [Neck_combo] , [L Shoulder_combo] , [R Shoulder_combo] , [L Elbow_combo] , [R Elbow_combo] , [L Wrist_combo] , [R Wrist_combo])

The combo fields have this structure:

"<div align=\"center\">"

&

List("<br>",
"Overall",
"Risk = " & ToText([Grand Total]),
[Overall Risk Icon],
[Overall Risk Rating])

Is that the whole formula including the icons?  

Here is  [Grand Total]:

Sum(
[Back Total],
[Neck Total],
[L Shoulder Total],
[R Shoulder Total],
[L Elbow Total],
[R Elbow Total],
[L Wrist Total],
[R Wrist Total],
[Accelerators Total]
)

Here is [Overall Risk Icon]:

Case([Overall Risk Rating],
"Low","<img src=\"h t t p s://XXXX.quickbase.com/up/XXXX/g/re/eg/va/222-point_green.png\" title=\"Low\">",
"Moderate","<img src=\"h t t p s://XXXX.quickbase.com/up/XXXX/g/rf/eg/va/223-point_yellow.png\" title=\"Moderate\">",
"High","<img src=\"h t t p s://XXXX.quickbase.com/up/XXXX/g/rd/eg/va/221-point_red.png\" title=\"High\">",
"Very High","<img src=\"h t t p s://XXXX.quickbase.com/up/XXXX/g/rc/eg/va/204-warning.png\" title=\"Very High\">",
null)

Here is [Overall Risk Rating]:

If(
[Grand Total]<=20,"Low",
[Grand Total]>=21 and [Grand Total]<=35,"Moderate",
[Grand Total]>=36 and [Grand Total]<=55,"High",
[Grand Total]>55,"Very High"
)

Here is an example of one of the individual body part total fields:

Sum(
If(ToNumber([Back_Flexed>20])=0,0,1),
If(ToNumber([Back_Extended])=0,0,1),
If(ToNumber([Back_Sideways>20])=0,0,1),
If(ToNumber([Back_Twisted>20])=0,0,1),
If(ToNumber([Back_Flexed>45])=0,0,1),
If(ToNumber([Back_Extended>20])=0,0,1),
If(ToNumber([Back_Force>10 lb])=0,0,2),
If(ToNumber([Back_Repetition >2/min])=0,0,2),
ToNumber([Back_Static Exertion>10 sec])
)

This is part of an Ergonomic Rick Assessment form.

... and if you remove this,

"<div align=\"center\">"

does it then go horizontal like you want?