Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Bot updates a row, but App Formulas on the same row are not recalculating, how can I force it?

C2
Bronze 3
Bronze 3

Hi everyone,

I'm running into a problem where my App Formulas are not recalculating even after a Bot updates the row.

Here’s the situation:

  • I have a Bot that runs when a certain condition is met in Table A.

  • The Bot performs a “Run action on rows” to update a value in Table B (e.g. [Work Status] = "pending").

  • The row is definitely being updated — the change is visible both in the UI and the backend (Google Sheet / SQL).

  • However, an App Formula in another column of that same row does not recalculate automatically.

For example, I have an App Formula like this:

SELECT(
Contract[Surname],
AND(
IN([COD. EVENT], SPLIT([Event N.], ",")),
[Status lettel] <> "CXL"
)
)

This formula used to recalculate when the row was edited by the Bot, but now it doesn’t anymore. 

If I manually click edit/save on the row the formula works correctly.

I’d like to ask:

  • Is there a way to force App Formulas to recalculate after a Bot edits a value of the row?

  • Could this be related to sync settings, server caching, or app performance options

  • I tried to add an [UpdateTrigger] column and set a groped action, but didn't solve the problem

Thanks in advance for any advice!

 

Solved Solved
0 20 313
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

@C2 wrote:

This feels like an internal evaluation inconsistency and might be worth reporting as a bug or limitation.


There are several such inconsistencies, unfortunately.

Reporting this as a bug is pointless: Google doesn't seem to care about components they aren't actively working on. They finished bots several years ago. Bots and Automation was largely developed by developers new to AppSheet and conflicted with existing behavior in several ways.

View solution in original post

20 REPLIES 20
Top Labels in this Space