Hello everyone,
I have a Confiform Field Definition macro which has a field type of "Smart Dropdown."
The issue I am having is that the data base that the smart dropdown is referencing houses a list with numbers between 1-100.
When I try to sort using "Sort ASC" within the "Sorting" option of the Confiform Field Definition Macro the dropdown options look something like the following:
1
10
100
11
12
.
.
.
19
2
20
21
22
.
.
.
Rather than sorting from 1-100 in order it seems like it only sorts by the first digit, then ascends by the second digit and on...
Is there any way I can sort this so it goes in ascending fashion from 1 to 100?
Any help/examples would be appreciated.
Thank you!
