Skip to main content
Question

combine fields using formula rich text

  • June 21, 2019
  • 0 replies
  • 290 views

AdamKeever1
Forum|alt.badge.img+2
I have three fields I would like to combine using formula rich text.

I would like to take the first, a formula text field, and have it show above the second, a formula rich text showing an icon, and have that show above the third, a formula numeric field.

I am not sure how to structure the HTML for this. Does anyone have any suggestions?
This topic has been closed for replies.

try this

List("<br>",
[a formula text field],
[formula rich text showing an icon],
ToText([formula numeric field]))





<div align=\"center\">"

&

List("<br>",
[a formula text field],
[formula rich text showing an icon],
ToText([formula numeric field]))

AdamKeever1
Forum|alt.badge.img+2
  • Author
  • Registered
  • June 22, 2019
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"  

Very impressive.

Forum|alt.badge.img+2
  • Registered
  • June 22, 2019
Nice work Adam.

AdamKeever1
Forum|alt.badge.img+2
  • Author
  • Registered
  • June 22, 2019
Thanks guys. The people in the community have been so helpful, I want to offer something in return when I can.