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!
Thanks! Looks useful for my issue.
I will take a look later today!
Nice day TeeSee!
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)
Ok! This is even better solution.
I will check with a virtual column instead of a colum on my database.
thanks!
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.
User | Count |
---|---|
27 | |
26 | |
22 | |
21 | |
21 |