Sorry for the unclear subject.
What I trying to do is, I have a stock list of inventory and trying to create a dropdown of running number base on the stock inventory.
Example:
Item - inventory
Apple - 10
Orange - 15
------
When select Apple in item, the quantity will have a selection of dropdown from 1, 2, 3, 4....., 10.
When select Orange, the dropdown will show 1,2,3.... 15.
Any suggest will be appreciated.
Thank you.
Hey, can you explain a bit further? If I understand correctly you want to have a dropdown with just numbers? Why can't you just use a numerical input (Base type: Number)?
Hi,
yes, I will just like to have running number in the dropdown.
Limit to the number of my current stock.
I want to let the staff know what are the amount they can order
Hello @167, you can use a valid_if() expression for that, for example, if they are adding a row to a table called "Product orders" with each row having a reference to a "Product" table which contains a "Current stock" column, your expression in the valid_if() would be:
[_THIS]<=[Product REF].[Current Stock]
But you can't show this in a numeric series in a dropdown list, you can have them input the number or use a bar for draging tho
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |