+6I 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?
+22Try 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)
+4Hey 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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
