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?