Incrementing column not working

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:

And this happens

Ive check that the column is editable and not a computed column.

Could someone tell me what I am doing wrong?

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?

1 Like

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

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.
2 Likes

Thanks Darren. Do you know if they will ever implement multiple relation column incrementation?

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.

2 Likes

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!

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.