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.
Audit Form needs to calculate % successAsked by corporatecleaning on December 01, 2014 at 06:28 PM
We are trying to calculate the success percentage of our cleaning staff based off an audit.
Our audit rating system is based off three selections.
1) Meets Standard
1) Below Standard, and
3) Not Applicable
We use non applicable for audit items that are not part of the scope of work. An example would be "Stair Wells Vacuumed" in a building with no stairs.
The equation we are looking for is;
[meets standard]/([meets standard]+[below standard])
scope items 3 and
I see what you mean, I'll take a look closer on the equation that you have and will post the workaround that I have in mind. I'll get back to you as soon as I'm able to make my solution work in my end.
Here's the sample cloned form that I edited: http://form.jotformpro.com/form/43348003045950
What changes I did:
1. Added hidden input fields to store values specific to options: "Meet Standards", "Below Standards", "Not Applicable". I see in your conditions that each one has a value of "1"?
2. Add a condition to where if this checkbox is tick it will add a value on the hidden field.
Ex. If Entrance field has "Meet Standards" ticked, the hidden value "MeetStandardsM" will have a value of "1"
3. Added a Form Calculation for each total of "Meet Standards", "Below Standards" and "Not Applicable".
4. I don't quite understand the equation you have for the total % of audit, but you can check if my form does not correctly.
You can clone the form using this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
I hope this helps. Let us know if you need more assistance on this.
It would be better to use radio buttons instead of checkboxes to restrict users to a single choice for each field, as I've done here.
Thank you Abajan, I will use radio buttons on my final form. Great idea.
Thank you Charlie, there is beauty in the simplicity of your approach, thank you again.
On behalf of my colleagues, you're welcome.
Let us know if we can be of further assistance.