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

    I need simple math calculations, relative calculations and more... Is there a way?

    Asked by posrequest on December 07, 2010 at 10:29 AM

    first of all, GREAT PRODUCT!!!!

    I need some more small enhancements ...

    1) Enter a number, enter another number, give me a result based on a formula.

         Example 1:

         Estimated Costs:

                 Carpet:____(num1)

                 Paint:____(num2)

                 Materials:____(num3)

                Total: (=num1+num2+num3) or.. SUM(num1,num2,num3)

         Example 2:

         What is your average sale (in $) ? _____ (A)

         How many per week do you expect? _____ (B)

        Average increase per week, based on the user's input, will be: _____ (a x b)

    I think basic math would be great here, +,-,x,/,SUM,AVG,MIN, MAX, etc....

    If/Then's would also prove helpful. Basic "excel" style functionality, integrated with the form's conditions. If AxB>C then Show Field1.

    Which leads me to request #2:

    2) RELATIVE requirements for conditions.

       Examples:

       Date: __/__/__

      If Date = today then .. (existing condition, but still needs expansion)

      if Date > today + 5 days, then...

      if date1 > date2 - 1yr, then...

      if AxB>4.5 then... (from 1st example)

    3) Conditions to make other fields required, based on a calculation:

     If Date1 field is < (TODAY+3) then TextField2 becomes a required field.

       

    Any ideas? Thanks!!!

    -j.

     

  • Profile Image
    JotForm Founder

    Answered by aytekin on December 07, 2010 at 01:38 PM

    Thanks for the ideas. I added them to our requests list for calculations feature.

  • Profile Image

    Answered by incenergy on May 06, 2011 at 01:05 PM

    ***DO NOT CLICK ON THE LINK ABOVE***

    The link above posted by Sajego goes to a mailware site that attempts to download a virus.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on May 06, 2011 at 11:33 PM

    Thank you for the warning. I have already deleted that post.


    Regards