How can I prevent or show an error msg when a user tries to enter a number if the available stock is zero or negative?
Please help!
Kay
You would need to add a validation to your [Number] column, but you can read the value from the "Available Stock" column. For example something like this should work.. [Available Stock]>0
Thanks my problem got solved!!
You're welcome!
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |