Forum Discussion

MelissaFreel's avatar
MelissaFreel
Qrew Member
3 years ago

HTML Table in Rich Text Field

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
------------------------------
Formulas and functions
  • TammieKing's avatar
    TammieKing
    Qrew Cadet
    3 years ago

    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
    ------------------------------
    • MelissaFreel's avatar
      MelissaFreel
      Qrew Member
      3 years ago
      Thanks Tammie!  It worked. I just put "ToDate" on the var Date variable and it all fired correctly.  Seeing that you used "Part" was really helpful.

      Thanks again.

      Mel.

      ------------------------------
      Melissa Freel
      ------------------------------