Reduce my product list when stock = zero

[engelmo]

Hello,

I'm looking to make my product list smaller. So when the stock reaches zero the list for sale gets smaller.
The most I could do was insert a msg when the stock reaches zero. But I would really like the listed item to appear only when the (available quantity > 0)

Any function I could use in table for this action?

[Marc_Dillon · Accepted solution]

Use FILTER in Valid_If.

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[Marc_Dillon · Accepted solution]

Use FILTER in Valid_If.

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[engelmo · Accepted solution]

Using ref -> get the list of product then to valid if using: 

SELECT(list of prod[cod prod], [av in stock] > 0() )

In theory, the idea of the code was right, however it lacked () to end the final line of the command. Thanks for the tip.

[Marc_Dillon]

---

@engelmo wrote:

however it lacked () to end the final line of the command

---

What?