In appsheet I have the following:
Add Stocks table:
Select(Add Stocks[Item Code],[_THISROW].[Item Code]=[Item Code])
Do This: Data: Execute an action on a set of rows
Referenced Table Sacos
Sacos Table:
Set these columns = Available Stocks
expression: index(Select(Add Stocks[NA Stocks Sacos],[_THISROW].[Item]=[Item Code]),Count(Select(Add Stocks[NA Stocks Sacos],[_THISROW].[Item]=[Item Code])))
Do This: Data: set values of some columns in this row
When I save all of these take into account Item = Item Code to replace a value in Avaliable Stocks column in Sacos Table.
What I need is to have a condition that go trough Sacos table, match useremail() with the email in UserEmail Column of Sacos than match Item with Item code
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |