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

    Making new condition by Inserting Text Or Mathematical Calculation into a field

    Asked by daveprenter on March 30, 2014 at 08:01 AM

    Hi there,

     

    I have had ongoing problems with this form.  Admittedly , it is the first form I have done, and it is a fairly complicated one so that is to be expected.I am sorry to cause you more trouble.

    Anway, part of my form involves specifying the value of a field by by Inserting Text Or Mathematical Calculation into field under certain conditions (ie when it is a 3 night package then the number of nights is 3, and when it is a 4 night package then the number of nights will be 4). The number of nights is then used to calculate a total price depending on the accommodation they have chosen.   I have it working well for the 4 night package, but in the 3 night package it doesn't want to set the number of nights - it leaves it blank. 

     

    I have tried many methods but always come to the same problem.  I hope you can help me.

    Page URL:
    https://www.jotform.com//?formID=40843625273859

    problem total price 3 same
  • Profile Image

    Answered by Cesar on March 30, 2014 at 02:58 PM

    This appears to be a priority issue with the conditional rules. I have cloned your form and by putting the rules above the 4 nights rules. Now the 3 nights rule works, but the 4 nights rule does not. I have verified that two match conditions are not able to be applied on the same field. In the meantime, you could bypass the problem by adding different fields to output the data, this could be done by hiding the fields and only showing them when neccesary.

    I will go ahead an raise a ticket to the development temp for further review. Once there is anyu update from their end, they will let us know through this thread. Thank you.

  • Profile Image

    Answered by daveprenter on March 30, 2014 at 06:30 PM
    Ok got that, thanks very much Cesar,
    Dave
    --------------------------------------------
    ...
  • Profile Image

    Answered by daveprenter on April 04, 2014 at 06:50 PM
    Hi Cesar,
    No news on this yet? I have found a way around it , but it means having something like 70 calculation forms which is impractical.
    Kind Regards,
    Dave
    --------------------------------------------
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 04, 2014 at 07:44 PM

    Hi Dave,

    Sorry but there is no updates about this as of the moment. This is pretty complex for the mathematical conditions specifically the part where it requires multiple if & else statement. This makes it very complicated to implement on the calculation wizard. Are you satisfied with source code embedding? Maybe we can come up a custom script that is specific to your form to achieve the function you want. Can you please specify again which part of the calculation that is not working with your form http://www.jotform.com/form/40843625273859? Sorry but I'm having a little difficulties catching up your first explanation. I would appreciate if you could provide more details.

    Thank you so much.

  • Profile Image

    Answered by daveprenter on April 04, 2014 at 11:30 PM
    Ok Elton,
    Thank you very much for your email. Maybe a custom script is the way to go. So what I want to do is have offer a number of different packages, ranging from 3 night up to 14 night package. Each of these packages will include a set number of nights and a set number of lift passes per adult. So the price is basically A + B where A is the cost of the accommodation for those ngihts and B is the cost of the lift passes. So what I was trying to do using the wizard was to set a condition depending on the package type (3 night, 4 night , 5 night etc).
    For example
    If the package is equal to a 3 night package, then a)the number of nights in the accommodation will be 3 and b) the number of lift passes will be 2 per person. We have found that using the wizard we cannot easily set these conditions.The wizard does not seem to like it if there is more than 1 " Insert Text Or Mathematical Calculation into field" condition in the same calculation.
    I have tried other means but the problem is that the customer can choose a number of different accommodations and each accommodation has a number of room types, all which are priced differently. When the customer plays around with the form changing the accommodations and room types the price doesn't update properly.
    So yes if you could do me a custom scrip that would be great.We have another website https://skipackagesjapan.com/ski-packages-bookingform.html
    which includes such scripts. However, I am building a new website (different domain) and want to avoid using programmers as much as possible. That is why jot form appeals to me. Anyway you can have a look at that page to see how I would like it to work. I guess you don't need to worry about the "Design own custom package" option as I can do that using the wizard.
    Ideally a script that allows us to specify 1) the number of nights based on the package chosen and 2) the number of lift passes included per person based on the package chosen. If you can only insert one condition then the "number of nights" one is the one I would like you to make a script for.
    So our present jotform url is https://www.jotform.com//?formID=40843625273859 You will see there are a number of form calculation fields there as I have been playing around with it trying to get it to work.
    Hope I haven't rambled on too long. If you are not clear on anything let me know.
    Kind Regards,
    Dave Prenter
    --------------------------------------------
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on April 05, 2014 at 09:06 AM

    @Dave

    Hi,

    We appreciate your effort in putting much details on your requirement.

    However, the original topic for this thread was actually not about the latest details you provided.

    The original topic of this thread have a submitted bug ticket to our higher support.

    We could not continue responding on your latest inquiry/message on the source code on this thread because the topic of this thread is not about it.

    I suggest you just create a separate new topic on this request about using the source code. Please use this link http://www.jotform.com/contact/

    You can just copy your message from this thread and paste it on the new post you will be creating.

    Make sure to put the appropriate title/subject on the new post. And also you can arrange the paragraph a bit so that it will be easier to understand

    (I am sorry but right know, it looks like a massive wall of text, and quite difficult to breakdown..)

    Our colleague EltonCris will be notified also of your response here, and can respond on the new thread you will be creating.

    Thanks.

     

  • Profile Image

    Answered by daveprenter on April 07, 2014 at 07:00 PM
    Yes, thank you Nicholas. That has fixed it. I can now go full steam ahead and finish the form.
    Thank you very much for all your help.
    Kind Regards,
    Dave
    --------------------------------------------
    ...
  • Profile Image

    Answered by Cesar on April 07, 2014 at 11:19 PM

    Thank you for your input Dave, do let us know if you need further assistance. Thank you again.