# Link two checkboxes from different sheets

**URL:** <https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684>\
**Category:** Ask for Help\
**Created:** [May 24, 2020, 3:44pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684 "2020-05-24T15:44:47Z")\
**Posts on this page:** 10\
**Page:** 2

<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 27, 2020, 3:34pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/21 "2020-05-27T15:34:36Z")

</div>

You wouldn’t have this problem if the email was being written to the form response sheet. The only time I’ve seen the form not write the user’s email is when they weren’t signed in. Also your detail view for the user’s sheet should be filtered by signed in user, so the user is only viewing their own record. My only thought at this point is for you to follow the steps I outlined above, then create screenshots of your relation column, lookup column, the form button settings, and the list of components on your form.

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 27, 2020, 3:36pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/22 "2020-05-27T15:36:31Z")

</div>

Good! Thanks you! Now I will do everything!

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 27, 2020, 4:18pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/23 "2020-05-27T16:18:54Z")

</div>

I did everything as you said, everything works! But here the problem is in writing the email adress! That is, when the user clicks the button to become a seller, he throws him to the policy page where he puts the checkbox and clicks the button, after that he throws it to the admin panel. But here the problem is that the policy record itself is already written in the table and it is not updated email adress too, but as soon as you start editing and sending it, then it is saved again in the same cell and the email is overwritten.

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 27, 2020, 4:24pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/24 "2020-05-27T16:24:42Z")

</div>

![Снимок экрана 2020-05-27 в 19.21.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/25717b4683ef70909ce1dd37c275ec24498a8316.png)

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 27, 2020, 5:32pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/25 "2020-05-27T17:32:33Z")

</div>

At the moment, if I go into my personal account and click the “become a supplier” button, I go to the agreement sheet with the mail boxes, checkbox and the letter of agreement, check the box and press the button, then my email is not recorded!!! But if I click to edit this sheet, I’ll change anything, even send one letter, then my email will overwrite the previous one in the same cell.

---

<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 27, 2020, 6:04pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/26 "2020-05-27T18:04:58Z")

</div>

That means you are not using a form button like you said you were and like I instructed. A form will write a new row each time its submitted.

That’s why I ask for screenshots of all of your settings. Otherwise I can only take your word for it.

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 31, 2020, 11:41pm UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/28 "2020-05-31T23:41:41Z")

</div>

Hi Jeff!  
Can help me?!) There are two columns: Countries and cities!  
How to make sure that when choosing a country in the first drop-down list, in the second you can choose the cities of this country ???

---

<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:** [June 1, 2020, 12:13am UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/29 "2020-06-01T00:13:54Z")

</div>

Ok I have received your personal message as well, I will make a test data to show you what you need to do, later today.

---

<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:** [June 1, 2020, 12:27am UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/30 "2020-06-01T00:27:46Z")

</div>

> [@Dependent drop Lists](https://community.glideapps.com/t/dependent-drop-lists/10103/2):
>
> Here’s a demo of what you can do. I have a list of cities and their capitals like this. [image] In the Glide data, add a “Country choice” column that will be linked with your choice component. This column must be user-specific. In the Glide data, add a relation like this. Then in the interface, add a city choice that is set up like this. Here it is in full flow. [ezgif-3-e7c725115081]

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [June 1, 2020, 4:34am UTC](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684/31 "2020-06-01T04:34:25Z")

</div>

Thank you! I’ll try to do as you showed!)

[Previous page](https://community.glideapps.com/t/link-two-checkboxes-from-different-sheets/9684.md?page=1)
