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

  • Profile Image
    miguelazevedoperes
    Asked 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??

     

  • Profile Image
    raul
    Answered 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
    miguelazevedoperes
    Answered 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
    Ben
    Answered 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/