How to dropdown list of running number till set limit

[167]

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.

[theo10008]

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)?

[167]

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

[Rafael_ANEIC-PY]

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