How to calculate a top 3 using input table?

  • MusicNB
    Asked on April 2, 2019 at 10:02 AM

    I am trying to create a voting page, where users can select their top 3 albums. It is required that they select one #1, one #2, and one #3. Some rows will be empty, and that's fine.

    Jotform Thread 1779466 Screenshot
  • Richie JotForm Support
    Replied on April 2, 2019 at 12:37 PM

    You may assign calculation values in your Input table.

    Go to Input Table Properties>Options>Calculation Values

    How to calculate a top 3 using input table? Image 1 Screenshot 30

    Then you can use the Form calculation widget to get the value.

    How to calculate a top 3 using input table? Image 2 Screenshot 41

    Guide:https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Here is my sample Form:https://form.jotform.com/90914665643969

    Please give it a try and let us know if this fits your requirement.

  • MusicNB
    Replied on April 2, 2019 at 12:57 PM

    I need to make sure that users can't pick more than one #1, one #2, etc. Using that form, I was able to submit the form, picking all rows as #1, which won't work for my needs. I need to limit it to one choice per column.

     

    For exemple, the user would vote for one artist as their #1 pick, another artist as their number #2 pick, and another as their #3 pick.

     

    There can't be more than one choice, in both a column and a row.

     

  • Richie JotForm Support
    Replied on April 2, 2019 at 2:24 PM

    Unfortunately, this is not possible with the widget.

    The widget would let you select the available selection in each row.

    How to calculate a top 3 using input table? Image 1 Screenshot 30

    I have checked other widgets and options but it seems they are not fit with your requirements.

    I would suggest, exchanging the question to the column field and the answer in the row.

    Sample:

    How to calculate a top 3 using input table? Image 2 Screenshot 41

    Hope this information helps.

    If you have further questions, let us know.