# Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations

**URL:** <https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584>\
**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:** 16\
**Page:** 3

<div class="post-metadata">

**Author:** ![vras\_dinand](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vras_dinand/32/64071_2.png) [@vras\_dinand](https://community.glideapps.com/u/vras_dinand)\
**Post date:** [July 11, 2024, 12:47pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/41 "2024-07-11T12:47:47Z")

</div>

coz user can edit this manually in application,this app for recomendation for user only.but user aproved or not

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 11, 2024, 12:53pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/42 "2024-07-11T12:53:44Z")

</div>

Okay, fair enough.

So if you want to set them via the API, you can follow my video and just make a minor change.  
Once you have the mutation for each row, add an if-then-else column:

- If “Permintaan \>0” is not empty, then Mutation column

And then use that column in the joined list. The rest of it will be exactly the same.

---

<div class="post-metadata">

**Author:** ![vras\_dinand](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vras_dinand/32/64071_2.png) [@vras\_dinand](https://community.glideapps.com/u/vras_dinand)\
**Post date:** [July 11, 2024, 1:00pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/43 "2024-07-11T13:00:28Z")

</div>

okay.can you explain this,coz i dont understand this column

 ![11-07-2024 19-58-09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b846de212bcea5df2888e04dca01c817dcac646e.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 11, 2024, 1:05pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/44 "2024-07-11T13:05:38Z")

</div>

Right click on the table name in the Data Editor, and select Show API.  
Choose the curl examples, and then Edit Rows.  
You can copy the code from there, and remove the bits you don’t need.

See below to learn more:

> **[Getting Started with the Glide API | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api)**
>
> A guide to working with the Glide Tables API for non-developers.

---

<div class="post-metadata">

**Author:** ![vras\_dinand](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vras_dinand/32/64071_2.png) [@vras\_dinand](https://community.glideapps.com/u/vras_dinand)\
**Post date:** [July 11, 2024, 1:28pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/45 "2024-07-11T13:28:20Z")

</div>

can you captured setting for collumn json data thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 11, 2024, 1:38pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/46 "2024-07-11T13:38:21Z")

</div>

You can get it yourself by following the instructions I gave above, and it will give the exact values that you need for your table.

---

<div class="post-metadata">

**Author:** ![vras\_dinand](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vras_dinand/32/64071_2.png) [@vras\_dinand](https://community.glideapps.com/u/vras_dinand)\
**Post date:** [July 12, 2024, 3:28am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/47 "2024-07-12T03:28:32Z")

</div>

Thank you @Darren_Murphy For Sharing This,Its Work For ME

---

<div class="post-metadata">

**Author:** ![szabymsys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/szabymsys/32/80038_2.png) [@szabymsys](https://community.glideapps.com/u/szabymsys)\
**Post date:** [February 10, 2025, 7:35am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/48 "2025-02-10T07:35:42Z")

</div>

For some reason, the “delete row” does work on Relation with match multiple or a query. But if that works, why set column values wouldn t work just as fine. It s 2025 already and still doesn t work

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 10, 2025, 7:37am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/49 "2025-02-10T07:37:28Z")

</div>

Delete Row works with a query/multiple relation with regular Glide Tables.  
It does not work with Big Tables.

---

<div class="post-metadata">

**Author:** ![szabymsys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/szabymsys/32/80038_2.png) [@szabymsys](https://community.glideapps.com/u/szabymsys)\
**Post date:** [February 25, 2025, 8:07am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/50 "2025-02-25T08:07:59Z")

</div>

Yes, but if that works perfectly, why “Set collumn values” or “Increment number” or any other wouldn’t work just as fine?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 25, 2025, 8:09am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/51 "2025-02-25T08:09:09Z")

</div>

Because they are not supported. That’s why we created this feature request.

---

<div class="post-metadata">

**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\
**Post date:** [March 7, 2025, 3:09pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/52 "2025-03-07T15:09:54Z")

</div>

Let’s get this going!

---

<div class="post-metadata">

**Author:** ![szabymsys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/szabymsys/32/80038_2.png) [@szabymsys](https://community.glideapps.com/u/szabymsys)\
**Post date:** [July 21, 2025, 11:36am UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/53 "2025-07-21T11:36:33Z")

</div>

WE REALLLY REALLY NEED THIS. For example, in my company app, I have materials connected via internal code. If someone modifies this code for example, is need to update it everywhere where it is stacked, like in every storage, every car, project where it was used etc. and even if it would take a few moments for it do change it everywhere, I wouldn’t mind. Because I won t have to go everywhere and modify it myself. and it can happen everywhere. I modify the name of the project in the main page? it needs to change it in the “reserved materials”, the transactions history and lots of other things. So yes, we need this asap. It would be sooooo helpful, better then just a game-changer. @Mark

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 21, 2025, 12:34pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/54 "2025-07-21T12:34:34Z")

</div>

> [@szabymsys](#):
>
> If someone modifies this code for example, is need to update it everywhere

This sounds like more of a database design issue. You should be writing the corresponding RowID everywhere and then using a relation/lookup to retrieve the internal code.

> [@szabymsys](#):
>
> modify the name of the project in the main page? it needs to change it in the “reserved materials”, the transactions history and lots of other things

Same here. Write the Row ID for the project to the other tables, and then use a relation/lookup to retrieve the name. Names change, but Row IDs never do.

Change the value once and it’s automatically propagated everywhere else without the need to update multiple rows of data. That’s how I do it in my app. I have students and I always write the student RowID to all other tables instead of name. If the student name is changed, I don’t have to update the name in the other tables as the RowID doesn’t change, but the corresponding relation/lookup automatically pulls in the updated name. No need for any actions to update anything in the other tables. It just happens due to the relation/lookup.

---

<div class="post-metadata">

**Author:** ![szabymsys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/szabymsys/32/80038_2.png) [@szabymsys](https://community.glideapps.com/u/szabymsys)\
**Post date:** [July 21, 2025, 1:12pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/55 "2025-07-21T13:12:11Z")

</div>

I will think about redoing things with this, because I need to change it in lots of places. but still, we do need this thing implement

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 21, 2025, 1:57pm UTC](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584/56 "2025-07-21T13:57:11Z")

</div>

I agree, this feature request would be a good thing for certain use cases, but for your specific use case I would still use the RowID/Relation/Lookup method as it’s much less prone to error. If a Set Column action were to fail on one or several rows in one or multiple tables, then you start to risk a severe disconnect between data. Whereas a RowID/Relation/Lookup will work 100% of the time.

To be clear, I am all for this feature request, but I would selectively use it depending on the use case.

[Previous page](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584.md?page=2)
