- mewersmannAsked on January 03, 2014 at 12:15 PM
To whom it concerns,
I had some calculated formula's and I was hoping to apply conditional formatting. The idea is that if the number shows between 0-X% then it will show up in Green. Then between X-X% then it shows up in Yellow. Then between X-X% then it shows up in Red. If there is an easier way to go about this then I sure appriciate your help. Feel free to call if you have any questions.
- EliezerNAnswered on January 03, 2014 at 01:57 PM
Jotform has the capability to perform conditional logics, you can read about conditions here: Smart forms using conditional logics
However, if I have understood correcly, you need to change the color of the form depending on the number selected. Is that correct? If so, let me inform you that is not possible to to do with our conditional logics function.
But if you need to show a field with certain color depending on the number a person selected, then it is possible by using our Show/Hide fields:
Please take a look at this example form: http://form.jotformpro.com/form/40023980583958
If the number you enter is less than 5 it will show RED, but if the number is greater than 5 it will show GREEN.
I hope this helps. Please inform us if you need further assistance with this.
- mewersmannAnswered on January 03, 2014 at 03:11 PM
I am not sure if the example had come through or I might not have been looking in the correct spot.
Can you offer assistance with my specific form? It is http://www.jotform.us/mewersmann/diiforecast_audit and I am wanting the form to react:
If % of HS Customers < 40% Capacity is less than 11 % than I want it to show the “Star Image” and Hide the “Needs Improvement” image. Then if the cell is greater than or equal to 11% than I would like it to show the “Needs Improvement” image and hide the “Star Image”?
Thanks for any help you can offer.
- JotForm SupportEltonCrisAnswered on January 03, 2014 at 04:30 PM