This is my current code for a wix table. It does put numbers in descending order based on the form however it is seperating two digit and three digit numbers in the table. How can I combine them so its one list of descending numbers
import wixData from ‘wix-data’;
$w.onReady(function () {
loadSubmissions();
$w(‘#button10’).onClick(submitForm);
});
async function loadSubmissions() {
const submissions = await wixData.query(‘contactForm13’)
.limit(1000) // Adjust the limit if needed
.descending(‘#input1’) // Sort by #input1 field in descending order
.find();
const sortedSubmissions = submissions.items.sort((a, b) => {
const numberA = extractNumber(a['#input1']);
const numberB = extractNumber(b['#input1']);
return numberB - numberA;
});
$w('#table2').data = sortedSubmissions;
}
function extractNumber(input) {
const numericalValue = parseInt(input, 10);
return isNaN(numericalValue) ? 0 : numericalValue;
}
function submitForm() {
$w(‘#form1’).submit()
.then(() => {
loadSubmissions();
});
}