recalculate the entire database

Hello everyone! Does anyone know if it's possible and, if so, how to recalculate the entire database? I would need to create a behavior action that allows me to update all the rows of a database table but from the menu and not from the table itself for example.

0 3 111
3 REPLIES 3


@Gustavo_Eduardo wrote:

I would need to create a behavior action that allows me to update all the rows of a database table


Since updating a row triggers recalculation of all columns in the row that have an app formula, you can create an action that updates the row. For example, make a column that is solely for this purpose. Your action might simply toggle the column's value between true and false --e.g., NOT([Column])--, or it might increment the column's value--e.g., [Column] + 1. See more details in  Quick Update System - How to update records in you... - Google Cloud Community

Hi @dbaum , I actually need to apply this action but not at the row level but at the table level, and not from within the table itself but perhaps from a menu space. I don't know if this will be possible.


@Gustavo_Eduardo wrote:

not at the row level but at the table level


Execute an action on a set of rows


@Gustavo_Eduardo wrote:

not from within the table itself but perhaps from a menu space


Sorry--you did say "menu" in your original post and I skipped over that detail. You can't add an action to the views menu. You'd need to create a way to invoke the action from a user-selected button or data change event, or invoke it via a scheduled automation.

If you don't necessarily need it within the app's UI, you could create the action and then trigger it from the app editor via the automation test function.

Top Labels in this Space