Not really. Forms only store text, they don't allow any type of number field (at DB level).
You'll have to copy the FormAutoListing, and hack away at it, or maybe use anothermodule to list the data (or write your own)...
You can also check if the tl_form_fields table contains the rgxp="digit" string, as that will flag that field as numeric, so you can do a CAST or convertion of the data into a numeric value.
Code:
SELECT textfield1, textfield2, CAST(numfield1 AS UNSIGNED) FROM form_events ORDER BY CAST(numfield1 AS UNSIGNED) DESC
Remember there is no space between the CAST and the ( bracket, otherwise it will generate an error.
Bookmarks