Update 2 related column value by action

AppSheet AppSheet Q&A
, ,
1

Hi all,

I am creating an appsheet to manage inventory but I have a trouble. In my table, I have a column named Quantity and another column named Order. When an user create an Order, they will input value into Order column. I want to create an Action to confirm that Order be received. So I want that action contains these following things:

  1. Add a new row to that table and let the user input information (Or just Edit the Current row)

  2. Update new value of Order based on the value of Quantity user inputs.

  3. If possible, leave the value of Order blank if [Order] = 0.

Is that possible to create these action that I mentioned above? If yes, could you tell me how to create those?

Thank you guys so much

2
Actions: The Essentials - AppSheet Help
1 Like