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.