Forum Discussion

MelissaFreel's avatar
MelissaFreel
Qrew Member
4 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....
Formulas and functions
TammieKing's avatar
TammieKing
Qrew Cadet
4 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
4 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
------------------------------