# Single action = one update?

**URL:** <https://community.glideapps.com/t/single-action-one-update/57653>\
**Category:** Ask for Help\
**Created:** [February 8, 2023, 9:45am UTC](https://community.glideapps.com/t/single-action-one-update/57653 "2023-02-08T09:45:00Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\
**Post date:** [February 8, 2023, 9:45am UTC](https://community.glideapps.com/t/single-action-one-update/57653/1 "2023-02-08T09:45:00Z")

</div>

Hi

I have a button that increments a cell by 1 when tapped. The cell is connected to another table via relation/lookup and from this that number is added to existing points via a maths column. So about 25 rows are incremented with the single tap.

My question is whether tapping the button is one update, or is the number of updates equal to the number of rows being adjusted?

---

<div class="post-metadata">

**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\
**Post date:** [February 8, 2023, 9:52am UTC](https://community.glideapps.com/t/single-action-one-update/57653/3 "2023-02-08T09:52:15Z")

</div>

If the bot’s right I’m in a bit of a pickle. The rows being adjusted are coming from a computed column - the maths column. Do computed columns count as updates if no other columns are affected?

---

<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 8, 2023, 10:13am UTC](https://community.glideapps.com/t/single-action-one-update/57653/4 "2023-02-08T10:13:00Z")

</div>

I’m 99.9% certain that’s just a single update. And if it isn’t, I’d say that’s a bug.

Imagine a table with 10,000 rows, with a single value column that’s then used in a template column.  
Every time that single value changes, the value in the template will change in all 10,000 rows. And I can guarantee you that isn’t 10,000 updates, otherwise I’d be clocking up millions of updates every month.

---

<div class="post-metadata">

**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\
**Post date:** [February 8, 2023, 10:31am UTC](https://community.glideapps.com/t/single-action-one-update/57653/5 "2023-02-08T10:31:53Z")

</div>

Good point, thank you. I was fairly sure that was the case but schools using the app are racking up huge amounts of updates to the point where they will go over their 25000 allocation well before the end of the month. So I’m looking at ways to reconfigure the app to reduce the updates, and that button was one I was looking at.

---

<div class="post-metadata">

**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\
**Post date:** [February 8, 2023, 12:11pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/6 "2023-02-08T12:11:23Z")

</div>

every increment - is a one update.  
so, if you use in action several increments - it will be several updates.

---

<div class="post-metadata">

**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\
**Post date:** [February 8, 2023, 12:30pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/7 "2023-02-08T12:30:09Z")

</div>

There is only 1 increment in the action. It is spread to other rows via a lookup column then acted on in a maths column. As Darren said, computed arrays like this would burn through plans very quickly if they counted as updates

---

<div class="post-metadata">

**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\
**Post date:** [February 8, 2023, 3:26pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/8 "2023-02-08T15:26:28Z")

</div>

computed - don’t use updates.  
i mean, if you make a custom action, that use several increments action - it will be several updates. so, better make SET COLUMN and write several increments at once - in this way it will be just one update

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [February 8, 2023, 5:38pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/9 "2023-02-08T17:38:21Z")

</div>

Computed columns don’t actually edit any data, so they don’t make updates.

---

<div class="post-metadata">

**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:** [February 8, 2023, 7:10pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/10 "2023-02-08T19:10:11Z")

</div>

What I’m interested in is one set column action that sets, let’s say, 10 cells at once. Is that 1 update or 10?

---

<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:** [February 8, 2023, 7:40pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/11 "2023-02-08T19:40:03Z")

</div>

One action should be one update. Even if you set multiple columns in one set column action, then I believe they should be batched together as one update.

---

<div class="post-metadata">

**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:** [February 8, 2023, 8:31pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/12 "2023-02-08T20:31:47Z")

</div>

> [@Jeff\_Hager](#):
>
> they should be

Hopefully! Thanks for the response!

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [February 8, 2023, 9:03pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/13 "2023-02-08T21:03:28Z")

</div>

> [@user19](#):
>
> if you use in action several increments - it will be several updates

No, now it’s like this: one action consisting of several increments - one update  
Look [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/e13c6c965a52464d8b25e405da0e0b58)

---

<div class="post-metadata">

**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\
**Post date:** [February 9, 2023, 8:49am UTC](https://community.glideapps.com/t/single-action-one-update/57653/14 "2023-02-09T08:49:56Z")

</div>

i hope so.  
before it was not. didn’t see any announcement about changes.

if check usage after several minutes - it didn’t go up?

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [February 9, 2023, 9:53am UTC](https://community.glideapps.com/t/single-action-one-update/57653/15 "2023-02-09T09:53:07Z")

</div>

> [@user19](#):
>
> if check usage after several minutes - it didn’t go up?

Exactly. But if you use two increment in one action and increment to same row but different column it count one update.  
If you use increment to different rows(actually i checked different table) in one action so it counted two updates. But everybody promises that must be one.  
Or i misunderstand something?

---

<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 9, 2023, 9:57am UTC](https://community.glideapps.com/t/single-action-one-update/57653/16 "2023-02-09T09:57:48Z")

</div>

> [@slscustom.ru](#):
>
> If you use increment to different rows(actually i checked different table) in one action so it counted two updates. But everybody promises that must be one.

It’s not possible to update two values in two different tables with one action.  
You can do it as two separate steps in the same _custom_ action, but technically that’s two separate actions.

That’s why it would be counted as two updates.

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [February 9, 2023, 10:12am UTC](https://community.glideapps.com/t/single-action-one-update/57653/17 "2023-02-09T10:12:44Z")

</div>

Thanks, Darren for explanation!  
So to be clear: updates counted depend how many basic cells are changed during one action, because in a previous video i do increment in a two different action(in one custom action) but same row and column and two action counted once.  
But delete row by multi relation? How many updates must be theoretically? I can’t figure from previous.  
Actually deletion by multi relation counted multi times. But why? It is one action actually.  
If i will do database maintenance i will empty all quotas and stop production.

---

<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 9, 2023, 10:47am UTC](https://community.glideapps.com/t/single-action-one-update/57653/18 "2023-02-09T10:47:00Z")

</div>

> [@slscustom.ru](#):
>
> because in a previous video i do increment in a two different action(in one custom action) but same row and column and two action counted once.

Yes, that’s what I would expect, because it’s two separate actions (within a custom action).

> [@slscustom.ru](#):
>
> Actually deletion by multi relation counted multi times. But why? It is one action actually.

I’m not sure, but I would say this counts as multiple updates because it’s operating on multiple rows.  
The same thing happens if you delete rows via the API. You can send a bundle of 100 mutations to delete 100 rows in a single API call. But each mutation still counts as a separate update.

---

<div class="post-metadata">

**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\
**Post date:** [February 9, 2023, 11:39pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/19 "2023-02-09T23:39:45Z")

</div>

well, i see a rule: one row = one update.

in my project i remove all increments in custom action. some times it was hard, in case some counts need move to same table from different.

---

<div class="post-metadata">

**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\
**Post date:** [February 9, 2023, 11:41pm UTC](https://community.glideapps.com/t/single-action-one-update/57653/20 "2023-02-09T23:41:17Z")

</div>

this why i prefer a google table.  
there i can delete any quantity of rows by script = 1 sync

---

<div class="post-metadata">

**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:** [February 10, 2023, 12:01am UTC](https://community.glideapps.com/t/single-action-one-update/57653/21 "2023-02-10T00:01:02Z")

</div>

This works when the UX doesn’t suffer. If you NEED users to experience the deleted content instantly, then Google Scripts are just too slow.

However, for nightly cleanup tasks, etc, I agree = preferred.

[Next page](https://community.glideapps.com/t/single-action-one-update/57653.md?page=2)
