Report Formula to filter Fields on most recent information.

Question

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 form or another table to make changes. Truly a one stop shop for processes.The field is currently logging edits. I thought this formula would work within the report:var text LogField = [Notes];If(Trim($logField)&lt;&gt;"", "[" &amp; Left(NotLeft($LogField,"["),"["))I am having no luck with it filtering down to only the most recent. Is there any formula that could do this and still allow for them to edit the field?------------------------------Sarah Driscoll------------------------------

markshnier__you · Answer

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 · Answer

They are being logged at the top currently.------------------------------Sarah Driscoll------------------------------

markshnier__you · Answer

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 · Answer

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 · Answer

You need to replace the [append at top] with your own field name.&nbsp; :)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Report Formula to filter Fields on most recent information.