Can the max value in a cell be set to be dependent of the value of another cell?

  • Profile Image
    Asked 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,



  • Profile Image
    Answered on March 26, 2015 at 11:01 AM

    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!