What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Show Message if sum total of two fields isn't greater than or equal to 4Asked by cgl102770 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.
greater than equal to OR Than
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.
Thank you, that's definitely an improvement.
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.
I went ahead and made the necessary adjustments to your form in the following cloned link:
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.
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.
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.
This is great, thank you!