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

    Is there a way that we could apply bulk setup of conditions (setup for multiple fields in the same time)?

    Asked by miguelazevedoperes on March 14, 2015 at 07:55 PM

    1st -I have a list with:

    ID

    Name

    counting unit

    buying unit

    price

    number counted

    Estimated value

     

    I want to insert the ID and the form would autofill Name, counting unit, buying unit, price,

     

    2nd -then Insert the number counted and multiply by the autofilled price to fill the estimated value

    Is this possible for 100 id without creating an independent conditional filling for each information??

     

    bulk conditional autofill conditions
  • Profile Image

    Answered by raul on March 14, 2015 at 09:04 PM

    Unfortunately, if you want to use conditional logic you'll need to create a condition for each ID.

    You could, however, use the full source code of your form and populate the fields using a custom script that would seek the corresponding values based on the selected ID. On this scenario, you can populate a database that would have this information and then run queries in it to enter the values in each field.

    For the calculation part, I suggest you to check this guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Let us know if you have further questions.
    Thank you.

  • Profile Image

    Answered by miguelazevedoperes on March 15, 2015 at 01:14 AM

    Thanks very much for your answer Raul! Could you please give me some references where I could learn to do the script? What should I look for and if there are any other questions on the forum similar to mine?

     

  • Profile Image

    Answered by Ben on March 15, 2015 at 02:40 AM

    In my colleague's Raul name you are welcome.

    When it comes to reference I presume that w3schools would be the best option since they allow you to try it for yourself right after you pass each segment of the tutorial, but for something like what you are looking to achieve it might be best to hire a developer as well.

    This is the link to w3schools: w3 Schools JavaScript Tutorial

    You would need some looping structure, I would use for(), but there are other alternatives.

    Before you start, I would suggest taking a look if you can transfer your idea to math function, which would then be easy to transfer into js code.

    Now in regards to similar question on our forum - I am personally not familiar of similar request, but please do feel free to search our forum, by going here:

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