Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
5 years ago

Copying most recent logged note

Let's say I have a parent table called Projects with a notes field.  I then have multiple child tables (Milestones, Approvals, etc.) each with a logged notes field.  I'm trying to create a pipeline that when one of those child table records are modified and a new note has been added, copy that new note to the Projects note field.  I just don't know how to write the pipeline in such a way that it's only capturing the new note and not the entire log of notes.  Would I have to use Actions to paste the new note to a different table and use that record as the source to copy to the Projects note field or is there a way to write the pipeline correctly?

------------------------------
Michael Sargent
------------------------------
Formulas and functions
Pipelines
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    If you use one of these formulas to parse out the part of the update that you want, then your pipeline can just use this clean field.  These formulas will work if the appends are done normally with the newest entries at the bottom.




    Parsing Append Only Fields

    so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.

    Most recent value (formula text field type)

    Trim(Right([my update field],"]"))

    Date of most recent update (this needs to be a formula date field)

    ToDate(Left(Right([my update field],"["),9))

    Who did the most recent update (formula text field type)

    Trim(NotLeft(Left(Right([my update field],"["),"]"),9

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------