Setting favourites on behalf of users

Ask for Help
10

Hi @Jeff_Hager,

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.

  1. Users - this is my User Profiles sheet and contains the usual info - name, email address, etc.
  2. 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.
  3. 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 :slightly_frowning_face:

Any extra advice would be greatly appreciated.
Darren