- miguelazevedoperesAsked on March 14, 2015 at 07:55 PM
1st -I have a list with:
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??
- raulAnswered 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.
- miguelazevedoperesAnswered 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?
- BenAnswered 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.
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: