Inventory App - Remove product from the view when there is a value in a column

[nadim_dayoub]

I am looking to hide product that is already sold and only displays available items depending on if there is a value in a column.

This is the view of my app displaying all the products

And here is the data source

If there is a value in the "Job Name" column, I would like that row not to display in the previous screenshot.

I tried searching around before making this post but had no luck. I am sure the answer is somewhere around these parts, just need a friendly guide to point me in the right direction. 

[Rafael_ANEIC-PY · Accepted solution]

You got it, but I'm not sure I'm following on that last part.

The idea is to use the Ref_rows to create an inline view using the slice as a source in order to filter those rows, so that you can use this to substitute this inline view:

Let me know if that works for you.

For reference:

https://help.appsheet.com/en/articles/2357313-ref_rows