# Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations **URL:** \ **Category:** Feature Requests\ **Created:** [December 9, 2020, 1:18am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584 "2020-12-09T01:18:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 9, 2020, 1:18am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/1 "2020-12-09T01:18:05Z")
Currently, the Action to “Set columns” only consider the current sheet or any single relations (to update a column in a single row). I’m trying to create a “bulk approval” process where the “set column” action could look at a multiple relation and update each corresponding row in that relation. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 9, 2020, 3:45am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/2 "2020-12-09T03:45:09Z")
Lol, yeah, this doesn’t really have any solution. If you have gone through the rows using the app you can always use a combination of clear columns, go back, clear columns, go back, etc. and that will actually clear the path of columns filled out regardless of what rows you went through, as long as you went through rows to get to your destination that you need them to be cleared. With this solution you can get yourself back to the home page as well 🙂 ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 9, 2020, 12:23pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/3 "2020-12-09T12:23:00Z")
Yeah but that doesn’t really work when you can’t predict the number of rows that will need to be updated. My thinking — currently can do single relation —\> Action —\> set column of related row. My hope ---- multiple relation ----\> Action ----\> set column of all related rows. This could open up all kinds of possibilities and allow for bulk edits/updates. That being said, I don’t know if it’s not currently there because it’s just not technically possible to write to multiple rows at once. @Mark — can you either crush my dreams or let me know if it’s a possibility? If you crush my dreams, I’ll just come up with a work-around. If it’s possibility, I won’t rack my brain trying to come up with the work-around! 🙂 ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 9, 2020, 4:11pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/4 "2020-12-09T16:11:42Z")
I think it is a feature that is coming, if it wasn’t then why would they have the field in set column with a drop down that says current row? You wouldn’t put that there if you didn’t plan on expanding on it. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 9, 2020, 6:28pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/5 "2020-12-09T18:28:13Z")
Figured out a work-around. It doesn’t actually change the values of the column, but it looks at the last submission and applies its value to the ones before it. > [@Time Sheet -- Template for submitting hours of work for approval](https://community.glideapps.com/t/time-sheet-template-for-submitting-hours-of-work-for-approval/9147/8): > > NEW VERSION in the works that uses Actions for some really cool features! Highlights: Users cannot submit duplicated hours Users can submit times between other times that have already been submitted Users can submit up to 5 time slots per day Managers can BULK approve outstanding time sheets with one click Once I’ve cleaned up all the extra columns and formulas I had to create to figure this all out, I’ll get this submitted to the template store. This took a lot of work and some whacky logi… ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [December 9, 2020, 7:24pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/6 "2020-12-09T19:24:16Z")
@kyleheney That will be possible at some point in the future, but I can’t give you a timeline. ---
**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:** [April 8, 2021, 2:15pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/7 "2021-04-08T14:15:26Z")
Resurrecting this post. This feature would be a game changer in Glide, not only for functionality but also security (if the feature works within a Delete Row action as well). Would be forever grateful if this were prioritized. @david 🙏 ---
**Author:** ![Luizz\_Soares](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luizz_soares/32/24023_2.png) [@Luizz\_Soares](https://community.glideapps.com/u/Luizz_Soares)\ **Post date:** [June 9, 2021, 12:22am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/8 "2021-06-09T00:22:54Z")
Estou projetando essa solução de limpar coluna. Ainda em teste. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4aef8ae972b5216449d8b1ebd908ebafea331643.jpeg "LIMPAR COLUNA. SÓ A COLUNA?") ](https://www.youtube.com/watch?v=xwKIeCpcKXA) ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [June 15, 2021, 2:05pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/9 "2021-06-15T14:05:31Z")
This isnt the same thing, yuo are having to go into the field via additional windows ---
**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:** [June 16, 2021, 5:24am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/10 "2021-06-16T05:24:02Z")
I guess he’s using scripts when “Atenção” first row is empty, clears the other column which is getting the numbers/amount ---
**Author:** ![victorpr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/victorpr/32/21043_2.png) [@victorpr](https://community.glideapps.com/u/victorpr)\ **Post date:** [October 29, 2021, 3:35am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/11 "2021-10-29T03:35:48Z")
🙏🙏 ---
**Author:** ![Michael\_hien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_hien/32/18864_2.png) [@Michael\_hien](https://community.glideapps.com/u/Michael_hien)\ **Post date:** [December 29, 2021, 10:39am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/12 "2021-12-29T10:39:15Z")
This feature would be extremely helpful, a game-changer. Actually I have not seen any other platform to have done this. ---
**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, 2022, 3:13pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/13 "2022-09-23T15:13:12Z")
Bumping. Please vote! ---
**Author:** ![aonufrak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aonufrak/32/41201_2.png) [@aonufrak](https://community.glideapps.com/u/aonufrak)\ **Post date:** [October 12, 2022, 11:24am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/14 "2022-10-12T11:24:48Z")
+1 It is critical that we have this function for batch updates and forms. ---
**Author:** ![grumo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumo/32/34786_2.png) [@grumo](https://community.glideapps.com/u/grumo)\ **Post date:** [October 20, 2022, 9:07pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/15 "2022-10-20T21:07:57Z")
+100 Will be this ever be implemented? I wonder is there is an underlying limitation in how Glide is built that would make this hard/impossible to implement. ---
**Author:** ![Daniil\_Buriev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniil_buriev/32/36933_2.png) [@Daniil\_Buriev](https://community.glideapps.com/u/Daniil_Buriev)\ **Post date:** [June 22, 2023, 12:17am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/16 "2023-06-22T00:17:30Z")
+1 to Set Column Values in Multiple relation rows. ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 22, 2023, 8:11am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/17 "2023-06-22T08:11:39Z")
Any updates on this? ---
**Author:** ![Flowcode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/flowcode/32/64316_2.png) [@Flowcode](https://community.glideapps.com/u/Flowcode)\ **Post date:** [October 12, 2023, 5:32pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/18 "2023-10-12T17:32:41Z")
This is now possible! 1 - Create a query column and query all related columns. 2 - Create a joined list of all row-id’s 3 - Create a Curl Api Body that does what you want it to do with Glide AI (see below, there’s still a little bit of syntax missing in this example but you can add this easiliy in 1 step with AI) 4 - You might want to replace some things with a Template Column 5 - Use this body in an API Call action. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/285505b66cb08c8904220a66387ea9b17a8c8528.png) ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/285505b66cb08c8904220a66387ea9b17a8c8528.png) [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/294b47aac93ad83ff752efdcf812196472b161ed.png) ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/294b47aac93ad83ff752efdcf812196472b161ed.png) ---
**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 12, 2023, 11:57pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/19 "2023-10-12T23:57:27Z")
Worth noting that this method only needs to be employed when working with Glide Big Tables. With regular Glide Tables you can take a more traditional route: Create JSON Object → Joined List → Template → Call API. ---
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [October 13, 2023, 4:32am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/20 "2023-10-13T04:32:56Z")
@Darren_Murphy do you know of any forum topics covering this? [Next page](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584.md?page=2)