How to pull history in from other table

[agoodman]

I’m trying to pull in a list of all other books a group has checked out previously. The formula that is working in another doc is to use a lookup to my Book table. Then the formula:

[Checkout Log].Filter([Book Group]=thisRow AND Book!=thisRow.[Current Book]).Book

For my new document), writing a similar formula doesn’t work. My original doc is almost identical to the current one. My end game here is that I’ll then be able to create a table view in the Detail display for this Book Group. I.E.

The document I’m working in:

[Jean_Pierre_Traets]

Dear @agoodman,

I saw you reacted in the past to this post, did you concern it the method?

Capture `History` of changes / Create Log of changes to important value of record

Hi, At times, I feel like I want to preserve history of changes to important column in a record (while coda has built-in change tracking and you can see that inside Row Activities - it is hard to query that changes or create a log of all the changes. Here’s what I use in some of my documents and has worked out really well. Example use case here is: I have Projects and I want to make sure all changes to Project Cost for each project is captured as history. The steps are: create Projects Ta…

Credits to @Krunal_Sheth