# How to add items to a collection by toggling a boolean + setting a column at the same time? **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [May 23, 2025, 9:25am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997 "2025-05-23T09:25:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 9:25am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/1 "2025-05-23T09:25:33Z")
Hey everyone! I’ve been going in circles trying to solve this and could really use a fresh perspective cause I’m not sure if this is something incredibly obvious that I am missing, or out of the scope of what glide offers. This is all completely new to me so I’m in a whole different world right now and tbh surprised I’ve made it this far😅 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/9000375fa4a8d6d9e9a8f1443f6dd261eddeaab5.jpeg) I’m building a digital wardrobe and have most of the core features working already: - A master wardrobe table holding all of my items - Filters for categories like Tops, Bottoms, etc. using a multi-select chip setup tied to a user-specific working table (so it works even when logged out) - A card collection to display the items visually - Details page on each item with additional information, photos, and the ability to edit the data ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4fdc570da00c28f48b7baab056de1ca20981d907.jpeg) Now I’m working on a way to create and manage additional custom wardrobe collections – such as “Goth Wardrobe” – where I can view filtered subsets of the main wardrobe without duplicating items, so that everything remains in sync, but I am having trouble doing this and I am going around in a loop. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbe2f82ddb6bf1e7fcdab34b25f107240a5b94ad.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2dd125fecb1cb705f8051aad6d54814f5adc2e8a.jpeg) Here’s what I’ve set up so far: - A Wardrobe Collections table - A page that displays these collections in a grid (collection cards) - A button to create new collections via a form - Clicking a collection opens its detail screen - Inside that screen, I show a filtered wardrobe collection (using a boolean is selected toggle) - There’s an “Add Items” button that opens a screen with all wardrobe items as cards - Card click triggers a workflow that toggles a boolean (Add-Item Selected) and visually marks the card with a ✅ emoji This setup works perfectly **for one collection** … but here’s where I’m stuck: Right now the boolean isn’t collection-specific, so I can’t reuse it across multiple collections without either: - Duplicating the logic and adding a separate boolean column per collection (which obviously doesn’t scale, especially if I were to add user support in the future) - Or switching to something more relational (which I’m not sure how to build cleanly here) What I want to achieve: - Click to “select” items (using that boolean) - When ready, hit a “Confirm Add” button that adds the current collection’s name into a text column called Collections on each selected wardrobe item - This should allow items to exist in multiple collections, separated by commas (e.g. Goth, Vintage) Bonus: I do plan to add a dropdown field on the item edit screen so users can manually assign an item to collections — just like how item types are set. That part’s easy and works great for one-off changes. But what I really need is a proper bulk add system: a dedicated “Add to Collection” page where users can select multiple items at once and assign them to a specific collection without editing them one by one. That’s the core of what I’m trying to build here. Any suggestions on the cleanest way to achieve this without rebuilding the whole flow for every collection? I feel like I’m missing something incredibly obvious here 😅😂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 9:36am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/2 "2025-05-23T09:36:36Z")
I think I’d suggest a slightly different approach. Instead of adding a list of Collections to the Items row, I’d add a list of Items to each Collection row. The Multiple Texts column would work well for this. It would allow you to store an array of ItemIDs in each collection row. You could then use it as a filter on a Collections details screen (or use it to build a relation to Items, which in turn could be used as a source of a Collection component). To add items, use a combination of Make Array plus Set Column Values. To remove items, use a combination of Remove Element plus Set Column values. To add multiple (selected) items at once, create a query column that matches all selected items, then do a lookup through the query to get an array of ItemID’s, then use that in the Make Array column. You’re obviously a quick learner, so hopefully I’ve given you enough to get to a solution. Let me know if anything doesn’t make sense, or needs elaboration. ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 9:53am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/3 "2025-05-23T09:53:36Z")
AHHH thank you, this is the most progress I’ve made so far. I get stuck after making the array. I made the query, lookup and array in a new blank working table, but i’ve run into the issue where I can’t select the array for my button because the source of the collection is the wardrobe collection table, not the “collection picker” working table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1652c5e2331b0c5ebeeacefd430ec16fcffad56.jpeg) Should i remake those in the wardrobe collection table for it to work? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 9:58am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/4 "2025-05-23T09:58:10Z")
> [@Pinipy](#): > > Should i remake those in the wardrobe collection table for it to work? Either that, or you should be able to use a Single Value column to fetch the array. That said, I think it’s better in the Collections table, because if you’re adding items to an existing collection you’ll need access to the saved array. ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 10:02am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/5 "2025-05-23T10:02:09Z")
Yeah thats what I thought, the button will show other single value options but not the one I just made ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d1083f6d665f77933e7f54e92dc3562314917c46.png) ![Screenshot 2025-05-23 200027](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2edca19054ee9bfef095862a3ca1412527e8dd47.png) I’ll try rebuilding the Query, lookup and array from within this table instead of pulling it in via single value ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 10:11am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/6 "2025-05-23T10:11:46Z")
Hmm, even doing this from collections - it seems I cant select an array, lookup OR query for the “set column values” action. Am I meant to use a different action? ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 10:39am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/7 "2025-05-23T10:39:13Z")
I changed the action to “array to set” which seems to write the selected ID’s into the “item ids” column - however I am now trying to make this final collection filter from those ID’s. The Item IDS column is in the wardrobe collection table whereas the component card collection is pulling data from the “wardrobe” table 😅 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 10:52am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/8 "2025-05-23T10:52:56Z")
You should use the Make Array column in the Set Column Values action to write the array into the Multiple Texts column. ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 11:01am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/9 "2025-05-23T11:01:04Z")
When I try to do that it doesn’t show the Array as an option to select from. 😭 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 11:16am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/10 "2025-05-23T11:16:59Z")
Are you definitely using a Multiple Texts type column as the target? It’s a special column type that stores non-computed arrays. ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 11:18am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/11 "2025-05-23T11:18:49Z")
I don’t see any multiple text columns Unless you mean this one? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce321a4a694e328151c53a56f9a4dc3e649d580f.png) ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 11:28am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/12 "2025-05-23T11:28:52Z")
OH! I had to enable it. Okay - I have the button working and the ItemID is now a multiple text column. I need to somehow get the data from ItemID to show up in the Wardrobe table so that i can filter the collection to show only items selected with rowid for that collection ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 11:35am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/13 "2025-05-23T11:35:47Z")
Okay I FINALLY got it to work, however, because the “Wardrobe Collection” page includes cards that serve as each collection, the filters are shared across it so it just shows the same data. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 11:59am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/14 "2025-05-23T11:59:23Z")
Not sure I understand what you mean, can you show me? ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 12:12pm UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/17 "2025-05-23T12:12:40Z")
Sorry, it kept uploading the wrong gif ![ezgif-66f846c35422c1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/973764f15b4bce950c85171f5d92fb5b6fd80700.gif) It seems any new collections are sharing the filters from the original one ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 12:29pm UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/18 "2025-05-23T12:29:26Z")
Sorry, the gif is quite difficult to follow. I can’t pause it, and I can’t read the collection filters. Any chance you can make a loom video - or at least show me a screen shot of your collection filters? ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 23, 2025, 12:57pm UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/19 "2025-05-23T12:57:42Z")
https://www.loom.com/embed/a82d50ee11f446ca89d5972d3ce9ffd0?sid=d57eda37-da60-420a-9336-7167e6322a06 I think I figured out loom?! 😅 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 1:15pm UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/20 "2025-05-23T13:15:08Z")
The column below looks suspicious. Can you show me how it is configured please? ![CleanShot 2025-05-23 at 21.14.01@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abf2b3f96156e550d46889bdc3625466f22f8b6e.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 23, 2025, 2:48pm UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/21 "2025-05-23T14:48:49Z")
As per our side conversation, I created a simple copyable template to demonstrate one possible solution. The template demonstrates a couple of slightly advanced techniques: - Using a Collection as a multi-select choice component - Using a single Custom Form for both creating new Collections, and editing existing ones. > **[Collection Multi-Select Concept](https://go.glideapps.com/template/BTuejUYX6AziNzc5QEcO-template-published?privateTemplateToken=yL69Vv7iIks2oB53GG1v)** ---
**Author:** ![Pinipy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pinipy/32/90426_2.png) [@Pinipy](https://community.glideapps.com/u/Pinipy)\ **Post date:** [May 24, 2025, 7:09am UTC](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997/22 "2025-05-24T07:09:57Z")
Thanks to Darren’s incredible help I was able to get this done!! [Next page](https://community.glideapps.com/t/how-to-add-items-to-a-collection-by-toggling-a-boolean-setting-a-column-at-the-same-time/81997.md?page=2)