Need help to understand wether I can move selected rows to another table using Glide API

Hi Guys,

I had previously followed this video

To iterate through every row and create the entries again on click of a button.

Is there a way possible that I can move only selected rows by using the same approach?

My Idea:

Give a user selected boolean value and then → use the functionality to move the rows in which boolean is true.

My Use case:

I will have multiple names in each rows → I want to be able to select all when filtered List gives me the output the selected people Need to be moved to a different table.

Question1: I use Data Grid view, Any way I cal select multiple rows by just once single click

Just like below when I select the tick mark next to Name it selects all items that’s there in filtered view

How do I do it?

Question 2 Can I make use of Glide API to move only selected items?

Using the video approach shown above?

Thank you in advance for your help.

Regards,
Dilip

All you really need is an if-then-else column:

  • If Boolean is checked, then “Row Mutation”

Then instead of aggregating the mutations for all rows, you just aggregate the if-then-else column.

1 Like

Thank you for responding @Darren_Murphy

Ok,

What about selected the filtered rows with single click?

Meaning : Ill use filter to get list of 10 items from 100 rows

In one single click can I select all 10 items rather than having to do it individually?

Regards,
Dilip

That would be possible if you are using a Custom Filter, but it’s quite complicated to set up.

Oh ok, Custom filter would be difficult to set up?

If I can be able to select multiple rows on Filter item by single click and then move all using the mutation technique you mentioned it’ll resolve a big Flow problem for me.

Is it possible to do it at all?

Regards,
Dilip

Have a watch of the below video. You could use a similar technique that I describe there for the Select All/Select None.

https://www.loom.com/share/8b4cc9964e7f42099ace02b314f99434

2 Likes

Thank you @Darren_Murphy Let me go through it right away.

Regards,
Dilip

It probably won’t help you with the custom filtering part, but there are plenty of other videos around that show how to do that.

For custom filter I can use query column right? Would that work?

On query result which I display can I apply Select all?

Would it work?

Regards,
Dilip

Hi @Darren_Murphy

Thank you for responding

I figured I can use Query column to get custom filter item on my table and get response.

How do I Add All column in user table to get this query elements?

Meaning I have used query column to get filtered list of rows.

Now these are stored in the table.

How do I get the response into Lookup table in users column where you have Add all?

Regards,
Dilip

Sorry About Barrage of questions @Darren_Murphy

I got it to work with query as well.

Was Wondering of this customisations is possible?

  1. I got it working with select all
  2. Single selection and removing.

Is it possible for me to remove items from select all options

Meaning my query will give me custom filtered option

Question 1: When I select all how can I make all the hero icons of that list turn green?

Question 2: How can I remove some items from that List which has query response?

SO that unselected items are not sent to another table?

Thank you in advance

Regards,
Dilip

Late comer to the thread so please pardon me if I miss something.

Wouldn’t it depend on your “boolean” that you are using to know if a row is selected or not? If you already know which state a row is in, you can create if-then-else columns to drive a hero icon column, or create two hero icon columns based on checked/unchecked scenarios, and then an if-then-else column based on the boolean to show the right icon.

What’s your use case for this? Can you show us how you’re configuring that part? I was thinking of a screen where your users can check/uncheck items, and the “Select All”/filter part is just add-ons whilst checking/unchecking is preserved as an option.

Will check this approach now and get back to you.

My use case got a little complicated here. I have two scenarios

  1. I will apply Custom filter using query to get filtered list of 10 or lesser items from 100 items → I display this filtered Item → Allow select all using the above method mentioned by @Darren_Murphy This works fine
  2. I will apply Custom filter using query to get filtered list of 10 or lesser items from 100 items → I display this filtered Item → Allow select all using the above method mentioned I would want to de select few items from the filtered List which has all items selected

This is where I am facing some sort of issue —> Could you explain your approach where you said "Thinking os screen where we can check un check items? That approach would work for me

Let me know if this gives better clarity?

Hi Dilip, I am pretty late to this conversation but can you please share a screenshot if possible. That would help us better understand how this is set-up. For your second use case, you can just give your users some input method to select and un-select some items. This can be a button on every entry which you can enable in advance actions section of your collection