Forum Discussion
AdamKeever1
6 years agoQrew Commander
Just to put things in context, here was the end goal that I was aiming for:
This is all compiled into one rich text field so it will always display proportionately and it is composed of other formulas that change the number for the risk rating and the icon associated with the rating. Ergonomics and risk assessment scores are helpful, but a visual is worth a thousand words.
Here was the final code for the rich text field:
"\n<table style=width:100%>
\n<tr>
\n<td colspan=\"7\"> " & [Overall_combo] & "</td>\n
</tr>\n
\n<tr>
\n<td " & [L Wrist_combo] & "</td>\n
\n<td " & [L Elbow_combo] & "</td>\n
\n<td " & [L Shoulder_combo] & "</td>\n
\n<td " & [Neck_combo] & "</td>\n
\n<td " & [R Shoulder_combo] & "</td>\n
\n<td " & [R Elbow_combo] & "</td>\n
\n<td " & [R Wrist_combo] & "</td>\n
</tr>\n
\n<tr>
\n<td colspan=\"7\">\n<img src =\"h t t p s://XXXX.quickbase.com/up/XXXX/g/rb/eg/va/5%20Joints.jpg\"height=200; >\n</td>\n
</tr>\n
\n<tr>
\n<td colspan=\"7\"> " & [Back_combo] & "</td>\n
</tr>\n
</table>\n"
This is all compiled into one rich text field so it will always display proportionately and it is composed of other formulas that change the number for the risk rating and the icon associated with the rating. Ergonomics and risk assessment scores are helpful, but a visual is worth a thousand words.
Here was the final code for the rich text field:
"\n<table style=width:100%>
\n<tr>
\n<td colspan=\"7\"> " & [Overall_combo] & "</td>\n
</tr>\n
\n<tr>
\n<td " & [L Wrist_combo] & "</td>\n
\n<td " & [L Elbow_combo] & "</td>\n
\n<td " & [L Shoulder_combo] & "</td>\n
\n<td " & [Neck_combo] & "</td>\n
\n<td " & [R Shoulder_combo] & "</td>\n
\n<td " & [R Elbow_combo] & "</td>\n
\n<td " & [R Wrist_combo] & "</td>\n
</tr>\n
\n<tr>
\n<td colspan=\"7\">\n<img src =\"h t t p s://XXXX.quickbase.com/up/XXXX/g/rb/eg/va/5%20Joints.jpg\"height=200; >\n</td>\n
</tr>\n
\n<tr>
\n<td colspan=\"7\"> " & [Back_combo] & "</td>\n
</tr>\n
</table>\n"