# How to increment a number counter field?

**URL:** <https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054>\
**Category:** Ask for Help\
**Created:** [October 10, 2019, 12:07am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054 "2019-10-10T00:07:58Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![ainunnajib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ainunnajib/32/866_2.png) [@ainunnajib](https://community.glideapps.com/u/ainunnajib)\
**Post date:** [October 10, 2019, 12:07am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/1 "2019-10-10T00:07:59Z")

</div>

I want to make a button (or anything) where upon tap/click, the number column will be incremented by 1.

How do I do this? Link action which trigger a formula?

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [October 10, 2019, 12:11am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/2 "2019-10-10T00:11:51Z")

</div>

Hi there, we don’t have a native way of doing this in Glide at the moment. However we are going to create a number stepper soon which would allow you to do this very easily.

---

<div class="post-metadata">

**Author:** ![ainunnajib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ainunnajib/32/866_2.png) [@ainunnajib](https://community.glideapps.com/u/ainunnajib)\
**Post date:** [October 10, 2019, 12:18am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/3 "2019-10-10T00:18:32Z")

</div>

Thanks Jack! The lazy me will wait. When’s the planned release in the roadmap?

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [October 10, 2019, 1:00am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/4 "2019-10-10T01:00:01Z")

</div>

Haha, sure. Hard to say, unfortunately. But we’re keen on it so not far off.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 10, 2019, 5:33am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/5 "2019-10-10T05:33:20Z")

</div>

What’s the use case for this scenario?

---

<div class="post-metadata">

**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\
**Post date:** [October 17, 2019, 3:34pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/6 "2019-10-17T15:34:23Z")

</div>



---

<div class="post-metadata">

**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\
**Post date:** [October 17, 2019, 3:35pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/7 "2019-10-17T15:35:21Z")

</div>

Check-ins, Likes, Etc.

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [October 18, 2019, 2:02pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/8 "2019-10-18T14:02:17Z")

</div>

That’s how I feel about most items on our wishlist! 😉

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [February 22, 2020, 10:12pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/9 "2020-02-22T22:12:38Z")

</div>

I have a working spreadsheet + app scripts version here

> **[Clicker](https://docs.google.com/spreadsheets/d/1TNKE5ByDGldR76UbqVu3FXJ41fsQlau-4ypBFI61iIk/edit#gid=0)**
>
> Sheet1
> 
> 1

  
But I haven’t tried to hammer it into an app yet…

---

<div class="post-metadata">

**Author:** ![Robert\_Stevenson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_stevenson/32/4616_2.png) [@Robert\_Stevenson](https://community.glideapps.com/u/Robert_Stevenson)\
**Post date:** [April 9, 2020, 7:17pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/10 "2020-04-09T19:17:33Z")

</div>

Hi, Has a number stepper been added to Glide yet?

---

<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:** [April 11, 2020, 5:23pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/11 "2020-04-11T17:23:55Z")

</div>

No, not a native built in one. You’re best option right now would be to create a button with a Zapier action. Let zapier write a new row to the sheet, then use a rollup column to count the number of rows. Not a great solution and it would have lag.

---

<div class="post-metadata">

**Author:** ![chethan\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chethan_m/32/2155_2.png) [@chethan\_M](https://community.glideapps.com/u/chethan_M)\
**Post date:** [April 17, 2020, 7:55am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/12 "2020-04-17T07:55:50Z")

</div>

I am also in need of the number stepper for my app…please let me know when it is available

---

<div class="post-metadata">

**Author:** ![Bamr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bamr/32/6419_2.png) [@Bamr](https://community.glideapps.com/u/Bamr)\
**Post date:** [April 29, 2020, 1:22am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/13 "2020-04-29T01:22:37Z")

</div>

Hey @JackVaughan,

Is this feature released yet? This would be very helpful way to decrement an “inventory” qty down, but I’m sure there are many other applications. The Zapier “work-around” seems clunky and cumbersome.

---

<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:** [April 29, 2020, 3:25am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/14 "2020-04-29T03:25:53Z")

</div>

@Bamr I don’t know if you would want a button just to decrement an inventory item. You could simply create a relation column to link to your purchased items, a rollup column to count the number of purchased items, and a math column to subtract that rollup value from a starting inventory.

---

<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:** [April 29, 2020, 3:35am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/15 "2020-04-29T03:35:17Z")

</div>

> [@Reducing a sheet cell’s value when a form is submitted](https://community.glideapps.com/t/reducing-a-sheet-cell-s-value-when-a-form-is-submitted/8057/2):
>
> Yep! I have a version of this in my Inventory app ([itemstore.glideapp.io](http://itemstore.glideapp.io)). Set a quantity for an item, then every time a user buys an item, the quantity decreases: Basically, set an initial quantity in the shop tab. Do a multiple relation to the SKU between shop tab and purchases tab. Rollup the count of purchases within the relation. Subtract the count from the quantity using a math column. Display the result. Hide the buy button once the inventory reaches zero.

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [April 29, 2020, 7:51am UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/16 "2020-04-29T07:51:29Z")

</div>

@Bamr, not yet. But Rob & Jeff both provide some options.

---

<div class="post-metadata">

**Author:** ![Bamr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bamr/32/6419_2.png) [@Bamr](https://community.glideapps.com/u/Bamr)\
**Post date:** [April 29, 2020, 2:46pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/17 "2020-04-29T14:46:06Z")

</div>

Thanks for the feedback. Rob’s work around is clever and would work but would be overkill for such a simple calculation.

I actually found another App service calls AppSheet that has exactly what I was looking for, and a bunch more.

 ![Inventory Decrement](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/93cb203484afbc77ae4a1650809aaa59aa6009f0.png)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 5, 2020, 8:02pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/18 "2020-06-05T20:02:05Z")

</div>

I think we have the winner now!!!  
The new action called **Increment** within Action Text´s features makes this posible!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0ee9467abc96e7aa413985d8b592914342c842ad.png)

I´m watching you Glide!! 🧐

Saludos

---

<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:** [June 5, 2020, 8:23pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/19 "2020-06-05T20:23:11Z")

</div>

Yep…you can use this as a (mathmatical) reset button as well!

> [@Increment Action?!](https://community.glideapps.com/t/increment-action/10359/11):
>
> Check this out: scream Reset button!

---

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [November 10, 2020, 2:42pm UTC](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054/20 "2020-11-10T14:42:05Z")

</div>

I could use this for a score card I have for my classroom. Each time they mine an asteroid they earn 500XP.

[Next page](https://community.glideapps.com/t/how-to-increment-a-number-counter-field/1054.md?page=2)
