Is it possible to apply a custom sort to a smart-drop down in a Confiforms Field Definition Macro?

[Benjamin Rios]

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!

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

It sorts by label, and that is a text value

If all your values are numeric (for example it uses the Numeric field type to keep them) then ConfiForms attempts to sort them as numbers, but if it fails then it will fallback to sorting them as texts

Here is my demo/test proving that:

https://recordit.co/gKW5Xf33va

Alex