Inventory Management - Selecting next succeeding rows action

AppSheet AppSheet Q&A
,
1

Good day, I am new to appsheet and am trying to make an POS machine with multiple inventory management. When I tried the app it is only returning and decreasing the value of the 1st row.

For example I have 10 starting inventory then when I added 2 sales for that item it becomes to 8 left. but adding another sale that isn’t 2 it keeps just decreasing the value of just the 1st row.

Can anyone help me thanks. I used 3 actions and a bot.

Data: set values of some columns in this row

Data: execute an action on a set of rows

Grouped: execute a sequence of actions.

2

Sounds like the executed action is only subtracting by a hard-coded 1, instead of using the qty of the sale record. Maybe use INPUT() on the reference action pair to bring the qty through.

1 Like