Forum Discussion

SarahDriscoll1's avatar
SarahDriscoll1
Qrew Trainee
2 years ago

Report Formula to filter Fields on most recent information.

Hello, I have a request from a team looking to take a notes field and have it only display the most recent update. They want to be able to still edit this field within the table and not go into the...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Are the newest updates being logged at the top or the bottom of the logging field?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SarahDriscoll1's avatar
SarahDriscoll1
Qrew Trainee
2 years ago
They are being logged at the top currently.

------------------------------
Sarah Driscoll
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    My cheat notes say that this crazy formula works

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

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • SarahDriscoll1's avatar
      SarahDriscoll1
      Qrew Trainee
      2 years ago
      I attached a snip of how it looks on my end. When I put it into the report formula, I get the following error. Not sure what I am missing.

      ------------------------------
      Sarah Driscoll
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        2 years ago
        You need to replace the [append at top] with your own field name.  :)

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------