# Setting favourites on behalf of users

**URL:** https://community.glideapps.com/t/setting-favourites-on-behalf-of-users/16651
**Category:** Ask for Help
**Created:** [October 2, 2020, 10:13am UTC](https://community.glideapps.com/t/setting-favourites-on-behalf-of-users/16651 "2020-10-02T10:13:19Z")
**Posts on this page:** 1
**Showing post:** 10

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 12, 2020, 7:31am UTC](https://community.glideapps.com/t/setting-favourites-on-behalf-of-users/16651/10 "2020-10-12T07:31:26Z")

</div>

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:

> [@Jeff\_Hager](#):
>
> create a details layout screen with a choice component that fills a user specific column

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](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932) 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.  
Darren

---

_[View the full topic](https://community.glideapps.com/t/setting-favourites-on-behalf-of-users/16651)._
