I’ve been trying to implement this and it’s been doing my head in, so hoping you (or one of the other experts) can provide a little more guidance. My app contains a lot of personal info, so I prefer not to share it. I’ll try to describe my setup as best I can.
There are 3 sheets/tables involved.
Users - this is my User Profiles sheet and contains the usual info - name, email address, etc.
Realtime Pool - this is where user selections for any given event go. A user selects 3 players, and their selections go into an array column (
Players). The sheet also contains the user name and email address. Each user may have one or more rows (selections) in this table.
Realtime Players - this is essentially the golfers leaderboard. It has one row for each golfer, which includes their scores and various other related information.
(relevant) Relations and Lookups that I currently have between the 3 sheets:
Users.Picks Relation: links the
Users table to the
Realtime Pool table via email address (matches multiple).
Realtime Players.Picks Key: links the
Realtime Players table to the
Realtime Pool table via Player Name (matches multiple).
Realtime Players.Picked By: shows which punters (users) selected each player by doing a lookup on the
Picks Key relation.
What I’m trying to achieve:
More or less what you described in your previous reply. I want to use a choice component to apply filtering on my
Realtime Players view, with 2 choices. One to show all players, and the other to show only those players I (the logged in user) have picked.
Where I’m stuck:
Basically at step 1. You said:
No problems with the details layout screen or the choice component, but I can’t figure how the user specific column should be defined, or where it should go (in which table). I watched this (awesome) related tutorial by @Robert_Petitto several times and what he describes there is very close to what I need, but again, the penny hasn’t dropped for me yet
Any extra advice would be greatly appreciated.