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

  • maryann61744
    Asked on September 1, 2016 at 5: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

  • Kiran Support Team Lead
    Replied on September 1, 2016 at 6: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:

    Numerical labels of Matrix columns are confusing with the form calculations Screenshot 20

    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. 

  • maryann61744
    Replied on September 2, 2016 at 9: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.

  • Chriistian Jotform Support
    Replied on September 2, 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.

  • maryann61744
    Replied on September 2, 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

  • Kiran Support Team Lead
    Replied on September 2, 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!