JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can the max value in a cell be set to be dependent of the value of another cell?Asked by BarnyRud on March 26, 2015 at 06:14 AM
As an example:-
We have sell for the total quality of an item (a).
We have a cell for the quantity of the item to be inspected (b)
b should never be greater than a, is there any way in which I can set the cell (b) to never go higher than (a).
Thanks and Regards,
Yes. This can be achieved by using conditions wizard.
You can get the field ID of total quantity from the field properties.
This is how it works with the condition set.
Please take a look at the demo form and feel free to clone it to your account to see how it works.
Let us know if you need any further assistance. Thanks!