# Add multiple rows to another table **URL:** \ **Category:** Ask for Help\ **Created:** [May 13, 2024, 8:50am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309 "2024-05-13T08:50:39Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 13, 2024, 8:50am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/1 "2024-05-13T08:50:39Z")
Hi, I am creating a list of collections with 3 statuses, “open”, “pending” and “closed” in a table. I want to select multiple items from my “open collection”, send them, and move those “open collections” to the next status “pending collection” (all show on the same page) In the backend, there is another table “pending table” for these “pending collections”. My problem is: I have created a button and made the action “add row”, I use “checklist” for all these collections. Then I selected a few items and sent them. The backend “pending table” could only capture the first collection and created a few rows with the first collection. Can I ask what I need to do to make it right, please? ---
**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 13, 2024, 9:11am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/2 "2024-05-13T09:11:30Z")
My question would be why do you want two separate tables? Seems to me all that would be doing is creating extra work and complexity - as you’re already discovering. Separate tables that hold almost identical data is almost always a very bad idea. It’s trivial to filter rows on the front end. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 13, 2024, 9:29am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/3 "2024-05-13T09:29:05Z")
The idea is that I want the staff to submit new projects for the management to approve. The pending approval tab will only show to the management. If it’s a “todo” list, I think I should make it one page, but this is about another group of people to approve the project submissions, so I have created a separate table. What would you suggest? In this case, should I make it a separate tables? ---
**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 13, 2024, 9:32am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/4 "2024-05-13T09:32:59Z")
No, I would just use one table. You can have different views of the same table on the front end, and filter by status. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 13, 2024, 10:16am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/5 "2024-05-13T10:16:19Z")
Let me try. But how do I select a few items and send them to the management for approve? If I create a button and the action is “add row”, it will only add the first row of that user’s created. I would like to know what step I have done wrong, please? ---
**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 13, 2024, 10:29am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/6 "2024-05-13T10:29:11Z")
If you want to send items for approval, isn’t that just a matter of changing the status of those items? There should be no need to create additional rows. Just one thing… > [@Stephen\_Hui](#): > > how do I select a few items and send them Currently, the only way to update multiple items at once is via the Glide API. However, you can update them one by one as they are “selected”. As long as you have the items in a collection, you can configure the collection item click action so that it does that. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 13, 2024, 10:34am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/7 "2024-05-13T10:34:43Z")
I just watched Loqode’s video about using Glide API to do multiple edits/deletes, but it’s a bit difficult for me. Let me give it a try first, and thanks for your answer, Darren 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 13, 2024, 2:31pm UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/8 "2024-05-13T14:31:03Z")
You can also use a Kanban component, that might suit your use case for moving items across different states. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 13, 2024, 6:33pm UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/9 "2024-05-13T18:33:18Z")
> [@Stephen\_Hui](#): > > The idea is that I want the staff to submit new projects for the management to approve. The pending approval tab will only show to the management. You are making life very difficult for yourself by sending data across tables. And there’s no good reason to do that. As Darren suggested, leave all the projects in the same table. You have projects, they all belong in the same table, end of story. Now if projects can have a status that changes (open, pending, closed), then create a column for this attribute (open, pending, closed). That’s how you could/should set things up in the backend (Data Editor). Now in the frontend (Layout Editor), create tabs looking at the same table (Projects) and filter as needed (status, staff-management, etc.). In business terms you are “submitting” projects for approval, but in technical terms nothing is being sent anywhere: button clicks change the value of an attribute (the status for instance) and the filters take care of the rest (display information in certain places). ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 14, 2024, 5:52am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/10 "2024-05-14T05:52:33Z")
I thought that by using the filter function, the content would also download to the end user’s computer, which would slow down the loading speed, so I thought that it would be better to separate the table for the “pending projects”. I will try it this way later, thanks for the guidance guys 🙂 ---
**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 14, 2024, 6:17am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/11 "2024-05-14T06:17:55Z")
Yes, filtering is done on the front end at the users device, so it doesn’t affect how many rows are loaded onto individual devices. If you want to restrict which or how many rows are loaded, you can use Row Owners. But that could introduce additional complexities that you may not be ready to deal with. The main reason to use Row Owners is if security of the data is a concern. And that doesn’t appear to be an issue in this case. How many rows in total are we talking about? Unless it’s tens of thousands, I wouldn’t worry about it. And if it is tens of thousands (or more), then you should be considering one of the high scale data sources. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [May 14, 2024, 7:46am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/12 "2024-05-14T07:46:12Z")
Just hundreds of rows, not much data in it. Ok. I will give it a try, thanks, Darren. ---
**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:** [May 21, 2024, 7:46am UTC](https://community.glideapps.com/t/add-multiple-rows-to-another-table/73309/13 "2024-05-21T07:46:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.