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

    New Calculation Widget

    Asked by District1010 on February 27, 2014 at 06:49 AM

    Since the change-over earlier it seems that we are unable to have a default value of '0' this impacts on my form, or at least I think it does? If we start with the Dinners that works perfectly, all the calculations are fine:

    4

    To make my point note the Fir/Sat entry

    5

    b. Calculate Field is available

    7

    and we can set a default value of zero '0'

    Now move down my form to Delegates and pick the same dayas and 

    8

    There doesn't seem to be a way to have a set value?

     

    I'm fairly sure the series of drop-downs require the zero's to be in place?

    3

    Having said that I have to admit to not being very clear how these actually work - an explanation would be helpful

    Thanks

    Peter

     

    Page URL:
    http://www.jotform.com//?formID=40563500675957

    uploads height calculations jpg
  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 08:05 AM

    Hello Peter,

    Good to hear from you again.

    Hmm - I'm afraid you cannot use that field as it is.... its properties are limited

    Just replace those fields - Delete, duplicate the replacements from the one which works properly, then rename:

    About the 0/1 values in the Yes/No fields - I take it you want to add them as a factor in the calculation - so here's how you do it:

    1. Yes - the Yes/No fields need to have No (or Zeros) selected by default - so that the calculation will eliminate options that have not been selected by factoring them to zero -

    Here's how I designed the field so that it is added into the calculation:

     

    The <em></em> tags will dissapear and leave an italicized number, that's fine, we just don't want them to show on the form. 

    To hide hose numerical values on the live form, just add the following CSS rule into your form using this guide:

    em {
    color:transparent;
    }

    Now you can add the field in any calculation, and using the 0/1 based on what the form user selects (or whatever you have in there), you can manipulate the result of the calculation.

    Here's a guide that might clarify things:

    https://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

  • Profile Image

    Answered by District1010 on February 27, 2014 at 08:09 AM

    That's where my problems started - you can't duplicate those fields anymore someone at Jotform removed that ability earlier today - see here

    http://www.jotform.com/answers/339435-Calculate-field-option-not-available-for-new-fields#3

    Thanks for explanation of those drop-downs I'll take a look but for the moment my BIG probelm is those workable fileds, I don't see a way to replicate them?

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 08:28 AM

    I beg to differ:

    Are you having difficulties? Please try again -

  • Profile Image

    Answered by District1010 on February 27, 2014 at 08:29 AM

    This might prove clearere as it clearly shows what happens when attempting to dulpicate the working field.

    The top field is the 'wrking' one with calculations working and the duplicate starts logically with duplicate

    a

    here's the duplicate having 'lost' the calculations field

    b

    I guess the other route is to ask you how to recreate the original fields so that it works for me - by all means use either of the Delegates (you'll note that we now have a Youth / Junior Delegate

    Here's the link

    https://www.jotform.com//?formID=40563500675957

    Thanks 

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 08:35 AM

    I understand - you want to manipulate the calculations - sorry about that - where was my head?

    Here's how to get the new fields:Click on the widget - it will add the calculation field

    Does that help.

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 08:35 AM

    I understand - you want to manipulate the calculations - sorry about that - where was my head?

    Here's how to get the new fields:Click on the widget - it will add the calculation field

    Does that help.

  • Profile Image

    Answered by District1010 on February 27, 2014 at 08:41 AM

    OK now your head is back in place. So in that case we don't duplicate anymore but recreate the whole thing - correct. No big deal of course other than the margin for error has significanly incresaed BUT I cannot make that new calculations field have a default value of zero '0' and am I right it needs to be zero?

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 08:54 AM

    Two options

    1. Put a zero in the calculaiton editor - I'm guessing that may not be an option - had to say it anyway

    2. Your calculation equation will be zero if you add the drop down fields (yes/no) as a factor -

    On Live form - see?... its zero (new calculation test field):

    It will not shown in the form editor - but it will be zero once the form is loaded.

  • Profile Image

    Answered by District1010 on February 27, 2014 at 08:59 AM

    Starting to make sense to me, I have started a new thread Calculations in a filed based on earlier customer response Y/N. I am struggling to see or realise exactly how we add those drop down fields in to the Calculations?

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 09:08 AM

    The label of the drop down fields is what you select- in my previous response  - I added the Friday Dinner field.

    Yes - not very easy to figure out , I agree - but if you have unique labels on each field (normally called a question), then you would be able to figure out which fields to drop in for calculation.

  • Profile Image

    Answered by District1010 on February 27, 2014 at 09:21 AM

    Not sure why but I am not seeing the images in your responses when viewed via the Forum on the JotForm website.  However, they do appear when opened directly via my Email - amazing now it does begin to make sense and in fact it's clear - many thanks. What I can say is that the explanation given here

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    is far from being clear.

    Thanks again!

  • Profile Image
    JotForm Support

    Answered by TitusN on February 27, 2014 at 09:34 AM

    Yes, Its a new guide - We're still working on it - thanks for the feedback.

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 28, 2014 at 09:07 AM

    We have added some screenshots to the widget page:

    http://widgets.jotform.com/widget/calculation

    Here is a video: