Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago

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

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------