# How? Relation between and to sheets?

**URL:** <https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055>\
**Category:** Ask for Help\
**Created:** [May 13, 2020, 2:08pm UTC](https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055 "2020-05-13T14:08:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [May 13, 2020, 2:08pm UTC](https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055/1 "2020-05-13T14:08:44Z")

</div>

I have sheet 1 with all users (X, Y, Z), their email-adresses and their budgets  
Besides that I have a sheet per user with all their expenses in it: Sheet X, Sheet Y, Sheet Z.  
Is there a way to link user X from Sheet 1 with its Sheet X ? Same for Y and Z?  
So I can make a page per user with all info?

---

<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:** [May 14, 2020, 11:54pm UTC](https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055/2 "2020-05-14T23:54:25Z")

</div>

This would require 3 separate relations on sheet 1 linking the user email (or name, or whatever) to the same email in each sheet. One the details for sheet 1, you would need 3 separate inline lists against each relation. If the relation is empty, it won’t show anything.

On a side note, this would make more sense to me by using only 2 sheets and one relation. Only because it would scale with the app if you added users instead of having to alter the app for each new user and design each expense sheet separately.

With 2 sheets, you can still create multiple tabs against the same sheet if that’s what you want and filter by the specific user.

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [May 15, 2020, 5:14am UTC](https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055/3 "2020-05-15T05:14:07Z")

</div>

> [@Jeff\_Hager](#):
>
> On a side note, this would make more sense to me by using only 2 sheets and one relation. Only because it would scale with the app if you added users instead of having to alter the app for each new user and design each expense sheet separately.

Yeah, I have the 2 sheets up and running and the relation between the two too. The potential client asked if this would be an option, possibly it gives more a feeling of separation of data per person. And then I thought: yeah why not? I’ll try to stick to two sheets, thanks!

---

<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:** [May 15, 2020, 11:24am UTC](https://community.glideapps.com/t/how-relation-between-and-to-sheets/9055/4 "2020-05-15T11:24:39Z")

</div>

Got it. Setting Row Owners in the sheet would in theory be the same and guarantee that only the user’s email is only visible to themselves and transferred to/from the device.

[https://docs.glideapps.com/all/reference/privacy-and-per-user-data/row-owners](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/row-owners)