Orderable List : Numerical order instead of ordered items in orderable list

  • naguibihelek
    Asked on December 31, 2015 at 3:34 PM

    I am using orderable list for a few forms, and love it. The only challenge I have is that in order to use the results in an automated spreadsheet, where I need to plug the results into, I need the numerical position rather than the reordered text. For instance, I created a test form to demonstrate this. It has 5 entries - One, Two, Three, Four, Five as items in the list. If the user reorders the list currently I get the result back as, 1: Two, 2: Four, 3: Five, 4: One, 5: Three.  I need the result to be 24513 which tells me that they moved the second item Two to now be first, the fourth item Four to second position, and so on. Right now there is no way for me to know where an item was moved to in a numerical way.

  • Kevin Support Team Lead
    Replied on December 31, 2015 at 7:00 PM

    Hi,

    I tried to do it and as you said there is no option to know the previous order.

    However, I found a workaround to accomplish it, you can add the number between HTML tags with a Class attribute, and then add Custom CSS in the Widget in order to hide the numbers and only show them in the submission.

    For example, change the current options with these, code with green background is the HTML tag with the number and the class attribute on it : 

    <span class="order">1.</span>One

    <span class="order">2.</span>Two

    <span class="order">3.</span>Three

    <span class="order">4.</span>Four

    <span class="order">5.</span>Five

    Orderable List : Numerical order instead of ordered items in orderable list Image 1 Screenshot 50

    This is the CSS code you need to use in order to hide the order numbers : 

    .order{

    display:none;

    }

    Orderable List : Numerical order instead of ordered items in orderable list Image 2 Screenshot 61

    As you see on my sample form, the order numbers are not there :

    Orderable List : Numerical order instead of ordered items in orderable list Image 3 Screenshot 72

    But, the order numbers come back on the submissions view, showing the original order before to be changed : 

    Orderable List : Numerical order instead of ordered items in orderable list Image 4 Screenshot 83

    You can see my sample form here : https://form.jotform.com/53647039975974

    Hope this will accomplish  what you want.

    Thanks.

  • naguibihelek
    Replied on January 2, 2016 at 10:29 AM

    Thanks. I tried something similar by just adding the number at the end of each line. Unfortunately the result is not that elegant. It's hard to see on your example because they are just in reverse order. If you have them randomly organized it easier to see the problem. The item Five shows up as 1st item, where as I need to know that One ended up as 5th. In my example, I made the same mistake. I that original message example I should have 41523 as the correct result. Because One is now in spot number 4, Two is in spot number 1, and so on. Instead of 24513 which would result from your example, and this is incorrect.

  • Welvin Support Team Lead
    Replied on January 2, 2016 at 5:25 PM

    I have forwarded this to our widget team as a feature request. We can't promise any timeframe for this, but if there are updates, you should know it through this thread.

  • naguibihelek
    Replied on January 2, 2016 at 6:20 PM

    Thanks.