In a Table I have an action of type “Grouped: execute a sequence of action”.
It contains 3 actions that are:
1º- Action type “Data: add a new row another table”. It works well.
2º- Action type: “App: go to another view within this app”. It works well.
3º- Action type: “Data:set the values of some collumns in this row”. IT DOES NOT WORK. It is as if it had lost the situation where it was initially and it does not change the data that I ask for.
Is this an AppSheet bug or am I doing something wrong?
I assume the 2nd action stops the process when it opens a view. Try to rearrange the order.
I can’t, the objective of action 3 is to force columns in the initial table to be recalculated.
Now I have it solved with a bot that, based on the changes in the second, executes an action in rows of the first, but I wanted to improve the speed.
I’m afraid you need to rethink the logic.
Resolved!
Instead of using the third action that I mentioned at the beginning (and which is not executed because when editing a record the process is interrupted), what I do is in the edit form of the table to which I have added a record, within Behavior-Event Actions, put an action defined in this table but that changes a piece of data from the parent table (a simple counter).
This allows the parent table to recalculate the columns with formulas and the result is immediate for the user. I save myself from having to use a bot that always takes longer.
Excellent!