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 perform calculations based on the Spreadshseet widget cells?

    Asked by jabedoya60 on July 26, 2017 at 08:35 PM
    Hi, any suggestions will be much appreciated, just want the parents to select the classes they want and a total added at the bottom right field, that is all. thank you.
  • Profile Image
    JotForm Support

    Answered by Kevin_G on July 26, 2017 at 08:52 PM

    Unfortunately, it's not possible to perform calculations based on cells selection; however, it is possible to perform calculations based on the information entered on each cell in the widget. 

    If you would like to perform calculations based on field's selections, then you may try using the Input Table, it can be found under the quick elements section: 

    This guide will help you performing calculations based on the Input Table field: https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition 

    I hope this helps. 

  • Profile Image

    Answered by jabedoya60 on July 26, 2017 at 10:54 PM

    You have to be kidding me, look at the very beginning of this post, I asked for help by showing an image of the table I needed to create, I followed all the suggestions, edits, corrections, I have asked the question about adding the classes over and over again and now you are telling me that I have to start from scratch with a different table??

     

    Look again at the image which I posted from the beginning last week:

     

  • Profile Image
    JotForm Support

    Answered by Nik_C on July 27, 2017 at 05:03 AM

    We apologize, but in your original post, you were asking CSS related questions regarding how your table looks like, font sizes, font alignment etc.

    Spreadsheet widget is used when you want to enter certain data in it, but its cells can not be used to do calculations outside of it.

    You could calculate the total in Total row by using the formula:

    But that will require that your numbers are without the dollar sign.

    I must agree with my colleague, Input table is the field you need in order to use its cells in form calculations.

    But the issue here is that you can not set default values in the table unless you use pre populate URL.

    But I did some work and created this:

    I added one Input table and by using CSS I brought it up and made it as a fifth column, those check boxes you can use in calculations.

    I added the below CSS to make it work:

    th.form-matrix-row-headers {

        position: relative;

        left: 109px;

        width: 80px;

        border: none;

        z-index: 99;

    }

     

    td.form-matrix-values {

            text-align: left!important;

    }

     

    div#cid_55 {

        position: relative;

        left: 474px!important;

        top: -490px!important;

    }

    th.form-matrix-column-headers {

        background-color: white;

    }

    th.form-matrix-row-headers {

        background-color: white;

    }

    td.form-matrix-values {

        background-color: white;

    }

    Also, I added one form calculations field to calculate the total:

    Finally, this is how it works:

    Feel free to check my form: https://form.jotformpro.com/72071671385963

    Let us know if you have any further questions.

    Thank you!

  • Profile Image

    Answered by jabedoya60 on July 27, 2017 at 10:03 PM

    Hi, that is perfect, thank you so much, how can i copy or clone the table to my form? Also, when I check out your form it looks a bit different when I select a few classes, look at the screenshot below, I get a yellow block of space under the table, and the toital field goes off to the right of the table, other than that it is perfect. Thank you again, is awesome!

  • Profile Image
    JotForm Support

    Answered by Kiran on July 28, 2017 at 01:10 AM

    You may clone the form to your account by following the guide below:

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    In order to fix the table alignment on the top, please try changing the top margin to -510px from -490px in the injected CSS code.  

    Please get back to us if you need any further assistance. We will be happy to help.