Feeding a form with submission data from another form based on conditions.

  • EUROCITIES
    Asked on July 23, 2015 at 11:07 AM

    I have a multiple question actually and I'll try to make it as clear as possible.

    I'm creating an evaluation form for the jury members of a city project award. Each jury needs to mark each submission through 8 different criteria (some marks are weighted). I created the following form for this step of the process:

     

    http://form.jotformeu.com/form/51935314353352

     

    The first question is: i need each jury to fill in as many forms of this type as many awards submissions we get (eg. If we got 15 submissions, each jury will have to submit 15 of these evaluation forms), is there a way to guide the process without having to tell them: 'You have to fill in 15 forms'? As an additional information, the submission form is also a jotform form http://form.jotformeu.com/form/51804564496362 

     

    I then need to show each jury member a summary sheet with a ranked list of the 11 projects they have rated as the highest, basically I need an automated solution that would extract the city, name of the project and total score based on a rule like 'if total score of x is higher than total score of y, then put x higher in the list than y'. Sorry, I'm no expert. Does anyone have any suggestions on how to achieve this?

     

    Thank you,

    Wilma

  • David JotForm Support Manager
    Replied on July 23, 2015 at 1:22 PM

    This is an automated custom system you are looking for in order process and meet the requirements you need, JotForm philosophy is to keep things simple.

    I recommend you to hire a programmer in order to accomplish what you need. You can send your submissions to your own database, so he can create the necessary coding and queries to handle the information. 

    If the programmer needs to download the full source code of your form, here is how: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    Source code in embed form wizard Screenshot 10

    If you have another question, please open a new thread, we will be glad to assist you.