Skip to main content
Question

Combined Text of a Logged Field - possible to put in date order?

  • August 26, 2022
  • 0 replies
  • 39 views
Forum|alt.badge.img+20
If I have several logged Notes fields, and I use a combined text field, is there any possible way to put the notes in date order, newest to oldest?

To be clear, each combined text notes field will only include ONE date, so I do not need to separate the notes in a particular field and rearrange them.

My instinct is to break the combined text into many parts, extract the date from each part, and then somehow arrange from there??

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement