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! Go to Solution.
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.
You should start a new post.
User | Count |
---|---|
34 | |
8 | |
2 | |
2 | |
2 |