How can I get the content of the last column of another table?

 

I have an application designed for the quota management of a gym. I make a filter [End DateTime]>=TODAY() to know which quotas are active. But I would like to have a view that shows the quotas that are expired and do not have an active quota. I have thought about getting the last cell created in "End DateTime" but I can't get it to work.

How can I do it? I have tried to do a MAXROW but it shows the last date of "End DateTime" of all the users not only of the one in the tab.

In case I have not explained myself I will try to summarize it. I want to have a column that stores the date of the last bookings quota of each client in the Spaces tab (which is the tab table). I could also use a filter. Thanks in advance

I have two tables with the following columns:

Table: Spaces

Columns:
ID - Number
Space - Text
Bookings - List - REF_ROWS("Bookings", "Space")

Table: Bookings

Columns:
Booking ID - Number
Space - Ref Spaces
Start DateTime - Date
End DateTime - Date

 

Solved Solved
0 14 223
2 ACCEPTED SOLUTIONS

You can't just add custom things into the filter toolbar, it only displays columns from that table that are visible and marked as searchable.

View solution in original post

You should start a new post.

View solution in original post

14 REPLIES 14
Top Labels in this Space