Table with filter

AppSheet AppSheet Q&A
1

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

2

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?

1 Like