# How can users save public list items to user-specific lists?

**URL:** https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252
**Category:** Ask for Help
**Created:** [February 4, 2021, 7:51pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252 "2021-02-04T19:51:28Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)
#### Post date: [February 4, 2021, 7:51pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/1 "2021-02-04T19:51:28Z")

</div>

Please help! thanks in advance 🙂

I have a sheet that contains a list of books (like a database) that displays the list on a tab called “All Books”. I (the admin) will be maintaining the list of books. All users can see the list of books (i.e. no row owners).

I have a separate sheet called “My Books”, and a tab for it in the app. This tab is for users to see the books they have added only (i.e. row owners).

I want users to be able to scroll through “All Books”, click on a book, and have that book show up in “My Books”. Again, users should only see their own books on the My Books tab.

How can I accomplish this?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 4, 2021, 7:59pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/2 "2021-02-04T19:59:56Z")

</div>

Using the built in favorites would be the easiest. Do you need to have a separate My Books sheet with row owners, or can it all be one Books sheet with favorites?

This may be something to check out:

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

---

<div class="post-metadata">

### Author: ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)
#### Post date: [February 4, 2021, 8:28pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/3 "2021-02-04T20:28:29Z")

</div>

@Jeff_Hager I think it needs to be a separate My Books sheet. The reason is I’d like to also create a form to allow users to add other books to their “My Books” sheet.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 4, 2021, 8:32pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/4 "2021-02-04T20:32:01Z")

</div>

Got it. I would probably add a button in the book details screen with an Add Row action that would write that books details to your My Books sheet.

---

<div class="post-metadata">

### Author: ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)
#### Post date: [February 4, 2021, 8:51pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/5 "2021-02-04T20:51:59Z")

</div>

@Jeff_Hager I didn’t realize they had added that! Must have been in the last couple months

---

<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:53pm UTC](https://community.glideapps.com/t/how-can-users-save-public-list-items-to-user-specific-lists/22252/6 "2024-01-17T16:53:30Z")

</div>


