Calculation Widget not listing hidden fields

  • Profile Image
    Asked on March 12, 2014 at 05:52 PM

    This form receives parameters into hidden fields via url parameters. I want to use the calculation widget to produce a line containing some text together with the contents of one of these fieldc and the product of two of the fields.The calculation widget wizard does not list any of these fields.

  • Profile Image
    Answered on March 12, 2014 at 07:25 PM

    I think I know what you are talking about where it doesn't pick up and have certain fields listed inside the calculation field for usage. This is because it has yet to be programmed that way for more advanced things like that so they don't show up.

    I believe it should work if it's been populated to a field on your form and then that field can then be carried over into the Form Calculation Widget depending on the field.

    For form "  " what form do you have set to populate it? Perhaps we can play around with it some more to try to come up with a possible solution to this maybe.

  • Profile Image
    Answered on March 12, 2014 at 09:41 PM

    It is being set from form 40503979576971.

    The thankyou url there is{doYou}&help={couldYou}&bake={couldYou121}&quiz={doYou57}&places={numberOf96}&price={price}&formid={formid}&subid={id} comes straight into form 40425935500347 where the parameters are put into hidden fields. The parameters of interest are places and price. I want to display (split into fields if necessary) "Number of places booked is {places} at {price} each. Total cost is £{places}*{price}" Where the items in {} are the contemts of those fields, and the final part is the product.

    This works fine in the original form 40503979576971. Pending the arrival today of the improved calculation widget, I was simply displaying a different block of text for each of the allowed values (1 to 8) for {places}. This assumed a fixed {price} of £12.50. I did this on both these forms. Today I have put the widget onto the original form to replace the 8 blocks of text by one calculated field including the necessary text. So I want to do this on form 404...347 as well, so I need the calculation widget to see these fields. Am I able to use ordinary text box fields to receive the parameters, and just hide them, or do the parameters need to go into "hidden widget" fields?

  • Profile Image
    Answered on March 13, 2014 at 02:31 AM

    Hello NRCsupport,

    If I understand your question correctly your scenario is like this:

    1. You have few hidden boxes widget  added in your form (NRC Support Group. Thank you form).

    2. You are populating these fields through URL parameters.

    3. You need to add a "Form Calculation" widget in your form to do certain calculations based on the value of hidden boxes. Is that correct?

    To achieve your requirement, you need to replace all the "Hidden Boxes" from this from and replace it with normal textboxes or number fields. You can just hide them through "Hide Field" property.

    "Form Calculation" widget is currently unable to list the hidden boxes in the list for calculation. Do get back to us if this is what you wanted to achieve and I can send a query to our back end team to find out if adding the hidden box in the calculation widget is feasible at the moment.

    I have created a demo form which you can take a look here:

    This form has one hidden box, one number field, one text box and the calculation widget. The Number field {number3} is hidden and the values are being passed through the URL parameter. In this scenario the calculation widget works as expected.

    We will wait for your response.

    Thank you!

  • Profile Image
    Answered on March 19, 2014 at 01:48 PM

    I can do what you suggest, and it seems to work. But what is the point of the hidden box field, when the same can be acheived more usefully by setting a normal field to hidden?

    Is there a reason why hidden box fields are not available in the calculation widget? It would be sensible to make them available for the sake of consistency.

  • Profile Image
    Answered on March 19, 2014 at 04:46 PM

    The original hidden box field is a "native" widget that it was inttended to provide things like incremental Unique ID'S  or to be used as an internal reference

    A text box can be set as hidden and can be included  in the calculations when for example, you wan have a field to do internal calculations , but there is no need for the user to see all the operations , just the total, that is when someone might want to hide the box

  • Profile Image
    Answered on March 19, 2014 at 05:10 PM


    This is one of several areas where what JotForm does is not very intuitive, and there is little documentation to explain the differences between similar things and when to use which of them.

  • Profile Image
    Answered on March 19, 2014 at 10:05 PM

    Thanks for pointing that out. Since the calculated forms and new method to hide ordinary textboxes are new features, we know we ought to add guides to explain these.  So please bear with us, we will be adding them ASAP