Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
<div align=\"center\">"
&
List("<br>",
[a formula text field],
[formula rich text showing an icon],
ToText([formula numeric field]))
&
List("<br>",
[a formula text field],
[formula rich text showing an icon],
ToText([formula numeric field]))
- AdamKeever16 years agoQrew Commander
This looks so much better now! Thanks again Mark. - AdamKeever16 years agoQrew CommanderI 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? - QuickBaseCoachD6 years agoQrew CaptainWhat 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. - AdamKeever16 years agoQrew CommanderThis 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:
- QuickBaseCoachD6 years agoQrew CaptainOh, so you want the icons to be horizontal? can you post your complete code?_
- AdamKeever16 years agoQrew CommanderSure:
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]) - AdamKeever16 years agoQrew CommanderThe combo fields have this structure:
"<div align=\"center\">"
&
List("<br>",
"Overall",
"Risk = " & ToText([Grand Total]),
[Overall Risk Icon],
[Overall Risk Rating]) - QuickBaseCoachD6 years agoQrew CaptainIs that the whole formula including the icons?
- AdamKeever16 years agoQrew CommanderHere 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. - QuickBaseCoachD6 years agoQrew Captain... and if you remove this,
"<div align=\"center\">"
does it then go horizontal like you want?