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.


  • Profile Image

    Audit Form needs to calculate % success

    Asked 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])

     

    Page URL:
    http://www.jotform.com//?formID=43305625040241

    scope items 3 and
  • Profile Image
    JotForm Support

    Answered by Charlie on December 01, 2014 at 08:38 PM

    Hi,

    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.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by Charlie on December 01, 2014 at 08:58 PM

    Hi again,

    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.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by abajan on December 01, 2014 at 09:22 PM

    @corporatecleaning

    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.

  • Profile Image

    Answered by corporatecleaning on December 02, 2014 at 01:59 PM

    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.

  • Profile Image

    Answered by raul on December 02, 2014 at 03:05 PM

    On behalf of my colleagues, you're welcome.

    Let us know if we can be of further assistance.
    Thank you.