JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Orderable List : Numerical order instead of ordered items in orderable listAsked by naguibihelek on December 31, 2015 at 03: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.
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 :
This is the CSS code you need to use in order to hide the order numbers :
As you see on my sample form, the order numbers are not there :
But, the order numbers come back on the submissions view, showing the original order before to be changed :
You can see my sample form here : https://form.jotform.com/53647039975974
Hope this will accomplish what you want.
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.
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.