Hiding and editing entries when inventory is 0

[suzukixxx]

For example, let's say that the product name column in the "sales table" is set to ref type and "valid if" is set so that only products with an inventory amount of 1 or more in the "product table" can be selected. In this case, once the inventory becomes zero after the product is sold, you will not be able to edit the entry once made. Is it possible to prevent this situation from happening? I want to know how. If that is not possible, I have only come up with countermeasures such as displaying the product in red if the inventory amount is 0.

[dbaum]

Conditionally allow column edits (Editable_If) - AppSheet Help

Control whether and when a value can be edited in a form - AppSheet Help 

[suzukixxx]

Thank you very much.
I don't fully understand it yet, so I'm going to read this and study it.

[Kirk_Masden]

I think you may be asking about something different but your question reminded me of a problem I had with views based on slices that had become empty.  In that case, I used the following technique to substitute a different for the one based on the empty slice:

Make many views do the work of one