How to move answers from an orderable form of 20 items to an excel sheet to rank the items?

  • Profile Image
    Louise_louiseg
    Asked on February 14, 2021 at 02:52 PM

    I used the Orderable widget to create a list of book suggestions for our bookgroup. I am trying to create an excel sheet with the rankings, however each respondent becomes a cell with their entire list. I do not see a column with just the ranking of the book titles. I had twenty books listed and over 20 responded to the form. The first column shows a data dump into each row by respondent. Do I have to cut and paste from each respondent. There must be an easier way. That seems like a lot of work to get my answer.

    I would appreciate any suggestions. Thank you.


    Screenshot
  • Profile Image
    Vick_W
    Answered on February 14, 2021 at 09:21 PM

    Hi there,

    The data collected through the widget will remain in a single row for each submission. Could you please elaborate on your requirement so we can assist you accordingly?

    Thanks

  • Profile Image
    Louise_louiseg
    Answered on February 14, 2021 at 10:55 PM
    The purpose was to create a clean ranked list of 20 books. I don’t want twenty separate lists. I now need to show the twenty books in one list, based on the favorite to the least.
    Regards,
    Louise
    ...
  • Profile Image
    Vick_W
    Answered on February 15, 2021 at 12:42 AM

    Hi Louise,

    Unfortunately, the order list widget does not have the function or feature that you had in mind. The data collected through the widget will remain in one column. You'll have to manually extract it and create a list in excel.

    Using a multiple-choice field instead would have been the better option in this case. The visual report builder must have fulfilled your requirement by showing the number of times each book was selected.

    Please check out the guides below to see how you can still use the data and create a list in excel using the available data.

    https://support.microsoft.com/en-us/office/count-how-often-a-value-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd

    https://www.techwalla.com/articles/how-to-count-the-number-of-times-a-word-appears-in-excel

    Let us know if you have any other questions.

    Thanks