Virtual Column to return most recent log for activity

[Ms_Margo]

Hi AppSheet Family!

I have a database for customers and each activity they are engaged in. With each activity we have a log to track where each activity is.

Table: Customers (Key=Key; Name = Label)

Table: Customer Activity (Key=Key; Activity Name = Label)

Table: Customer Log (Key=Key; Activity = Label)

I need to create a virtual column in the Customer Activity Table that returns the most recent Customer Log Entry for that specific activity. I have been playing around with MAXROW and SELECT but for the life of me i can’t get it to work.

MAXROW(“Customer Activity Log Entry”, “Timestamp”, select(Customer Activity[Key], in([Related Customer Activity Log Entries], [_thisrow].[Key]))

Am I on the right track? Any suggested apps i can poke around under the hood?

Thanks!