Table with filter

[Jayadevan_V]

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

[Aurelien]

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?