Can html be used solely in a formula text field? Is it possible to generate a chart type picture written in html?

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have html code that inserts a picture in a form. I put the code in a formula text field but keep getting area. Does anyone know the code I need to add so html will work with Quickbase? Here is the code:

Here is the html:   <TABLE\> <TABLE  BORDER="5">   <TR>     <TR ALIGN="CENTER">" "<th rowspan="9"><div><span>Severity Criteria</span></div></th>></th>"       <TD> Extreme (5)</TD>       <TH COLSPAN="1">       <TD  BGCOLOR=#FFFF00>5</TD>       <TD  BGCOLOR=#FFA500>10</TD>       <TD  BGCOLOR=#FFA500>15</TD>       <TD  BGCOLOR=#FF0000>20</TD>       <TD  BGCOLOR=#FF0000>25</TD>           </TR>"    <TR> <TR ALIGN="CENTER">       <TD>Major (4)</TD> <TH COLSPAN=\"1\"> <TD  BGCOLOR=#008000>4</TD> <TD  BGCOLOR=#FFFF00>8</TD> <TD  BGCOLOR=#FFFF00>12</TD> <TD  BGCOLOR=#ff0000>16</TD> <TD  BGCOLOR=#ff0000>20</TD>    </TR>    <TR> <TR ALIGN="CENTER">      <TD>Moderate (3)</TD> <TH COLSPAN="1"> <TD  BGCOLOR=#008000>3</TD> <TD  BGCOLOR=#ffff00>6</TD> <TD  BGCOLOR=#ffff00>9</TD> <TD  BGCOLOR=#ffa500>12</TD> <TD  BGCOLOR=#ffa500>15</TD>    </TR> <TR> <TR ALIGN="CENTER">      <TD>Minor (2)</TD> <TH COLSPAN="1"> <TD  BGCOLOR=#008000>2</TD> <TD  BGCOLOR=#008000>4</TD> <TD  BGCOLOR=#008000>6</TD> <TD  BGCOLOR=#ffff00>8</TD> <TD  BGCOLOR=#ffa500>10</TD>    </TR> <TR> <TR ALIGN="CENTER">      <TD>Negligible (1)</TD> <TH COLSPAN="1 "> <TD  BGCOLOR=#008000>1</TD> <TD  BGCOLOR=#008000>2</TD> <TD  BGCOLOR=#008000>3</TD> <TD  BGCOLOR=#008000>4</TD> <TD  BGCOLOR=#FFFF00>5</TD>    </TR> <TR> <TR ALIGN="CENTER">     <TD  BGCOLOR=#0000ff> </TD> <TH COLSPAN="2 "> <TD> Almost No (1)</TD> <TD> Very Unlikely (2)</TD> <TD> Unlikely (3)</TD> <TD> Likely (4)</TD> <TD> Very Likely (5)</TD>    </TR> <TR> <TD  BGCOLOR=#0000ff> </TD> <th colspan="7">Likelihood Criteria</th>    </TR> </TABLE> 
Photo of Sherry

Sherry

  • 0 Points

Posted 2 years ago

  • 1
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
Suprisingly, QuickBase does not allow table tags even when HTML is allowed. You have to use script to inject random HTML into your pages.
Photo of Sherry

Sherry

  • 0 Points
Can i make it look like a table?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
>Can i make it look like a table?

I never thought about this approach before but you can use nested <div>s and add the appropriate style attributes to make the nested <div>'s look like a conventional table. See this code and attached screenshot:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=530


Two thoughts:

(1) This technique may well be a general way to use any any html tag - just use <div>s for everything and imbue them with the with the appropriate style attributes. This is kinda crazy but what the heck we are dealing with outdated technology here. QuickBase needs to upgrade.

(2) A more general technique would be to use <script> as using <script> can solve all your problems rather than solving a bunch of disconnected problems with one off hacks. 
Photo of Sherry

Sherry

  • 0 Points
Thanks that worked great!!!!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
Unfortunately I have sunk into a deep depression. Henceforth, I will only provide solutions that use <script> ...