[BUG] Accumulative Progress Calculation Errors with Multi-Level Relationships

I'm developing an application for project management, which has three main tables: project, task, and report. The project table has a one-to-many relationship with the task table, and the task table has a one-to-many relationship with the report table.

JOHNN_8-1680059638288.png

To update the task line with the current time, I have created an action with the formula "update = now".

JOHNN_0-1680057372555.png

JOHNN_1-1680057405036.png

JOHNN_2-1680057462257.png

 

JOHNN_6-1680059287528.png

Then, I have created an update action for the report table and called it. Although it works fine, there is a problem with the calculation. When I create a report with 20% completion, the task side only shows 20% progress.

JOHNN_3-1680058923680.png

Similarly, when I create another report with 20% completion (20+20=40), the task only shows 20% progress instead of 40%. 

JOHNN_4-1680058965458.png

This means that the app is not saving the result on the line I just created, causing it to malfunction. But when I edit Task by manually (click action edit), it calculator all rows.

JOHNN_7-1680059526662.png

 

I have consulted with some friends, and they have also encountered the same error. I believe the cause of this bug might be related to the recent testing of the automation update feature in Appsheet. But in my case, I don't enable this feature. 

JOHNN_5-1680059210034.png

 

0 1 89
1 REPLY 1

Appsheet Error.gif

This bug

Top Labels in this Space