# Create User Lists of Items

**URL:** https://community.glideapps.com/t/create-user-lists-of-items/27715
**Category:** Ask for Help
**Created:** [June 6, 2021, 6:31pm UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715 "2021-06-06T18:31:10Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)
#### Post date: [June 6, 2021, 6:31pm UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/1 "2021-06-06T18:31:11Z")

</div>

I’m struggling to accomplish something that I would have thought to be simpler and I can’t seem to find any examples on here.

I have a list of items that is the main content of the app. What I want to accomplish is to allow users to create multiple named lists of their favorited or bookmarked items. You see this sort of thing in many apps (AirBnB, for example lets you create multiple lists of favorites items with each list having a different name). I’ve created a table called user lists which I have successfully create a form to allow users to create named lists that only they can see. But haven’t figure out how to be able to create a form in which, while browsing the main list of items, they can click on it and add it to one of their lists.

This is close:

> [@Allowing users to create private lists?](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704/4):
>
> Possibly a cleaner approach would be: Firstly, ensure your Leads table has a Row ID column Next, add a User Specific boolean column. Call it “My Leads” or similar. When a user is viewing a lead, present a button labeled “Add to My Leads” The action on that button would set that user specific column to true Now, to filter by “My Leads” you use “My Leads is true” You could also have a second button to remove a lead from My Leads, which would set the user specific column to false, and use a vis…

But this assumes only one list, (also, I don’t see how that’s functionally much different than the built in “Favorites” function, but maybe I’m missing something that would tell me how to use this to accomplish my goal). What would be an ideal expansion of what is described in that post is that the user clicks “Add to my lists” and can choose one of their existing lists to add the item to.

Any suggestions or links to other posts that I may have missed that describe how to build this functionality?

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 6, 2021, 6:56pm UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/2 "2021-06-06T18:56:20Z")

</div>

You’re on the right track. Here’s what I would do:

1. In the sheet of `items`, create a user specific text column called `userList`.
2. In your `user_lists` sheet that you already created, add a `rowID` column. Create a multiple relation column called `rel_userListItems` that points the `rowID` column to the `userList` column in the `items` sheet
3. On the details screen of each item, place a **choice component** that has a source of the `user_lists` sheet.
  - Values = `rowID`, Display = `listName`, Destination = `userList` column
  - It should be filtered to where email is the signed in user so each user only sees their own lists.  
from the `user_lists` screen

4. Now, each `listName` has an individualized list of items. Display the `rel_userListItems` relation in an inline list on the details page of each list created in the `user_lists` screen

---

<div class="post-metadata">

### Author: ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)
#### Post date: [June 6, 2021, 9:31pm UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/3 "2021-06-06T21:31:19Z")

</div>

Thank you! That worked like a charm and I learned something in the process. I didn’t realize that the choice component writes the value immediately. It doesn’t need to be in a form with a submit button. Whoop!

But it did point up an additional issue:

This solution works great if each user only wants to put each item on one list. But I was hoping that “Item ABC” could be on User1’s “My First List” and also on “My Second List”. This solution only allows each user to have a given item on one list. Any ideas how to have the same item on multiple lists? Probably a tad more complicated…

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 7, 2021, 1:06am UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/4 "2021-06-07T01:06:04Z")

</div>

Yes, it would be more complicated. You’d probably need to use our trebuchet method which is too lengthy/involved to type out. Search the forum for the Trebuchet method if you’re interested.

---

<div class="post-metadata">

### Author: ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)
#### Post date: [January 4, 2023, 9:41am UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/5 "2023-01-04T09:41:30Z")

</div>

Hey there - this was super useful, but unfortunately doesn’t quite work.

I have a main user list, and want them to select from a list of companies. Each has a profile and info and I want to let users toggle ‘Add to my list’ and from there they will then be displayed in their profile.

I can’t seem to get this to work but followed the above instructions.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 5, 2023, 12:50am UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/6 "2023-01-05T00:50:38Z")

</div>

So does each user only have one list, or multiple lists?

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/create-user-lists-of-items/27715/7 "2024-01-17T16:49:11Z")

</div>


