Good afternoon GoCanvas team:
I have an app for job estimation that relies on a loop screen to add labor positions as needed. Each position has an associated hourly cost for each. To arrive at the total cost, each line of the loop is multiplied by the "job duration" (expressed in days).
If I run the app using one scenario, for example using 3 days of work, I get a result of "x"
If I run the app using a second scenario, using 5 days of work, I get a result of "y"
However, imagine if I run the app using the first scenario, (3 days), then get to the final screen and realize that I needed to change my duration to the second scenario (5 days). I go back to the job duration and change the "3" to "5". The final result should be "y" - correct? Well, it isn't.
In that third scenario, I actually get a third result, "z". The reason is that the labor loop screen does not update the calculations in the loop once the "job duration" variable is changed.
I have examples and submissions to prove it all at a more detailed level.
After discovering upon job closeout that our bids fell short of our costs on a few jobs, we now recognize the bug after losing a few thousand dollars. My team now just starts over every time they have to change job duration. It shouldn't work that way. Math calculations should perform dynamically, regardless of whether they are in loop screens or not.
I've submitted this previously as a help ticket and was told "this is how it was designed to work". OK, that's fine. Time to please reconsider, because that makes no sense on any level to me. If excel did math this way, we'd all be in a lot of trouble.
Please help. Thank you!
Comments
Please sign in to leave a comment.
Howdy Christopher,
Thank you for sharing this detailed use case example! I provided your feedback directly to our Product Managers, emphasizing the complications that are currently encountered with Calculations within loop screens.
Our Product Team is in the planning stages for major updates to the App Builder. We do not have an estimated timeline for changes to Calculation fields within loop screens, but they understand the challenges that the current system can cause and we are committed to improving Calculation fields as a whole.
Agreed. It is frustrating when calculations and lookups / references don't happen correctly when each and every screen involved is not visited.
This feature request was an attempt to sort of ask for the same thing if you wanted to upvote it.
https://help.gocanvas.com/hc/en-us/community/posts/360025221834-Enable-values-to-post-correctly-even-if-some-pages-are-skipped-via-Table-Of-Contents-and-even-if-fields-are-hidden