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

    Is there a way to only see the YES responses of my Matrix tables in excell file?

    Asked by mchugh62 on May 09, 2014 at 11:26 AM
    Is there a way to only see the YES responses in excell for the Health chart bc my spreadsheet became toooo wide with all those answers. Is there a better way to document if there are any health issues?  I am using the church's old paper form to create this.
  • Profile Image
    JotForm Support

    Answered by NeilVicente on May 09, 2014 at 12:40 PM

    I am afraid the answer to your question is no. Matrix fields are considered as one field, but is separated on spreadsheets because there is no way to show such a table in a single column.

    A better way might be to replace the matrix field with a check box field.

    Here's how it would look:

     

    Sadly, using this solution means you will have to delete the exiting matrix field, deleting also the data that comes with it. But, you can edit the submissions and manually enter the data to the new check box field.

    Hope you find this useful. Do inform us should you need further assistance.

    Best regards

  • Profile Image

    Answered by mchugh62 on May 09, 2014 at 01:59 PM

    ok thank you

     

    When I did that ORIGINALLY before I went to matrix it still downloaded in to excell in several columns. 

    DO I need to format anything to just print the checked ones in the CHECK BOX format?

     

  • Profile Image
    JotForm Support

    Answered by NeilVicente on May 09, 2014 at 02:20 PM

    No, there is nothing you need to do for the selected checkbox options on a regular checkbox field to come out like that.

    Were you perhaps using a checkbox-type matrix then (still a matrix)?

  • Profile Image

    Answered by mchugh62 on May 09, 2014 at 02:29 PM

    probably! thank you.

     

    I am still having trouble with the Address output in email and submissions.