Hello, I am not a JS person so couldnt come up with the right formula for sorting values as numbers.
Default sorting in WeWeb is working alphabetically (i believe) so when sorting numeric columns, it still processes them as alphabetically, so 1,10,11,12,2,20,21,3 etc instead of 1,2,3,4… So default ASC or DESC selection in sorting is misleading.
Anyone suggest a formula to fix the sorting, I would appreciate. I am pulling values from Airtable and doing the sorting at the collection level. Here is the sorting formula, it is using 7 different columns to sort 96 companies.