User Input with Database Calculation

Ask the community
,
1

Pulling my hair out with this. Please help:

I have a page as such:

1088×741 144 KB

Basically, I want to take the User Input “adultselect” and multiply it with the database field “adultFrom” and then add User Input “childselect” multiplied with the database field “childFrom”. The Sum total would then be displayed in field “totalCost” which is blank in the database.

My current onClick code is:

export function searchButton_onClick(event) {
wixData.query(‘TopSanta’)
.contains(‘airport’, $w(‘#airportselect’).value)
.eq(“dayb”, “Y”)
.ascending(“airport”, “date”, “duration”)
.limit(100)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
$w(‘#table1’).show();
});
}

Can anybody help with the code to be added to make this happen?? Please. :frowning:

2

Then you must add that column into the table. You must then alter the res.items data array. You could loop through it and add / push the sum as a new column and then add that to another field. Do you know how to loop through arrays?