How to ensure that total input value adds upto 100%?

  • CRPCNCommunications
    Asked on August 26, 2019 at 5:50 PM

    Hello,

    I am looking for way to phrase a question.

    We want to figure out how our clinicians spend their time, and we need to ensure that the numbers they input add up to 100%.

    Any tips you can give me?

  • Augustine_O
    Replied on August 26, 2019 at 6:52 PM

    Hello, 

    With my understanding of your question, I can see you wish to create a survey for your physicians and you need to understand a better way to do this. 

    You can try following our survey guides to help you create a perfect survey for your respondents. 

    A Guide to Creating the Perfect Survey Form - Part 1

    A Guide to Creating the Perfect Survey Form - Part 2

    How to create a survey form and customize it

    How to Create a Solid Customer Satisfaction Survey


    I am positive that these resources can help put you on the right track. 

    Please, let us know if you need further assistance and we will be happy to help.

    Thanks :-)

  • CRPCNCommunications
    Replied on August 26, 2019 at 7:43 PM
    No - can’t say this did help.
    Was hoping you might have an example where all numbers had to add up tp 100%.
    Thanks anyway
    ...
  • Girish JotForm Support
    Replied on August 26, 2019 at 9:31 PM

    You can use Form calculation to ensure that the inputs add to 100%. I can see from your form that you have added the Input table to capture this info and also set it to Numeric text box. 

    Your conditions also seem correct, except for a few changes. Please remove the last "=%" added in the condition below. This will ensure that the "Total" field has the correct value.

    15668687012708 2 Screenshot 10

    Once this is done for all the four conditions, you'll get the correct Total value.


  • CRPCNCommunications
    Replied on August 26, 2019 at 9:43 PM
    Wow - thanks!
    ...
  • CRPCNCommunications
    Replied on August 31, 2019 at 9:43 AM
    After making these changes, users can still input numbers that either fall short of 100% or exceed it.
    Any thoughts?
    Thank you
    ...
  • Victoria_K
    Replied on August 31, 2019 at 12:40 PM

    Hi!

    Apologies, but it seems we do not have any direct option to force input that would total to 100%. But, as a workaround, I can suggest to warn users that they have entered incorrect values. 

    Let's say, you can add a text element to your form (containing text of warning) and display it conditionally if total is not equal to 100. 

    Here is a screenshot: 

    How to ensure that total input value adds upto 100%? Image 1 Screenshot 20

    To apply a condition, please check: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Also, it worth mentioning that conditions can not check input of a table cell, so you probably need to copy or calculate total in a hidden textfield or Form Calculation widget to build a condition based on it: How-to-Perform-Form-Calculation-Using-a-Widget