Why would you need a value list for entering a number?
I know one way I could do is just have an field, where user can type the number of quantities arrived.
I though value list would be better to show me options of quantities arrived.
So for example, If I order 3 computers, 2 computers will arrive first so I will go on arrive page and would like to have an dropdown menu where I can select the quantities arrived. If the quantity order was 3, In the dropdown I want to 1,2,3; in case any number of quantity arrive.
1 of 1 people found this helpful
Let's see if this solves the problem.
Attached is a demo file with a Quantity Ordered field and a Quantity Received field.
Through use of an intermediary calculation, custom function and relationship, I have
built a value list that shows all possible quantities up to and including the ordered amount.