# Associate multiple rows from one table to another using checklist?

**URL:** <https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534>\
**Category:** Ask for Help\
**Created:** [December 31, 2020, 6:46am UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534 "2020-12-31T06:46:52Z")\
**Posts on this page:** 18\
**Page:** 2

<div class="post-metadata">

**Author:** ![ray\_d](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@ray\_d](https://community.glideapps.com/u/ray_d)\
**Post date:** [December 31, 2020, 10:18pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/21 "2020-12-31T22:18:37Z")

</div>

Got it to work! Thanks for your help!

Demo for adding items:

 ![demo - add multiple items](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8de679480c2f8d01d902ee7566e6d6c931773e12.gif)

I was also able to find out a way to delete the items from the bucket, however it’s very inefficient. I have a “Remove items” button that links to the ItemsToBuckets sheet, then you select an item from the bucket and delete that item. So it adds a bunch of steps just to delete the item. Do you have a more efficient method?

Demo for removing an item:

 ![demo - remove items](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ffa43bcbb346482f8da90240de693ca5a3fef5f5.gif)

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [December 31, 2020, 10:25pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/22 "2020-12-31T22:25:22Z")

</div>

No I found only the solution that you found. Going over the edit screen to the delete button. Perhaps the experts here have a better solution.

---

<div class="post-metadata">

**Author:** ![ray\_d](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@ray\_d](https://community.glideapps.com/u/ray_d)\
**Post date:** [December 31, 2020, 10:38pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/23 "2020-12-31T22:38:39Z")

</div>

After looking at your Sheet, it looks like you have dedicated columns per Category to track the Checkbox state. What if you want to support a changing category list? Eg. the user wants to add or delete categories? I guess the checkbox solution can only work if you have fixed categories?

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [January 1, 2021, 6:10pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/24 "2021-01-01T18:10:34Z")

</div>

Categories number is fixed, but you can make as many empty categories as you want. List only shows named categories. If a user wants to add a new category s/he could be taken to a tab to name an empty one. The drawback is the time consuming when creating the empty categories and the messy tab with several Inline lists

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [January 1, 2021, 6:14pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/25 "2021-01-01T18:14:13Z")

</div>

You can add a true/false column in the relation sheet to mark the deleted ones and in the add form include a list with items previously deleted [demo app](https://itemscategorias2.glideapp.io/)

---

<div class="post-metadata">

**Author:** ![ray\_d](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@ray\_d](https://community.glideapps.com/u/ray_d)\
**Post date:** [January 2, 2021, 7:25am UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/26 "2021-01-02T07:25:46Z")

</div>

ah yes-- for my use case, I want to support a dynamic amount of categories and items so I can’t have fixed columns. But yes, if I have a use case with fixed categories, the checkboxes is a sweet solution 👌

---

<div class="post-metadata">

**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\
**Post date:** [January 10, 2021, 12:32pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/27 "2021-01-10T12:32:40Z")

</div>

can i have a english version ? im not understand this 😅 🤣

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [January 10, 2021, 1:21pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/28 "2021-01-10T13:21:00Z")

</div>

It’s just “category” and “item”

---

<div class="post-metadata">

**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\
**Post date:** [January 10, 2021, 1:35pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/29 "2021-01-10T13:35:23Z")

</div>

The solution you are looking for is exactly what I’m looking for in [Inline List \> Set columns \> Values from "Screen"](https://community.glideapps.com/t/inline-list-set-columns-values-from-screen/20856)

Instead of choosing from a drop down choice AND hitting submit, we need the “add row” action to use information from “screen” so that while you are in your category, you can simply click a payment method from your inline list to add it to the list of methods.

---

<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:** [January 10, 2021, 3:11pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/30 "2021-01-10T15:11:48Z")

</div>

> [@MonsterGo](#):
>
> can i have a english version

You can translate any app in chrome to any other language. I do this all the time when viewing other people’s apps.

---

<div class="post-metadata">

**Author:** ![ray\_d](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@ray\_d](https://community.glideapps.com/u/ray_d)\
**Post date:** [January 10, 2021, 4:08pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/31 "2021-01-10T16:08:14Z")

</div>

my demo links are in english [Associate multiple rows from one table to another using checklist? - #12 by ray\_d](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/12)

---

<div class="post-metadata">

**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\
**Post date:** [January 10, 2021, 4:59pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/32 "2021-01-10T16:59:49Z")

</div>

did you mind to share me the app ?

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [January 10, 2021, 5:04pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/33 "2021-01-10T17:04:30Z")

</div>

Here is how to check several boxes and add to buckets of choice (bucket 1, 2, & 3)…Just a demo…but you can build on it.

I worked on the CRM template in the store

Thank you

> **[Simple CRM](https://lamentable-business-3579.glideapp.io/)**
>
> Made with Glide from a Google Sheet, without writing any code.

Anyone can make a copy…it is in English

---

<div class="post-metadata">

**Author:** ![Rubel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rubel/32/18867_2.png) [@Rubel](https://community.glideapps.com/u/Rubel)\
**Post date:** [January 10, 2021, 11:50pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/34 "2021-01-10T23:50:18Z")

</div>

Did you use checkboxes for this? I’m creating a tutoring app, and I want a form where my tutors can just check all the subjects they’re proficient in. I’m pretty sure I would use checkboxes, but I can’t find any tutorials on using them. Do you know of any? If not, would I just create a new form, with all the subjects for them to check? Would it have to be a new form/sheet, or could I somehow add it to the existing one? I really don’t know anything because I can’t find a tutorial that focuses just on Glide checkboxes.

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [January 11, 2021, 8:04am UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/35 "2021-01-11T08:04:20Z")

</div>

While the number of teachers and subjects are fixed you only need two tabs:  
One for teachers (Here it is named “Categorías”)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce19949b8add391ddcd766eb6e3500ae8e858462.png)

and another for subjects (named “items” in my example). The drawback is that the second tab must have twice as many columns as the number of teachers : one column is used to check and the other has the id to make the relation

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fa2343503aebbb3fd681abc8d9bd84d46d4f92d.png)  
Glide joins all the name columns and you only see one of them © which is the one used in the relation  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/3278b48d16be385f293ed520f30a665338fd10d8.jpeg)

---

<div class="post-metadata">

**Author:** ![Rubel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rubel/32/18867_2.png) [@Rubel](https://community.glideapps.com/u/Rubel)\
**Post date:** [January 12, 2021, 5:57am UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/36 "2021-01-12T05:57:48Z")

</div>

Thank you.

---

<div class="post-metadata">

**Author:** ![nadiernad](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nadiernad/32/31563_2.png) [@nadiernad](https://community.glideapps.com/u/nadiernad)\
**Post date:** [March 24, 2022, 9:52am UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/37 "2022-03-24T09:52:50Z")

</div>

can you share the copy of this app please, i need this @ray_d

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/38 "2024-01-17T16:49:35Z")

</div>

Closed on January 17, 2024, 4:49pm UTC



[Previous page](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534.md?page=1)
