Forum Discussion

AmyGosz1's avatar
AmyGosz1
Qrew Trainee
12 months ago

Showing last entry in an appended field when new entry is at top

I have not been able to find a solution on how to extract the last entry from an appended field when new entries are displayed at the top. I do want the date and name of the person who created the entry included.

One solution did display the most recent note, but didn't include the date/person who created it.

Trim(Left(NotLeft([Fulfillment Notes],"]"),"["))

How would I adjust this formula to include the date and person name?



------------------------------
Amy Gosz
------------------------------

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    12 months ago

    Try this set of three formulas

    parse out the latest entry if newest are being put first.


    Most Recent  Entry
    Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))

    Date of Most Recent Entry
    ToDate(NotLeft(Left([append at top], " "),1))

    Name who did the most recent entry

    NotLeft(Left([append at top], "]"),11)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AmyGosz1's avatar
      AmyGosz1
      Qrew Trainee
      11 months ago

      Thanks for your reply Mark, but none of these include all the information in one field. I would like to display the last entry to include the date and name of the person so the field can be used in a report. If QB allows for showing the last entry if it appears at the bottom, I would think there is a way to show the last entry if it appears at the top.



      ------------------------------
      Amy Gosz
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        11 months ago

        OK, np,

        This tested OK.  Just replace my field on the first line with yours.

        var text RemoveLeadingBracket = NotLeft([Append only at top],1);
        var text MostRecent = Trim(Left($RemoveLeadingBracket,"["));
        If($MostRecent<>"", "[" & $MostRecent)



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
  • BrianSeymour's avatar
    BrianSeymour
    Qrew Cadet
    11 months ago

    Hey Amy, I'm not sure if this is applicable to your use case, but there have been times where we've created an "Activities" child table to help track history. For example, when a given field changes on the parent, trigger a Pipeline to its copy values to the child table. This would include the date/time and User who made these changes. This sets up more straightforward reporting, such as summarizing (counting) the number of changes.

    And you could leverage a "reverse relationship" to pull the most recent changes to the parent record, such who made the last change and when.



    ------------------------------
    Brian Seymour
    ------------------------------