Thanks for the recommendation! Just for documenting info here's what I did:
- Created a Users table that had an ID column (for a unique key, but I don't use UNIQUE() I use my own), User Email Column, and Desert Type ID.
- In the View under behavior, when row is selected I had it set to a Group Action.
- Create 3 actions: 1 that group action that calls the following: 1 that does the standard behavior of opening the detail view (using go to another view within the app utilizing LINKTOROW), and the final action that uses Data: add a new row to another table using values from this row): this writes the user Email as well as the Desert Type ID that was clicked to the User table.
- Added a security filter to get the most recent Users value that was written (or just clicked by the user):
IN([DESSERTTYPEID],
SELECT(
User[DESSERTTYPEID],
MAX(
SELECT(User[ID],USEREMAIL()=[User Email],true)
) = [ID],true
)
) - I'll probably run a nightly script to clear out the Users table as it's really just a transactions table of what they clicked on.
LinkedIn
Twitter
