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

    How to display the result of answers at the end of the form using the name of the fields?

    Asked by Francois Byrne on February 26, 2016 at 11:18 PM
    How do I get the result tabulated into a table at the end and sent out by email for our records?
    Francois
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 26, 2016 at 11:25 PM

    Take a look to this sample form that I made: https://form.jotform.com/60568402923961

    You may insert the result of a calculation into a text box and then take this value and display it at the end of your form. 

     

  • Profile Image

    Answered by Francois Byrne on February 28, 2016 at 10:45 AM
    We are looking to have "yes and no" as our choices with the answer providing a series of results (such as 0, 1, 0, 1) to a backend calculation. At the end of all the questions, the values are to be displayed in a table.
    ...
  • Profile Image
    JotForm Support

    Answered by Boris on February 28, 2016 at 12:46 PM

    In order to send an email upon submission to your own email address, please take a look at our guide on setting up email notifications.

    If you want the person submitting the form to also receive an automatic email as well, you will need to also create a form autoresponder.

    If you want the selected options on your form to be forwarded as something else to a form calculation, you can simply assign calculation values to the options. For example, you could assign a calculation value of "1,0,1,0,0,0,0,1,0" to the option Yes, and assign calculation value "0,0,0,0,0,0,0,0,0" to the option No:

    This means that when Yes is selected in that question, it will forward the calculation value for yes inside conditions for updating fields or inside form calculations.

    Please see the following demo form to see if this is what you were looking to achieve:

    https://form.jotformpro.com/form/60584990752971

    After you sign up for a free account, you'll be able to clone this form into your account to take a closer look into how it was set up. Please let us know if this is what you were looking for, or kindly explain in a little more details what you are trying to achieve, and we'll do our best to help. Thank you.

  • Profile Image

    Answered by Francois Byrne on February 28, 2016 at 05:45 PM
    We need a result table that actually uses the results to tabulate value and populate a table like the one attached.
    ...
  • Profile Image

    Answered by Francois Byrne  on February 28, 2016 at 05:50 PM

     

  • Profile Image
    JotForm Support

    Answered by Chriistian on February 28, 2016 at 10:42 PM

    You can add a Form Calculation widget for each category.

    In this example, the calculation will calculate the category 1.

    1. Add a Form calculation widget. To learn how to perform calculations, check out this guide: How to perform calculation in the form?

    Once you have created the calculation by following the previous guide, it's time to insert the result to the table.

    2. Add the table where the result will be tabulated.

    Form Tools > Text > Insert Table

    3. To display the result from the Category 1 Calculation, we need to type its name in the cell of the table. In this instance, that name is {category1}.

    To find out the name of a field, simply click the gear icon and select Edit Properties.

    As you can see, the field's name is {category1}. So now that we confirmed the name, you can type the name {category1} in the cell of the table.

    4. This is how the result will appear once you preview the form.

    As you can see, the table displays the result calculated from the Category 1 Calculation into the Category 1 column.

    Here's a link to the demo form so you can see it in action: https://form.jotform.com/60588005654963

    You can also clone it to your account by following this guide: How To Clone A Form

    Do let us know if you need further assistance.

     

     

  • Profile Image

    Answered by Francois Byrne on February 29, 2016 at 09:45 AM
    Thanks for getting back to me.
    The issue here is that the value generated from the Yes or No answer is a matrix of values (0, 1, 1 ,0 ,1) That must populate all result boxes.
    Is this achievable?
    ...
  • Profile Image
    JotForm Support

    Answered by Nik_C on February 29, 2016 at 11:21 AM

    Hello there,

    Can you explain little bit more that matrix, according to your original post, for yes, you have 1,0,1,0,0,0,0,1,0. So you will have nine categories or how?

    And, what is a logic for those calculation please, like how the 'Yes' is 1,0,1,0,0,0,0,1,0 ? So we can see if it is possible to do it with calculations like my colleague suggested.

    We'll wait for your response.

    Thank you.

  • Profile Image

    Answered by Francois Byrne on February 29, 2016 at 11:45 AM
    Correct, the matrix is of nine categories (I was just using less as an
    example). These matrix values are manually input for each yes or no value
    then tabulated at the end in a results table.
    ...
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 29, 2016 at 12:13 PM

    Please allow me some minutes, I will work in a sample for based on your explanation, I will get back to you as soon as I get the form finished.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 29, 2016 at 12:51 PM

    I have a possible workaround to achieve what you want.

    I took the idea provided by my colleague Chriistian above, I used conditions to achieve it, please follow the steps as described below.

    1. Add your question, I will add a drop down in this case.

    2. Add a "Text Box Field" for each category.

    3. Add the table, here you will need to get the name of each "Text Box" field that you added before, this guide will help you to get the names of the fields in your form: http://www.jotform.com/help/146-How-to-find-Field-IDs-Names

    Once you have the names, add them on each category in the table.

    4. You will need to add  some conditions to display the results on each field and in the table, select the "Update/Calculate Field" condition.

    Now you can create the conditions and add the value to each category, for example, if the answer is "Yes" then add the value "1" to the field named "Category 1", and if the answer is "No", then add the value "0" the the same field, you will need to do the same with all the categories in your form, as you have 9 categories you will need to do 9 conditions for the "Yes" answer and 9 conditions for the answer "No".

    5. Set the fields where the value will be entered as hidden, you will avoid to show a lot of fields with the results of each answer.

    Take a look to my sample form: https://form.jotform.com/60568402923961.

    Feel free to clone it.

    This is how it works.

    You will need to follow this procedure for each question that you want to add to your form, but it will display the results at the end of it in a table as you want.

    Hope this helps.

  • Profile Image

    Answered by Francois Byrne on February 29, 2016 at 05:45 PM
    I gave this a shot but it only seems to work for the first question. See: https://form.jotform.com/60596128844161
    ...
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 29, 2016 at 06:57 PM

    This is because you need to duplicate all the hidden values, for example, you have 5 questions now in your form, as are 9 categories you will need to add 9 hidden text boxes for each question, as well as the conditions, currently only to make it work with the first question there are 18 conditions.

    It means that you need to add 36 hidden fields and 72 conditions to make it work with each question.

    You also need to modify the table as show in the image below.

    This is the only way that I found to achieve what you want. Otherwise you will need to split the array of data that you have, something that as far as I know is not not possible to do.