# Incrementing multiple columns based on Choices

**URL:** <https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235>\
**Category:** Ask for Help\
**Created:** [February 21, 2023, 11:50am UTC](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235 "2023-02-21T11:50:54Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [February 23, 2023, 1:20am UTC](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235/21 "2023-02-23T01:20:26Z")

</div>

Sure! It sounds like it can do what I am looking for without consuming a ton of resources.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [February 23, 2023, 11:46pm UTC](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235/22 "2023-02-23T23:46:44Z")

</div>

I think I might have figured it out by using the above Javascript. Converted the submission date to a Month # and used that # in the If statement to update a correlated month column that counts the entries for that month

---

<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 24, 2023, 12:24am UTC](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235/23 "2023-02-24T00:24:20Z")

</div>

Sorry, I had a crazy day yesterday and so I didn’t have an opportunity to get that done for you.

If I understand correctly what you’ve done, then that’s going to be quite tedious to maintain and isn’t very scalable, right? Essentially you’re going to have to add a column for every month and keep coming back to re-configure your if-then-else column. It’s also going to be a pain if you ever want to process/analyze the month on month numbers in any way.

When I have some free time, I’ll show you how the JSON alternative could work. That won’t be today though.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [February 24, 2023, 12:31am UTC](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235/24 "2023-02-24T00:31:58Z")

</div>

Thanks! Take your time! I was just experimenting but it wasnt really working for me anyways lol.

This rollup is primarily used to determine if a certain user has exceeded their plan limit, so I think its more just looking at the number received in the current month vs prior months.

Ex:

- Plan limit is 500 surveys per month
- Currently, each survey received records the current date in a Date USC.
- Each survey increments # total month by 1
- Once 500 is reached, visibility for survey is turned off.

[Previous page](https://community.glideapps.com/t/incrementing-multiple-columns-based-on-choices/58235.md?page=1)