# Duplicate a filtered table

**URL:** https://community.glideapps.com/t/duplicate-a-filtered-table/70889
**Category:** Ask for Help
**Created:** [February 16, 2024, 4:56pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889 "2024-02-16T16:56:36Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Rafa\_flama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafa_flama/32/70966_2.png) [@Rafa\_flama](https://community.glideapps.com/u/Rafa_flama)
#### Post date: [February 16, 2024, 4:56pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/1 "2024-02-16T16:56:36Z")

</div>

Hello all!

I have this situation: I have a table called “Episodes Raw” where I have information from a RSS. Also, I added a boolean check list option so the user can select which episode to get data from.

In this case, you can see the user selected 3 of the rows.

I need to bring those 3 rows with all data to another table to treat the data there. But when I try to do that (I’ve used several types of columns) I end up getting nothing or all the episodes in one row.

My perfect output would be the same columns as the table “episodes raw” filtered by the boolean “true” rows.

is that possible to achieve automatically?

thanks for the help!!

 ![Screenshot 2024-02-16 at 17.52.42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b310b8795d6fb6ffa0ca5be08bb027a6864cb0fe.jpeg)  
 ![Screenshot 2024-02-16 at 17.52.50](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c2c25e90a6799ebf25e0655d7930abd57e1af6f.jpeg)

---

<div class="post-metadata">

### 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: [February 16, 2024, 5:05pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/2 "2024-02-16T17:05:04Z")

</div>

Perhaps a silly question, but why do you need to move the data to another table?

Why can’t you just work with it where it is, and apply approriate filters on the front end?

---

<div class="post-metadata">

### Author: ![Rafa\_flama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafa_flama/32/70966_2.png) [@Rafa\_flama](https://community.glideapps.com/u/Rafa_flama)
#### Post date: [February 16, 2024, 5:14pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/3 "2024-02-16T17:14:12Z")

</div>

Thanks Darren,

for 2 reasons:

- the google sheet table takes time to load all data, and I do not want to make it worse
- This table is going to be temporary, so every day data will be removed, however, the results one is going to be stored for the user

Hope this makes sense. Please tell me otherwise! 🙂

thanks!

---

<div class="post-metadata">

### 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: [February 16, 2024, 5:34pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/4 "2024-02-16T17:34:54Z")

</div>

Okay, well to move (copy) multiple rows from one table to another in a single step would require using the Glide API.

If it’s only ever going to be a small number of rows, it would probably be easier to have the user click them one by one to move. You could even do that as the user is making the selections, so it becomes a single “select and move” option.

So for example, you could present the whole table as a Collection, then modify the default Item Click action and change it to a custom action with two steps. The first step would use an Add Row action to create a new row in your second table, using the column values from the selected row, and the second step would use a Set Column Values action that changes the boolean to `true`,

You could then filter your collection to only show rows where the boolean is not checked, which would have the effect of making the rows “disappear” as they were selected.

---

<div class="post-metadata">

### Author: ![Rafa\_flama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafa_flama/32/70966_2.png) [@Rafa\_flama](https://community.glideapps.com/u/Rafa_flama)
#### Post date: [February 16, 2024, 6:00pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/5 "2024-02-16T18:00:24Z")

</div>

ok! I understand, I don’t have access to Glide API due to my plan, however I really like your alternative approach.

So, I will convert the checklist in a list with a button on each row so the user will be able to process each episode separately one by one, is that correct?

I think the approach is ok from the UX perspective, its a good balance, thanks!

---

<div class="post-metadata">

### 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: [February 16, 2024, 6:01pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/6 "2024-02-16T18:01:12Z")

</div>

> [@Rafa\_flama](#):
>
> So, I will convert the checklist in a list with a button on each row so the user will be able to process each episode separately one by one, is that correct?

Yes, that should work 👍

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [February 23, 2024, 6:01pm UTC](https://community.glideapps.com/t/duplicate-a-filtered-table/70889/7 "2024-02-23T18:01:56Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
