Conditions: Inserting a value into one field based on a quantity in another

  • Profile Image
    Asked on April 29, 2015 at 08:24 AM


    Would like to know how to prepopulate a field regarding another field quantity


  • Profile Image
    Answered on April 29, 2015 at 10:20 AM

    Looking at the image above, that would be the right way to do it - checking if the value in Form Calculation is in the range we want and then inserting the right value into the field (Marge in the case above).

    The only possible issue that I see above would be that few conditions would be applied at the same time, so you should change them a bit to be with "ALL" matching (Rule 1 AND Rule 2), so it is changed into:

    If Total Vetement Greater Than "25" AND
     if Total Veterment Less Than "40"
        Insert 10 into Marge

    The same logic is then applied to the other conditions, except the top one (since we need to check if it is greater than it) and the bottom one on the screenshot (since we only need to check if the value is up to it).

    Hopefully this helps you, but if you would like us to help you with the actual form, we could do that as well, just let us know what is the form.

  • Profile Image
    Answered on April 29, 2015 at 05:52 PM

    Ok Thank you Ben,

    Just for some info I have to add more condition for 25 qty 40...

    Thanks for your help

  • Profile Image
    Answered on April 29, 2015 at 07:49 PM

    Please do let us know if further assistance is needed or if still not working as intended.