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

  • miguelazevedoperes
    Asked on March 14, 2015 at 7: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??

     

  • raul
    Replied on March 14, 2015 at 9: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.

  • miguelazevedoperes
    Replied on March 15, 2015 at 1: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?

     

  • Ben
    Replied on March 15, 2015 at 2: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/