You can create a formula text field on the child table with this formula
var text RollupText = ToText([Date Created])
& ": " & [My Note Field];
var text ZeroPaddedDaysfromFiveYearsSAheadFromToday=
PadLeft(ToText(ToDays(AdjustYear(Today(),5) - ToDate([Date Created]))),8,"0");
"<div style=" & $ZeroPaddedDaysfromFiveYearsSAheadFromToday & ">"& $RollupText & "</div>"
// then on the Parent record you roll up that field and create a Formula Rich Text field
var text Raw = ToText([Combined Text Roll up words]);
List("\n",
Part($Raw,1,";"),
Part($Raw,2,";"),
Part($Raw,3,";"),
Part($Raw,4,";"),
Part($Raw,5,";"),
Part($Raw,6,";"),
Part($Raw,7,";"),
Part($Raw,8,";"),
Part($Raw,9,";"),
Part($Raw,10,";"),
Part($Raw,11,";"),
Part($Raw,12,";"))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
