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?
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.
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|
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.
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.
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.