# An EASIER and LEANER Trebuchet Method for Multiselect **URL:** \ **Category:** Community Resources\ **Created:** [September 23, 2021, 8:56pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241 "2021-09-23T20:56:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 23, 2021, 8:56pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/1 "2021-09-23T20:56:26Z")
No more ifComma columns, template columns or series of Set Column actions to add and remove items from a multiselect list. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f526312da8feef1017d283377d857228fac49996.jpeg "Glide: A BETTER Trebuchet Method for Multiselect") ](https://www.youtube.com/watch?v=-cdxcucCysg) Thanks to @Jeff_Hager for the inspiration! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [September 23, 2021, 9:45pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/2 "2021-09-23T21:45:25Z")
Just watched your video, very good! You + @Jeff_Hager have made great progress with this ‘conundrum’ I need to have a play around with this but it’s certainly is leaner and appears easier to execute. Hoping in the future we will have something like this built natively in glide…until then this certainly hits the spot. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 23, 2021, 10:31pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/3 "2021-09-23T22:31:35Z")
I know! A basic column \> Array column would be awesome with actions to add/remove from array. 🤤 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 24, 2021, 4:22am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/4 "2021-09-24T04:22:26Z")
Very clever ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 24, 2021, 6:11am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/5 "2021-09-24T06:11:54Z")
Very impressive. ---
**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:** [September 24, 2021, 7:20am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/6 "2021-09-24T07:20:53Z")
To add more context, this is the same method I’ve used for multi-select and to be able to clear selections on multiple rows at once. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… ---
**Author:** ![VVerhille](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vverhille/32/16246_2.png) [@VVerhille](https://community.glideapps.com/u/VVerhille)\ **Post date:** [September 24, 2021, 10:11am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/7 "2021-09-24T10:11:49Z")
Thanks @Robert_Petitto ! Great as usual ! Did not onboard Trebuchet method previously, but now time to go for me !!! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 24, 2021, 10:57am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/8 "2021-09-24T10:57:09Z")
Thanks for giving us proof of concept, @Jeff_Hager! ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [October 1, 2021, 11:11pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/9 "2021-10-01T23:11:58Z")
Hello, Robert! If several users will try to use this simultaneously, then they will be overwrite each other temp ids in a item sheet How to implement this method without any write operation in item sheet, just in user sheet, users row? ---
**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:** [October 1, 2021, 11:22pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/10 "2021-10-01T23:22:13Z")
As long as you use a user specific column to hold the ID, then it won’t interfere with other users. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 1, 2021, 11:27pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/11 "2021-10-01T23:27:58Z")
Make sure the temp ID is a user specific column or in the user sheet…then it will be user specific and won’t overwrite someone else’s data. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [October 1, 2021, 11:50pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/12 "2021-10-01T23:50:17Z")
Thanks you’re guys, very much! About user specific - is looks well, thanks! But another reason, it to reduce value of writing operations to google table. Off course wee can copy it to glide table but, may be this is not so good idea? ---
**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:** [October 2, 2021, 2:57am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/13 "2021-10-02T02:57:10Z")
User specific columns are only stored in glide. It doesn’t matter if you add them to a glide table or a google sheet. It will always store the value inside of glide, so you shouldn’t have to worry about any write operations to google sheet when you are only changing the value in a user specific column. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [October 2, 2021, 3:34am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/14 "2021-10-02T03:34:54Z")
Thank you Jeff! It is very useful comment for me! ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [October 2, 2021, 3:37pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/15 "2021-10-02T15:37:46Z")
@Robert_Petitto The last section where you display an inline list with the value of rel-itemIDs, I noticed that I am unable to get that list. I can only see the rel- that is under my Users profile. Any idea why? I have followed the video a few times with same result. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 2, 2021, 3:40pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/16 "2021-10-02T15:40:41Z")
Did you make the relation a multiple relation? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [October 2, 2021, 3:45pm UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/17 "2021-10-02T15:45:17Z")
Yes I did. And only through this exercise, I realised I can only access relations that are from the Users table. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [October 3, 2021, 1:27am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/18 "2021-10-03T01:27:04Z")
I have also tried on my second app, it is the same result. I can only access/display relations from Users table. Are you using advanced features which are in testing? Anyone else having same issue as I have? Thanks. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 3, 2021, 2:25am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/19 "2021-10-03T02:25:40Z")
No…no advanced features. > **[Better Trebuchet · Glide](https://www.loom.com/share/a9610d9b323e484eac68d054f938ba72)** ---
**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:** [October 3, 2021, 2:47am UTC](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241/20 "2021-10-03T02:47:59Z")
Can you post a couple of screen shots or a short video? [Next page](https://community.glideapps.com/t/an-easier-and-leaner-trebuchet-method-for-multiselect/32241.md?page=2)