We're setting up your new app...

Sample app

Reference Actions

This app shows how to use reference actions

Industry: n/a
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.

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.
Start for free