Configuring data change actions

With data change actions, a user can edit or delete existing rows or add new rows to an app. We will look at four different types of data change actions.

Actions for setting the values of some columns in a row

A data change action of the Data: set the values of some columns in this row type can change one or more columns in a row. You can configure this action with the settings shown in the following figure:

Figure 5.5 – Row-level data change action settings

You can only change the data in columns that have no app formula or no spreadsheet formula through data change actions. You also cannot set virtual columns in data change actions.

Using the INPUT() function with data change actions

In the preceding section, we learned that the data change value is always set to a fixed value of Approved whenever the user invokes the action. However, at times, the app’s business logic may need to allow the user to...