Show Message if sum total of two fields isn't greater than or equal to 4

  • Profile Image
    cgl102770
    Asked on April 26, 2015 at 12:22 PM

    If not, then a message pops up. Is this possible? The fields are 'indoor cameras' and 'outdoor cameras'. Thank you for any suggestions.

  • Profile Image
    Shadae
    Answered on April 26, 2015 at 01:35 PM

    Hi cgl102770,

    Yes this can be achieved using a hidden form calculation field and our hide/show condition.

    You would use the calculation field to add up the total for the two fields. As this is not needed to be seen by your user, this field can be hidden.

    Once that is created, you would create a condition for your calculation field. If less than four, you would have the text field with your message shown.

    You can view my sample form here: http://form.jotformpro.com/form/51155251292954 

    Please feel free to clone the form to your account to inspect it further.

    Please inform us if you need further assistance.

  • Profile Image
    cgl102770
    Answered on April 27, 2015 at 08:26 PM

    Thank you, that's definitely an improvement.

    http://www.jotform.com//?formID=51157051393148

    Just two questions:

    1. Is there a way for the calculation field to be blank, rather than default to zero, at the beginning?

    2.

    Is there a way to prevent the form from submitting if they have less than 4 cameras? I can hide the submit button but I'd rather show the "the minimum total of cameras is 4" message instead so it will be more obvious to the customer.

    I understand if this isnt doable, I appreciate your help.

     

  • Profile Image
    Aury
    Answered on April 27, 2015 at 09:09 PM

    I went ahead and made the necessary adjustments to your form in the following cloned link:

    http://form.jotformpro.com/form/51168157172960

     

    Regarding your second question, that one will be answered in another thread I opened for your. You can see the answer in the following link: http://www.jotform.com/answers/560115.

    For additional questions we used to make that request to answer in the most appropriate manner.

     

    I hope this helps.

  • Profile Image
    cgl102770
    Answered on May 06, 2015 at 07:30 AM

    I'm sorry to ask again, though I accidentally deleted your cloned form, I saw it before I saw your post and thought it was something I did. Is there any chance you could recreate that again? I feel like I should pay for the support you have given.

  • Profile Image
    Charlie
    Answered on May 06, 2015 at 10:07 AM

    Hi,

    You could try this form instead, I'm not sure if the formula is correct: http://form.jotformpro.com/form/51253617026954.

    So, basically, instead of adding the formula in the form calculation widget directly, we added it on the conditional logic and setting the default result to blank.

    I then set the conditional logic like this:

    I hope that helps. Please do feel free to clone my form if needed.

    Thank you.

  • Profile Image
    cgl102770
    Answered on May 06, 2015 at 10:43 AM

    This is great, thank you!