After run bots, appsheet recalculate
I have a problem with bots in my app.
In picture 1, I create bot with trigger data change is “Add only”, condition is [_THISROW_BEFORE].[ID]<>[_THISROW_AFTER].[ID]
In picture 2, step run a data action , execute action : “1.3 …”
In picture 3, action “1.3” has action “Data: set the values of some columns in this row”. It’s effect to column is “So DT”, “Ten KH” .
In picture 4, column “Tong tien truoc giam gia” has formula = SUM([Related Bill chi tiếts][Thành tiền])
In picture 5, view form, this formula run sussecfully .
In picture 6, data is save in gg sheet. Include result of formula in picture 4.
Then, my bot which I create in picture 1 run.
It update to two column is “So DT”, “Ten KH” .( picture 3)
And it delete the result of formula in picture 6.
I don’t understand, why bot recalcuate my formula? the column is formula will be effected? Another one isn’t.
In Picture 4, your showing that the calculation is performed by an App Formula. App Formulas are re-executed on a row anytime there is an edit to that row. The first time it fires is when you add the row. But then your bot, in Picture 3, edits the row. This triggers another recalculation of the App Formula. If any of the values used in that App Formula have changed, then the value will get a different result.
1 Like
Thank you for your reply. But i think sum() funtion still fine. Expample: Sum(1+1)= 2 . If recalcacution, the resut of funtion sum() equal 2.
Turn back my question. Funtion sum() just sum value in “bill detail” with condition id = id of " bill master". When my bot run, just edit value another column.
fomula = sum() => ok
run bot, recalculattion funtion sum() => diferent resut.
We can control the bot? or I set up some thing wrong? please explain for me. Thank you.
Your SUM() function, based on the image, is using a “Related” virtual column in some way. These columns are simply pointers to a list of rows. It MUST be either, the value within one or more of those rows has changed OR the list of rows has changed between the first SUM occurrence and the second.
There isn’t enough detail for us to determine precisely what has changed.
1 Like
