Is it possible to add an HTML table to a form?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

Is it possible to add an HTML table to a form that references QB formula fields in the cells of the table?  If yes, a simple example would be great. 


Thanks,

Tony


Photo of TonyA1

TonyA1

  • 100 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
I'm familiar with 3 ways to do something similar. The first would just be to use Text elements on the form and insert HTML code into these. This is tedious because each time you need to reference a field, you have to add that field in the form and then continue the HTML in another Text element. It can also look a bit "off" due to how Text elements are formatted by QuickBase in the larger context of the form.

The second way would be to build it as a Text Formula field where you would have the Allow HTML checkbox selected. This gives you a much better result, but you still have to build it as a formula, which can have its own challenges.

The last way I've seen it done is by building the HTML as a Code Page in the app and then using a Text Formula field with a small bit of JScript to call the page. 
Photo of TonyA1

TonyA1

  • 100 Points 100 badge 2x thumb
Blake...do you have any examples that you could share of the second approach...i.e., build it as a Text Formula field where you would have the Allow HTML checkbox selected.  .....?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
Photo of Stephanie

Stephanie

  • 732 Points 500 badge 2x thumb
when i click on the link it takes me to the QB Community page but not your specific answer to this question.