I´m reading this article: https://help.appsheet.com/en/articles/1363923-changing-data-from-a-workflow-rule-or-scheduled-report
And maybe I´m misunderstanding something or maybe there´s an error in the example.
Create an action. Set Action name to “Update Employee Status”. Set For a record of this table to the Employees table. Set Do this to “Data: set the values of some column in this row”. Configure the column and value to set the employee’s status to “Assigned”.
Create an action. Set Action name to “Get Employees to Update”. Set For a record of this table to the Employees table. Set Do this to “Data: execute an action on a set of rows”. Set Referenced table to the Employees table. Set Referenced Action to “Update Employee Status”. Set Referenced Rows to an expression that returns a list of row keys from the Employees table. The row keys will be used by AppSheet to identify the employees to be updated. For example, to select the employee that has been assigned to the current project, use the expression:
SELECT(Employees[Employee ID], [Employee ID] = [_THISROW].[Employee ID])
The last sentence is the problem: "Set Data Change Action Name to “Update Employee Status”. The dropdown only shows options from the same table. The generated actions referencing to Employees table do not appear as an option, so I cannot select the action.
Is this an error in the article or am I doing something wrong?
Thanks
Solved! Go to Solution.
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |