Update value on another table

AppSheet AppSheet Q&A
,
1

Hello

I have 3 actions and 2 tables
1..order table
2. user table

Actions

  1. order table -
    sets a variable to the order in a column Tmp_var
  2. user table -
    An action should use the set variable in the order table Temp_Var to write the OrderID in the user table for the logged in user using useremail()
    3rd order table -
    Resets the variable

I can get action 1 + 3 to work, but I don’t understand how I can execute action 2.

Thanks in advance for help

2

Please read this guide: Actions: The Essentials - AppSheet Help

3

I have an action for the user table that sets the value there, but I can’t execute it directly in the other table in the grouped action.

4

In that other table, you should first have an action to set the value of a column. Then in the group action, you should have an action of type: Execute an Action on a set of rows.

To pass the value between the two actions you should use the INPUT() function.