# Link a user to several tables

**URL:** <https://community.glideapps.com/t/link-a-user-to-several-tables/22665>\
**Category:** Ask for Help\
**Created:** [February 12, 2021, 9:47am UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665 "2021-02-12T09:47:57Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 12, 2021, 9:47am UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/1 "2021-02-12T09:47:57Z")

</div>

Hi everyone,  
My app allows users to post a review.  
I have a sheet for users with 4 columns.  
 ![Capture d’écran 2021-02-12 à 10.38.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/939546607d28a031d93beb918983ec28e2c3500b.png)

an other sheet reviews which includes the columns that users fill in

 ![Capture d’écran 2021-02-12 à 10.40.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/092d9191e91c70b75e9457c5d9f2a54d0f0e1acb.png)

at first I created a relation between its 2 sheets the problem is that when I post a glide review I save the post in duplicate  
so I delete the relationship and start again from 0

I would like users to be able to see all the reviews and be able to issue multiple reviews and modify their own.

Could you help me solve this problem please ?

---

<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:** [February 12, 2021, 9:53am UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/2 "2021-02-12T09:53:32Z")

</div>

> [@lepetitRider](#):
>
> at first I created a relation between its 2 sheets the problem is that when I post a glide review I save the post in duplicate

So you’re adding 2 rows from a review form, is that correct?

---

<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:** [February 12, 2021, 1:04pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/3 "2021-02-12T13:04:52Z")

</div>

Hey ! Thanks for sharing your issue with the community. In order to help you get the most suitable information based on your problem, I’d recommend you to move your topic to #help-how-to category. You may use this category to ask general questions or get help with something from the community. This will help us to keep the topics organised 🙂

---

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 12, 2021, 3:19pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/4 "2021-02-12T15:19:44Z")

</div>

ok thanks

---

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 12, 2021, 3:22pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/5 "2021-02-12T15:22:07Z")

</div>

> [@ThinhDinh](#):
>
> So you’re adding 2 rows from a review form, is that correct?

Hi, right, that’s what’s going on.

---

<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:** [February 12, 2021, 9:59pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/6 "2021-02-12T21:59:47Z")

</div>

Are you using an add row action on submit?

---

<div class="post-metadata">

**Author:** ![tyler\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tyler_1/32/72341_2.png) [@tyler\_1](https://community.glideapps.com/u/tyler_1)\
**Post date:** [February 13, 2021, 12:13am UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/7 "2021-02-13T00:13:02Z")

</div>

@lepetitRider There are several ways to make this happen? Are you adding two rows per review intentionally?

How I would do this would be to create a relations for something unique (usually users email) between the two sheets. However, you may not have to do this if your reviews are only being displayed on one TAB in the APP. If that is the case, the users email associated with the review would be the “Edit” functions screen. ![Screen Shot 2021-02-12 at 4.09.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/866ed6e0d035fde06cca87bd631fabaa7890e94a.png)  
Set your own Condition for allowing to edit with Something like:  
 ![Screen Shot 2021-02-12 at 4.10.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1acf7a6acd831543c2a2a24ee5f83983a7300703.png)

If you are linking a TAB that points to one sheets and bring in data from another sheet, you will certainly need a relation to make that happen.

I would be happy to help you with that part as well. We would definitely need some more information regarding what you are trying to do though.

---

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 13, 2021, 3:24pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/8 "2021-02-13T15:24:29Z")

</div>

> [@tyler\_1](#):
>
> If you are linking a TAB that points to one sheets and bring in data from another sheet, you will certainly need a relation to make that happen.
> 
> I would be happy to help you with that part as well. We would definitely need some more information regarding what you are trying to do though.

That’s what I did at first.  
I mean I have created a relation in my review table by putting the name and the email and this condition  
 ![Capture d’écran 2021-02-13 à 16.21.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbf964cd85d59c69c894f0b912f98daece2ecf2b.png)

But what happens is that when I fill in the fields of the form to post the review, it gets saved twice.

---

<div class="post-metadata">

**Author:** ![tyler\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tyler_1/32/72341_2.png) [@tyler\_1](https://community.glideapps.com/u/tyler_1)\
**Post date:** [February 13, 2021, 4:27pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/9 "2021-02-13T16:27:27Z")

</div>

Are you using a form to submit entries? If so, do not also use the add new row action. The form is already submitting to the sheet and creating a row.

---

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 13, 2021, 4:34pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/10 "2021-02-13T16:34:32Z")

</div>

Oh ok this must be it tanks I’m going to test

---

<div class="post-metadata">

**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\
**Post date:** [February 13, 2021, 4:36pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/11 "2021-02-13T16:36:50Z")

</div>

I have to put “done” instead of “add” row then ?

---

<div class="post-metadata">

**Author:** ![tyler\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tyler_1/32/72341_2.png) [@tyler\_1](https://community.glideapps.com/u/tyler_1)\
**Post date:** [February 13, 2021, 4:44pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/12 "2021-02-13T16:44:13Z")

</div>

In my app, I use some other actions and then a notification to the user. Let me know if that works for you.

---

<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 13, 2021, 5:36pm UTC](https://community.glideapps.com/t/link-a-user-to-several-tables/22665/13 "2021-02-13T17:36:54Z")

</div>

A form already performs it’s own Add Row action as that’s the whole purpose of a form. Adding an Add Row action on submit is just repetitive. Actions on submit were added as a way for users to add additional actions, such as adding rows to a second or third sheet, setting a column value in the form’s parent sheet or any other sheet, showing notifications, or navigating to a completely different part of the app. The action of adding a row is already built into the form itself. You are not required to add any additional actions on submit unless you want to. The default is usually just a notification saying the form was Sent (Row Added).
