Update value on another table

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

 

0 3 116
3 REPLIES 3

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

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.

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.

Top Labels in this Space