In this video, we discuss AppSheet actions that you can use to change some of the data used by your App. Data change action types include; Data: add a new row to another table using values from this row, Data: delete this row, Data: execute an action on a set of rows, Data: set the values of some columns in this row. Let's review each of these actions. With the action type Data: add a new row to another table using values from this row, you can quickly add a row of Data to another table in your app by specifying the target table and its columns. For example, what if you wanted to automatically create a supplier order when a new product is added via the app? To implement this functionality in our sample app, we create a new action for the products table. Configure this action by setting the action name, initial supplier order, the table to which it applies, products, the type of action, add a new row to another table using values from this row, the other table to add the new row to supplier orders, the columns of the supplier order table, and their values that will be used for the new row. After the action is created, you set it as the form saved event action for the products form. This form is used when a new product is added or edited via the app. Now when a new product is added to the products table via the app, a new supplier order row is also created for that product in the supplier orders table. Note that you can also specify a condition in the action configuration to conditionally execute this action and prompt for the app users conformation. The action type Data: delete this row, can be used to delete the current row in a table. The action type Data: execute an action on a set of rows, allows you to execute another action on the current table on a related table. You must provide the related or reference table name, the reference action, and an expression that evaluates to a list of row keys from the reference table that this action applies to. This action can be used to make changes to rows that are related to the current row in a table. In our sample app, products are ordered from suppliers when required. If a supplier discontinuous a specific product, the app user would edit the product to update or remove the supplier information via the app. Any pending supply orders for that product would also need to be updated or deleted. Let's review how we can implement this using the two actions, Data: delete this row, and Data: execute an action on a set of rows. We first create a delete action on the supplier orders table. This table contains a list of orders for a product from suppliers. Here we create a new action and configure it with the action name, Delete Supplier Order for a record of this table, Supplier Orders, do this reaction type Data: delete this row. Next, we create another action on the products table that will reference a delete action created earlier. For this action, we configure the action name, remove pending supplier orders for a record of this table of products to do this action type Data : execute an action on a set of rows. Reference table, supplier orders. Reference rows, a list expression that returns a list of rows from the supplier orders table, whose product column value matches the current product ID, and whose status is spending. We use the app sheet filter function for this expression. Reference Action, the action to invoke on the reference table supplier orders, which in this case is the action Delete Supplier Order that was created earlier. We only want this action to execute when there is no supplier ID for this product. In the action configuration, we set the expression ISBLANK Supplier ID. This expression uses the ISBLANK function which evaluates to true if the Supplier ID column of the current row in the product's table has no value. We also want the app user to confirm the deletion, so we enable the needs confirmation option and specify the text of the confirmation message that is used to prompt the app user when this action is invoked. Finally, we set the Remove Bending Supplier Orders action as the Form Saved action for the products form and save our changes to the app. Now, when an app user updates a product in the app to remove a supplier, the action executes, and the app user is prompted to remove any pending supplier orders. The action type Data: set the values of some columns in this row enables you to set or update the value of one or more columns in the current row of a table via the app. You configure the action with a list of the tables' columns, and the expressions to use to set the column values. Some common uses of this type of action include, updating the status of priority of a task or ticket, setting the current date or time, assigning ownership of a job by setting an owner column. Note that you cannot use this action type to set the value of a column that contains an app formula, or if the type of column is any of the change column types.
