For example, let's say you have a fixed cost table and an expense table, and the fixed cost table has "item (text)", "amount (price)", and "status (yes/no)". You want to use the automation sucheduled to transfer the items with a status of "Y" in the fixed cost table to the expense table at the beginning of the month.
This works perfectly if you do it with just the action button.
Specifically, you create two actions, one is "execute an action on a set of rows" and the other is "Add a new row to another table using values from this row".
In the first Referenced Rows, you enter "select(fixedcost[fixedcostID], [status] = "Y")".
However, if you use the automation sucheduled, it will behave strangely. For PROCESS, select "run action on rows" and enter "select(fixedcost[fixedcostID], [status] = "Y")" in Referenced Rows. When you do this, for some reason, the rows with a status of Y are selected, but this is repeated for each row in fixedcost. In other words, even if there is only one row with a status of Y for, say, "Mobile phone bill," if there are 10 rows in the table, 10 rows for "Mobile phone bill" will be inserted.
I would like to know what I'm doing wrong.
LinkedIn
Twitter
