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

    On the widget "SPREADSHEET" formulas don't work well

    Asked by marchitect on June 12, 2015 at 06:31 AM
    hi, I need to use the widget "spreadsheet " but does not work well. I would have the need to use a part pre-set with of the written and other part with the formulas ( example d4 = a4xb4 ) . All these functions work when the amount , but if I upgrade or go to the preview widget is empty .
  • Profile Image

    Answered by Carina on June 12, 2015 at 09:57 AM

    Is it the form 51552395199364? I tested the Spreadsheet widget and the formulas are working well:

    If you need to add preset values you can use the default values option:

     

    ", but if I upgrade or go to the preview widget is empty . "

    I previewed the widget and it still showed the formulas and default values:

    What do you mean "if I upgrade"?

    We'll wait for more details to continue.

  • Profile Image

    Answered by marchitect on June 13, 2015 at 01:50 PM

    HI, i resolved the problem but now i'have  another one. I canghed the first line (A-B-C-D) with other word and other color...it's go perfect! But i can't see the color posted in CHROME, it go perfect in FIREFOX and EXPLORER...but the background  color it's TRASPARENT in CHROME...  

    i USED THIS CSS CUSTOM:

    tr:first-child {
        background: none #DC143C;
      
    }
    th#col_A {
        max-width: 0;
        visibility: hidden;
    }
    th#col_A:before {
        content: "TIPOLOGIA";
        color: #000060;
        visibility: visible;
    }
    th#col_B {
        max-width: 0;
        visibility: hidden;
    }
    th#col_B:before {
        content: "n°PAX";
        color: #000060;
        visibility: visible;
    }
    th#col_C {
        max-width: 0;
        visibility: hidden;
    }
    th#col_C:before {
        content: "€ a PERSONA";
        color: #000060;
        visibility: visible;
    }
    th#col_D {
        max-width: 0;
        visibility: hidden;
    }
    th#col_D:before {
        content: "€ TOTALE";
        color: #000060;
        visibility: visible;
    }

    .A input{width: 120px;text-align:left;}
    .A input{height: 16px;text-align:left;}
    .B input{width: 120px;text-align:right;}
    .C input{width: 120px;text-align:right;}
    .D input{width: 130px;text-align:right;}

  • Profile Image

    Answered by marchitect on June 13, 2015 at 02:35 PM

    Another problem is that i have to chage "," in ".". The real problem is that the form is used to make calculations. being able to enter a comma (,)
    as a decimal divider (in Italy and is widely used)

    that happens : if 10.5 + 10.5 = 11  10.5 + 10.5 = 10 . THIS ' A PROBLEM . HELP ME
    .
  • Profile Image

    Answered by Carina on June 13, 2015 at 06:16 PM

    I moved these last questions to new threads as they were different issues. You can find them here:

    http://www.jotform.com/answers/588052 

    http://www.jotform.com/answers/588048 

    Let us know if we can assist you further.