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

    Numerical labels of Matrix columns are confusing with the form calculations. Please help.

    Asked by maryann61744 on September 01, 2016 at 05:56 PM

    Hello,

     

    I'm trying to use numerical labels for my columns, such as:

    1-2/wk <span> 1 </span>

    3-4/wk <span> 2 </span>

    but these numbers are confusing the form calculation. Is there something I need to do to tell the system that these numbers are text and aren't numbers that are values for the column.

     

    Thank you

    MaryAnn

  • Profile Image
    JotForm Support

    Answered by Kiran on September 01, 2016 at 06:10 PM

    You may assign the calculation values to the matrix input fields from the Options tab in the Matrix field properties. Please see the image below:

    When the calculation values are assigned to the field, the numbers in the labels should be ignored. Please give it a try and let us know if you need any further assistance. We will be happy to assist. 

  • Profile Image

    Answered by maryann61744 on September 02, 2016 at 09:24 AM

    Thank you! That worked. I was putting the calculation values like this, which was why it wasn't working:

    1

    2

    3

    4

    5

    There was no place in the help that mentioned the entry format for the calculation values.

  • Profile Image
    JotForm Support

    Answered by Chriistian on September 02, 2016 at 10:35 AM

    Hi,

    On behalf of my colleague, you are welcome. Glad to hear the we were able to help. If you need further assistance, please don't hesitate to contact us again.

  • Profile Image

    Answered by maryann61744 on September 02, 2016 at 11:32 AM

    Thank you Chriistian. I have another question.

    In the report, the value from the matrix is showing both the label and the number I assigned for that selection. How can I remove the column label from showing up in the excel report. I only want to see the value.

     

    Thanks again,

    MaryAnn

  • Profile Image
    JotForm Support

    Answered by Kiran on September 02, 2016 at 12:21 PM

    @MaryAnn,

    Your other question is moved to a separate thread and shall be answered there shortly.

    https://www.jotform.com/answers/923214

    Thank you!