How to make the data computed by the wix code write to the Database ?

Ask the community
,
1

I wrote such a thing:

export function button1_click(event)
{
let a = Number($w( “#input42” ).value);
let b = Number($w( “#input48” ).value);
let c = Number($w( “#input45” ).value);
let d = Number($w( “#input46” ).value);

 $w( "#input47" ).value =((a*b/ 100 )+a).toString(); 
 $w( "#input43" ).value =(((a*b/100)+a)*c/ 100 ).toString(); 
 $w( "#input44" ).value =(((a*b/100)+a)+(((a*b/ 100 )+a)*c/ 100 )).toString(); 

 $w( "#input39" ).value =(d*((a*b/ 100 )+a)).toString(); 
 $w( "#input40" ).value =((((a*b/100)+a)*c/ 100 )*d).toString(); 
 $w( "#input41" ).value =((((a*b/100)+a)+(((a*b/ 100 )+a)*c/ 100 ))*d).toString();

}

Of course, after pressing the button, the results are correct.

977×580 8.78 KB

979×578 10.4 KB

The problem is that later when I want to save the results to the Database, I get empty records and I have no idea why.
Has anyone had contact with something like this and knows how to solve it?

2

How do you perform the save? Using code?

3

I’m not using a code

4

Familiar with this problem, it’s basically just displayed but the field does not really contain the value.
Or you will save using a code.
https://www.wix.com/corvid/reference/wix-data.html#update

Or you will update the database already in the calculation.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFieldValues

5

I have no idea how to make the display result the value of this input.