# Incrementing column not working **URL:** \ **Category:** Report a Bug\ **Created:** [June 23, 2023, 11:33am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086 "2023-06-23T11:33:10Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)\ **Post date:** [June 23, 2023, 11:33am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/1 "2023-06-23T11:33:10Z")
When I set up an action to increment a column through a relation its giving me the option to select. But when I click on it the selected column disappears I click on this: ![SCR-20230623-maoq](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fb9e5c3a169d8c311aa4245c04f696dc26f49f6.png) And this happens ![SCR-20230623-makh](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39c4ec6aaec67893cc8f640d4df72997f1a5f4eb.png) Ive check that the column is editable and not a computed column. Could someone tell me what I am doing wrong? ---
**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:** [June 23, 2023, 11:34am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/2 "2023-06-23T11:34:53Z")
You’re not doing anything wrong, it’s a bug. I reported it a few weeks ago, I’m not sure what the status is. Just confirming though, the relation is a _single_ relation, yes? ---
**Author:** ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)\ **Post date:** [June 23, 2023, 11:42am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/3 "2023-06-23T11:42:28Z")
Yes, I would have loved to make increment a multiple relation. As for this use case I am attempting to build a payment batch. Where a person creates a batch for multiple payments to one supplier. For ex ## Company 1 Payment 1 = $200 |Create Payment in Batch| Payment 2 = $400 |Create Payment in Batch| Payment 3 = $300 |Create Payment in Batch| Payment 4 =$100 |Create Payment in Batch| Batch Payment Company 1 = $1000 |Pay Now| So if they say pay now on the batch it would increment the payments paid column added to the batch. But the problem above is on a single relational column ---
**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:** [June 23, 2023, 11:56am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/4 "2023-06-23T11:56:33Z")
Okay. I just checked back to see when I reported it, and it was 16 days ago. So it’s been broken for at least that long. I’m trying to find out if/when it might be fixed. In the meantime, if you want a workaround you can do the following: - Create a lookup column that fetches the current value via the same single relation - Create a Math column that adds ~~1~~ the amount to be incremented to that value - Use a Set Column Values action through the Single Relation, setting the target column with the value of the math column. ---
**Author:** ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)\ **Post date:** [June 23, 2023, 11:58am UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/5 "2023-06-23T11:58:16Z")
Thanks Darren. Do you know if they will ever implement multiple relation column incrementation? ---
**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:** [June 23, 2023, 12:00pm UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/6 "2023-06-23T12:00:23Z")
Funny you should ask that. A few of us were discussing exactly that just last night. What we’ve been told is that it’s a _really_ difficult thing to do from an engineering perspective. Doesn’t mean it will never get done, but as far as I know it’s not currently planned. ---
**Author:** ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)\ **Post date:** [June 23, 2023, 12:04pm UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/7 "2023-06-23T12:04:37Z")
I can Imagine that its really hard to do. I am working with a lot of people that are moving away from SAP. And that is a really common thing within SAP systems that they want implemented. But thanks for your effort! ---
**Author:** ![MatthewS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthews/32/40533_2.png) [@MatthewS](https://community.glideapps.com/u/MatthewS)\ **Post date:** [June 23, 2023, 8:35pm UTC](https://community.glideapps.com/t/incrementing-column-not-working/63086/8 "2023-06-23T20:35:12Z")
I prefer this method over increment anyway, as most often an increment also needs something else updated like a timestamp at least, so by doing this you save an update.