Bug: Bot process does not write AppScript function return value to a row in some cases

Hello,

If columns used in filter condition (when ForEachRowInTable is set) are also written to as a result of AppScript function call, the result will be written only in the last filtered row (but function will be called on each filtered row anyways).

Example of a bot: Every hour # on TableA # with condition where Column_1 is blank # Run a task to Call a script function Test() that returns String # write that return value to Column_1 of the TableA row that it was called upon

If we have 3 rows that were filtered, function Test() will be called 3 times (I see in the logs), but the return value of Test() will only be written to the last row.

If I remove Column_1 from condition, and put Column_2 (note that function result is still written to Column_1), then return value of function Test() will be written to all of the three rows.

So this weird issue occurs only if I write to columns that are used in filtering condition.

If you didn’t already, be sure to report to AppSheet Support.