Automatically update app formulas

AppSheet AppSheet Q&A
, ,
1

Hello!

Does anyone knows how to update a App Formula automatically?

My especific situation is the following:

I have one table referenced to other.

On the main table y have a COUNT(SELECT) formula to count the quantity of rows associated to the main table. But when adding a new row on the refered table the value with the COUNT(SELECT) formula does not uptdate.

Just update when opening the main table form again to “edit”. But I want this to be always synced with the QTY of referenced rows.

Thanks in advance for your comments and help!

2

See this article.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Quick-Update-System-How-to-update-records-in-your-app-with-a/m-p/273640

3 Likes
3

Thanks! Looks useful for my issue.

I will take a look later today!

Nice day TeeSee!

4

The thing is, there are two ways an AppFormula work.

If it’s on a column that exist on your database, it will be updated everytime the record/row is updated on one of it’s fields, that’s the base of a system to update rows.

If it’s a virtual column, it gets updated automatically (kinda)

1 Like
5

Ok! This is even better solution.
I will check with a virtual column instead of a colum on my database.

thanks!

6

Beware that virtual columns will calculate everytime your app is synced for all rows even when there are no newly-added rows; and this would increasingly impact your app’s performance as your dataset grows especially having a SELECT in the expression.

Instead, I believe this is a perfect use case for automation. Configure a bot to run on the addition of a new row in your table with an action of incrementing the corresponding count column.

2 Likes