# User specific tables
**URL:** https://community.glideapps.com/t/user-specific-tables/26351
**Category:** Ask for Help
**Created:** [May 3, 2021, 4:59pm UTC](https://community.glideapps.com/t/user-specific-tables/26351 "2021-05-03T16:59:10Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 4:59pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/1 "2021-05-03T16:59:10Z")
Hi,
Coming to Glide as frustrated with Appsheet user costs and lack of customizable domain.
I want to recreate the action behaviour I achieved in Appsheet: I prepare custom lists for each user, which they can select items from. The selected items then appear in a ‘my items’ list, which also automatically populates a google order sheet. User will also need to log in and the list displayed will be mapped to the user’s log in details.
Is this doable and scalable to hundreds of users? Is there a template that could kickstart this?
Many thanks!
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 5:26pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/2 "2021-05-03T17:26:01Z")
Please note, the main criteria with this is the possibility to have many google sheet data sources (at least one for each user). I’m happy to export user-generated lists if the app cannot populate a googlesheet.
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [May 3, 2021, 5:28pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/3 "2021-05-03T17:28:11Z")
Hi, welcome on Glide!
If I understand well, you would like that Entering a custom list of items create automatically a new **sheet**? (not a new **row** )?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 3, 2021, 5:35pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/4 "2021-05-03T17:35:41Z")
> [@FMhires](#):
>
> Please note, the main criteria with this is the possibility to have many google sheet data sources (at least one for each user). I’m happy to export user-generated lists if the app cannot populate a googlesheet.
You can only use a single GSheet as a data source for a Glide App. However, you could have several other GSheets feeding data to that source sheet using something like importrange.
NB. When I say GSheet, I mean Google Spreadsheet. You can have as many sheets (tabs) within that spreadsheet as you want.
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 5:39pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/5 "2021-05-03T17:39:00Z")
Yes, exactly - the action on appsheet is ‘add a new row to another table’
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 5:41pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/6 "2021-05-03T17:41:05Z")
The problem with that is scalability. The master list would just grow and grow. I presume there would be a way to assign certain parts of the data to certain users?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [May 3, 2021, 5:42pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/7 "2021-05-03T17:42:11Z")
OK, but the “another table” is not created by appsheet, is it?
My guess is that you have already created the tab, and you choose the where the new row should be added; otherwise, I don’t think (?) that Glide enables to create automatically new tabs (except the ones it creates for itself, such as “comments”, “logs” etc).
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 5:43pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/8 "2021-05-03T17:43:03Z")
No, it’s a google sheet that is mapped as an output location with the same column fields as the data source but blank rows
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 5:45pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/9 "2021-05-03T17:45:40Z")
For context, we have subscribers so I would like them to be able to access their lists ongoing.
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [May 3, 2021, 5:52pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/10 "2021-05-03T17:52:35Z")
What is tricky I guess, is to display the customized list of a given User, while she/he is not logged-in.
How can the app know what list to display?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 3, 2021, 6:02pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/11 "2021-05-03T18:02:29Z")
> [@FMhires](#):
>
> I presume there would be a way to assign certain parts of the data to certain users?
Yes, Glide has a feature referred to as Row Owners, which essentially assigns ownership of rows of data to individual users (or groups of users), identified by email address. With row owners enabled, users will only have access to their own data.
> **[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!
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 6:09pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/12 "2021-05-03T18:09:49Z")
They would need to log on to see the list, so row owners should solve this? The only issue now is the data source. I am going to meet the row limit pretty soon if all user lists have to be in one source document.
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [May 3, 2021, 6:11pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/13 "2021-05-03T18:11:37Z")
There may have a method to limit the use of rows know as “Trebuchet” method, by @Lucas_Pires (it’s quite advanced): [[Tutorial] Trebuchet Method 🔗 - List of Items/users in one cell!](https://community.glideapps.com/t/tutorial-trebuchet-method-list-of-items-users-in-one-cell/25688)
I don’t know if it applies in your case.
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 6:13pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/14 "2021-05-03T18:13:55Z")
Hmm, this seems precarious and fiddly. I feel like I need a solution that is part database part UI. Glide might not be the thing.
---
### Author:  [@FMhires](https://community.glideapps.com/u/FMhires)
#### Post date: [May 3, 2021, 6:14pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/15 "2021-05-03T18:14:25Z")
Thank you both so much for your time though
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [May 3, 2021, 6:17pm UTC](https://community.glideapps.com/t/user-specific-tables/26351/16 "2021-05-03T18:17:39Z")
You’re welcome. If the issue is the row limit, maybe is there something to workaround with:
- “delete rows” actions after order is submitted (potentially by adding a Timer)
- and the “trebuchet” method above to store the information
I think that this is something for experts such as @Jeff_Hager, @Robert_Petitto or @ThinhDinh