Automatically update app formulas

[HectorMME]

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!

[TeeSee1]

See this article.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Quick-Update-System-How-to-update-records-in-you...

[HectorMME]

Thanks!  Looks useful for my issue.

I will take a look later today!

Nice day TeeSee!

[SkrOYC]

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)

[HectorMME]

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

thanks!

[Joseph_Seddik]

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.