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 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)<>"",
"[" & 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
------------------------------
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)<>"",
"[" & 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
------------------------------
