An EASIER and LEANER Trebuchet Method for Multiselect

[Robert_Petitto]

No more ifComma columns, template columns or series of Set Column actions to add and remove items from a multiselect list.

Glide: A BETTER Trebuchet Method for Multiselect

Thanks to @Jeff_Hager for the inspiration!

[Rosewebstudio]

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.

[Robert_Petitto]

I know! A basic column > Array column would be awesome with actions to add/remove from array.

[Lucas_Pires]

Very clever

[Dan_San]

Very impressive.

[Jeff_Hager]

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

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…

[VVerhille]

Thanks @Robert_Petitto ! Great as usual ! Did not onboard Trebuchet method previously, but now time to go for me !!!

[Robert_Petitto]

Thanks for giving us proof of concept, @Jeff_Hager!

[slscustom.ru]

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?

[Jeff_Hager]

As long as you use a user specific column to hold the ID, then it won’t interfere with other users.

[Robert_Petitto]

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.

[slscustom.ru]

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?

[Jeff_Hager]

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.

[slscustom.ru]

Thank you Jeff! It is very useful comment for me!

[Mns_Glide]

@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.

[Robert_Petitto]

Did you make the relation a multiple relation?

[Mns_Glide]

Yes I did. And only through this exercise, I realised I can only access relations that are from the Users table.

[Mns_Glide]

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.

[Robert_Petitto]

No…no advanced features.

Better Trebuchet · Glide

[Darren_Murphy]

Can you post a couple of screen shots or a short video?