How to use drop down field in matrix calculation

  • Communicaid
    Asked on March 4, 2016 at 7:20 AM

    Hello,
    I've created a matrix question with dropdown list "yes" and "no" and I would like to add the values to the "yes"=1 and "no"=0.
    my question is: can I use the same role like here http://eu.jotform.com/help/343-How-to-perform-form-calculation-in-the-Matrix-field : yes1? 
    what is the css code to hide the numbers? 
    Thank you in advance for your help

  • beril JotForm UI Developer
    Replied on March 4, 2016 at 9:18 AM

    First of all when I've checked your conditions I see that there are missing data. You need to correct them.

    How to use drop down field in matrix calculation Image 1 Screenshot 30

    In addition to that when I've checked your form I realized that Your matrix field is hidden. Please note that, the hidden fields will not able to seen on the form. I will show how to use matrix tool on calculation :

    How to use drop down field in matrix calculation Image 2 Screenshot 41

     

  • beril JotForm UI Developer
    Replied on March 4, 2016 at 10:46 AM

    I've checked again. I though that it is  not possible to use drop down field on matrix field if you want to use it for calculation. However, now I've realized that you can also use drop down field while using calculation.=)

    I will show you again how to do that:

    After selecting your matrix field we will use 1 value for yes option.

    How to use drop down field in matrix calculation Image 1 Screenshot 40

    To do that, update your column as you see below:

    How to use drop down field in matrix calculation Image 2 Screenshot 51

    Here is how it works:

    How to use drop down field in matrix calculation Image 3 Screenshot 62

    Please, also test it on your side and let us know the result. Here is your cloned form. Feel free to clone it.

    https://form.jotform.com/60634318751960

    I look forward to hearing from you.

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Communicaid
    Replied on March 18, 2016 at 9:14 AM

    Thank you for your reply. 

    Calculation it's ok

    Now another question is : what is the css code to hide the numbers within the dropdown list?

     

  • beril JotForm UI Developer
    Replied on March 18, 2016 at 10:55 AM

    You're most welcome. We are glad to hear that everything is ok for matrix calculation. You can delete the numbers from your label as you see below:

    How to use drop down field in matrix calculation Image 1 Screenshot 20

     

    If you need further assistance please let us know. We will be happy to assist you.

  • Communicaid
    Replied on March 18, 2016 at 11:04 AM

    Hello Beril,

    I can't deleted it. I need this number for the matrix calcutaiton :-)

    I would like  to be able to hide and nod delete it. so the question is steal valide:  Do you know what is the CSS code of the content of the dropdown list?

     

  • beril JotForm UI Developer
    Replied on March 18, 2016 at 11:25 AM

    You're completely right. =D I thought them they are just a label. I see that they are not. If we delete them it is not working=)

    Let me try to figure out how to do that. I will get back to you with a solution.

  • beril JotForm UI Developer
    Replied on March 18, 2016 at 12:33 PM

    I couldn't find a solution for you yet. =( However, I will check deeper and I will update you via this thread as soon as possible.

  • Communicaid
    Replied on March 18, 2016 at 12:36 PM

    Beril, Thank you very much for your help :-)

     I hope you will find the answer! 

  • Communicaid
    Replied on March 23, 2016 at 4:06 AM

    Hi Beril,

    Did you manage to find the solution? 

  • beril JotForm UI Developer
    Replied on March 23, 2016 at 4:56 AM

    Hi again,

    Unfortunately, I see that it is not possible to hide that value due to depend on calculation.=( I've also asked it to my colleague and  he also corrected me.

    In addition To that when I've checked your form I see that it is so slow.

    Here is how it works on my side:

    How to use drop down field in matrix calculation Image 1 Screenshot 40

    That problem occurs due to you are creating conditions with hidden box fields on your form as you see below:

    Please note that hidden box fields is different from hiding with conditions.  Hidden box fields can never be displayed in a form because they use the html tag <input type="hidden"> which, when interpreted by the browser is a field that's invisible to the user. Because of that reason, there will be a conflict and your form will work slow.

    How to use drop down field in matrix calculation Image 2 Screenshot 51

     I suggest you to show those fields as you see below:

    How to use drop down field in matrix calculation Image 3 Screenshot 62

    Please, check the guide below for more information:

    http://www.jotform.com/help/316-How-to-show-or-hide-a-field-in-the-form-based-on-the-other-field-input-or-selection

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.