- naguibihelekAsked 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.Page URL:
- JotForm SupportKevin_GAnswered on December 31, 2015 at 07:00 PM
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.
- naguibihelekAnswered on January 02, 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.
- JotForm SupportWelvinAnswered on January 02, 2016 at 05: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.
- naguibihelekAnswered on January 02, 2016 at 06:20 PM