as this is an AL, you could try to sequence your workflow using a AL Guide.
There are a few different strategies I can think of to tackle this. I'll start with the simplest.
Do you know what the new inbound value will be? What I mean is, the record that is being added to Table B - do you know what value is being pushed to the field that is being summed?
Let's say that the data being pushed to Table B includes a field on Table A called "Integer To Push To B"
Your solution could be as simple as setting your integer field to: COLSUM($col.Integer01$) + $Integer To Push To B$
Let me know if this works, and if not, we could discuss further solutions.
1 of 1 people found this helpful
Carl's comment made me think of a super easy solution. Change the workflow that sets your sum so that it's no longer associated with the button.
Instead, have it associated with your table field and have it execute on Table Refresh. Then just make sure your button code refreshes the table after your push.
Side benefit - Any time users refresh the table with any other method, your sum field will be up to date.
First one is not the solution, because added value is coming from the third table. This would mean that I need to do an additional query and I would like to avoid this.
The second solution is currently the proposed one and it has only one "flaw" - I need to find a way to simulate a click on the refresh button.
Currently, I need to click on the button and then on the Refresh to get the correct value. If I could only somehow skip clicking on Refresh button...
2 of 2 people found this helpful
That's very simple.
You can do it with a Change Fields action, or a Run Process action.
1. Add a change fields action to your link on the button
2. For the Field, select your table field
3. On the bottom of the list of possible options, there will be a box that says "Refresh Tree/Table". Select that option.
1. Add a run process action to your link on the button
2. in the command line, enter PERFORM-ACTION-TABLE-REFRESH and then a space and then the field ID of the table field.
Did the run process, worked perfectly!