We have amassed thousands of rows of data after using the app for the last few months (yay!). I have a security filter that only shows today’s data in the app ([Date]=TODAY(), where [Date] is a column in the table). That works great.
We’re using Google as the backend.
I want to allow one of the users to display and generate reports on demand for any day. Rather than reading in thousands of rows I have created a table, called View Date, that allows them to specify the date they want to view data for.
The challenge:
Is it possible to have the security filter check the value in a column in View Date? Something like:
[Date]=View Date[Date]
If so, what is the syntax? Can I use SELECT (the syntax for which is impossible to find in the documentation)? We would then sync to refresh the data view.
EDIT:
I realized I can use MAXROW to get the date specified by the user in ViewDate (rows are keyed by timestamp). I’ll give that a try and will report.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |