Skip to main content
Question

HTML Table in Rich Text Field

  • April 26, 2022
  • 0 replies
  • 426 views
Forum|alt.badge.img+3
All:
I know this is simple but its my first time to get this to work.  Please advise

I have a query formula field where I call some data. I want that data to display in a neat table on the record.  Here is a screen shot of my record with the two rich text fields.  The first being the formula query, the second, my sloppy attempt at an html table to put the data.  Any help is appreciated.

Here is the code behind that Rental Calculation Table Field:
"<table>"
&"<tr><th>recordid</th><th>Client Portion</th><th>NLSM Portion</th><th>Propert Rent</th><th>NLSM Utility</th><th>Last Modified By</th><th> Date Modified</th></tr>"

&[Client Rental Calculation Query Field]

& "</table>"


------------------------------
Melissa Freel
------------------------------
This topic has been closed for replies.

TammieKing
Forum|alt.badge.img+10

Try something like this:

var text CRCQ = [Client Rental Calculation Query Field]
var text vRec = Part($CRCQ,1,";");
var text vClient = Part($CRCQ,2,";");
var text vNLSM = Part($CRCQ,3,";");
var text vRent = Part($CRCQ,4,";");
var text vUtility = Part($CRCQ,5,";");
var text vModBy = Part($CRCQ,6,";");
//You may need to tweak this to get the date to work
var date vModDt = Part($CRCQ,7,";");


"<table border=\"1\" cellspacing=\"0\" cellpadding=\"4\">"
&"<tr><th>RecordID</th><th>Client Portion</th><th>NLSM Portion</th><th>Property Rent</th><th>NLSM Utility</th><th>Last Modified By</th><th>Date Modified</th></tr>"
&"<tr><td>"& $vRec & "</td><td>" & $vClient & "</td><td>" & $vNLSM & "</td><td>" & $vRent & " </td><td>" & $vUtility &"</td><td>"& $vModBy &"</td><td>"& $vModDt&"</td></tr>"
& "</table>"



------------------------------
Tammie King
------------------------------
    Terms & ConditionsAccessibility statement