I am newbie to Appsheet, this question may sounds very simple.
I have 2 tables : - Item stock, other 2. Item issues .
While entering Item issues, the user should be able to select rows where Stock Qty > 0
I have following columns in stock table.
Stock
1. Unique ID
2. Item Name (Eg. PU BC White)
3. Stock Qty (Eg. 8.00 pcs)
4. Item + Stock (Eg. PU BC While : Stk : 8, concatenated column, this is the label for search)
Issues Table
1. Date & Time
2. Unique Id referenced to link the above table
3. Issue Qty
My question is how to show rows having Stock qty > 0
I tried security filter, [Stock Qty] > 0, but not working
Request experts, KIndly help me to resolve this issue.
Regards
Jay
Hi @Jayadevan_V
Your method with the security filter sounds good.
is it a real column though ? Can you share a screenshot of your setting?
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |