How to calculate a top 3 using input table?

  • Profile Image
    Asked on April 02, 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.

  • Profile Image
    Answered on April 02, 2019 at 12:37 PM

    You may assign calculation values in your Input table.

    Go to Input Table Properties>Options>Calculation Values

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


    Here is my sample Form:

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

  • Profile Image
    Answered on April 02, 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.


  • Profile Image
    Answered on April 02, 2019 at 02:24 PM

    Unfortunately, this is not possible with the widget.

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

    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.


    Hope this information helps.

    If you have further questions, let us know.