This app shows how to use reference actions
This app shows how to use reference actions. Reference actions are used to modify a row in one table via an action defined on another table. In this example, we have a Parent table and a Child table. The Parent table has an action called "+1 All" that adds 1 to the Number column of its associated children records. Try it out.
Also see: tablet mode & fullscreen mode
How we built this app
To do this, we defined two actions. On the Child table, we added an action called "+1" that adds 1 to the current row's number column. This is a regular "Set column value" action. On the Parent table, we added an action called "+1 All". This is a reference action. The reference action is going to call the "+1" action on the Child table, so we pick "Child" in the Referenced Table dropdown and "+1" in the Referenced Action dropdown. A reference action needs a list of keys from the Child table in order to call this. The Parent table already has a virtual column called Children that holds the referring rows to that Parent row. So we just wrote [Children] for the Referenced Rows field in the action configuration.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.