# Allowing users to create private lists?

**URL:** https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704
**Category:** Ask for Help
**Created:** [March 24, 2021, 11:40pm UTC](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704 "2021-03-24T23:40:44Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![adamxboyle](https://avatars.discourse-cdn.com/v4/letter/a/85e7bf/32.png) [@adamxboyle](https://community.glideapps.com/u/adamxboyle)
#### Post date: [March 24, 2021, 11:40pm UTC](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704/1 "2021-03-24T23:40:44Z")

</div>

I have a list of real estate leads that I plan to make available to subscribers. What I’d like to do is allow each unique user to add any number of leads to a personal list that only they can see. Additionally I would like the original list to remain unchanged.

My first idea was, if the user selects a certain lead then I could somehow make them the row owner, but I’m having trouble even doing that. But then that lead would drop off the master list for the other users…

Is there an easy way to duplicate a row and then make the user performing the action, the row owner?

What about creating a different “leads” tab for every new user, with replicated content, and making it only usable for them?

In general if someone can point me to some resources on how to replicate and make data semi-private, that would be super helpful. Thank you!!!

---

<div class="post-metadata">

### Author: ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)
#### Post date: [March 24, 2021, 11:45pm UTC](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704/2 "2021-03-24T23:45:16Z")

</div>

Hey ! Welcome on board, we hope you’ll have a good time here.

> [@adamxboyle](#):
>
> What I’d like to do is allow each unique user to add any number of leads to a personal list that only they can see. Additionally I would like the original list to remain unchanged.

For that, visibility conditions will be your friend.

> [@adamxboyle](#):
>
> My first idea was, if the user selects a certain lead then I could somehow make them the row owner, but I’m having trouble even doing that. But then that lead would drop off the master list for the other users…

You need to enable row owners on the sheets editor whether if you’re using glide sheet or google sheets…

> [@adamxboyle](#):
>
> Is there an easy way to duplicate a row and then make the user performing the action, the row owner?

I’m not so sure about that, you may want to add a button with a specific action in which the row will be added again and therefore related to the row id… but don’t quote me on that.

> [@adamxboyle](#):
>
> What about creating a different “leads” tab for every new user, with replicated content, and making it only usable for them?

Here are some useful ressources in which you’ll find some valuables answers to your questions ⬇

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

> **[Glide Docs](https://www.glideapps.com/docs?q=visibilit%C3%A9)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

Let us know !

---

<div class="post-metadata">

### Author: ![adamxboyle](https://avatars.discourse-cdn.com/v4/letter/a/85e7bf/32.png) [@adamxboyle](https://community.glideapps.com/u/adamxboyle)
#### Post date: [March 25, 2021, 12:15am UTC](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704/3 "2021-03-25T00:15:15Z")

</div>

This is super helpful! I’ll be sure to check out these resources!

Its always when you go to ask someone, that you finally figure it out… Just in case someone is interested in something similar.

So I have the list of leads, I added a button that adds a row with all the same data basically duplicating the row, and also adds the signed in users email to a field “added by”.

Now when they go to their person lead list, I’ve filters for them to only see leads with the signed in user matching the “added by” field.

I think its a messy a low tech way to do it, but its serving as a good enough favorites lists as far as I can tell.

---

<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: [March 25, 2021, 12:44am UTC](https://community.glideapps.com/t/allowing-users-to-create-private-lists/24704/4 "2021-03-25T00:44:11Z")

</div>

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 visibility condition (based on the state of the user specific column) to control which of the two buttons is shown.
