sum fields dataset

Ask the community
,
1

Good guys
I have a database with the following columns:
Q1, Q2, Q3

I am creating a form where these fields are numbers in a String text field …

I would like to add the result of these fields and if possible put them in a column of the database called: ‘’ Total ‘’

2

Hello Yair,

you do not give enought input, to help you.
What is the detailed flow of your project ?

You have 3 reference-fields (Q1, Q2, Q3) ok.
You have a form ok.

Do you wanna WRITE oder READ DATA ?

First READ-OUT Q1 + Q2 + Q3, then SUM them and then push them into another database?

Or…

…do you have 3 inputfields, where you make your entries clicks a button and then all 4 entries should be done in 2 databases ?

Please always be more precise! The better you describe your situation, the better someone can help you.

3

Hi everyone,

I have quite similar case.
I have multiple datasets where member connect to each dataset at some point. I want to sumTotal fields, which are multi reference fields from another datasets. Final result should be displayed in a text item. Any help would be appreciated.

2822×220 40.9 KB

@ahmadnasriya

4

I’ve already answered this question.

5

Hi,
thank i saw that. unfortunately it does not sum up values, displays them as a text only. Could you check it on previous discussio where you placed code.
:pray::pray: @ahmadnasriya

6

@juozmant Can you please tag me there again, I couldn’t find the post.

7

Hey @ahmadnasriya ,
can you help me Here

I am stuck for Summing value in repeaters.

Thanks in advance.

Rifai

8

Hi there,

Sure, you need to run a forEachItem( ) loop on the repeater to sum the values, for example, if you have a repeater that shows the price of products, and you want to show the total, you can do it like this:

let total = 0; // A variable to store the total.

// Loop through the items to get the price of each one and sum it up.
$w('#repeater').forEachItem(($product, productData) => {
    total += productData.price;
})

console.info(total); // Print the total to the console.
$w('#total').text = String(total); // Show the total in a text element on the screen

If you have an input field on each repeated item that you want to enter a value for each item, and sum them all up, you can use the selector of the repeater scoop.

let total = 0; // A variable to store the total.

// Loop through the items to get the entered number
$w('#repeater').forEachItem(($item) => {
    total += $item('#input').value;
})

console.info(total); // Print the total to the console.
$w('#total').text = String(total); // Show the total in a text element on the screen

Hope this helps~!
Ahmad

9

Hi,
Thanks, it helps a lot! I get it now how to get each value.
But there’s one more problem, the result was not summing the value instead combining it, here’s the result

1674×539 28.2 KB

and here’s my code:

$w('#basicRepeater').forEachItem(($item, data) => {
 let total = 0;
 let basictotal = (Math.round($item('#basicS').value + $item('#basicM').value + $item('#basicL').value + $item('#basicXL').value));
    total += basictotal;

    console.info(total);

I think there was a problem with my code.

Thanks,
Rifai

10

@ajib18j The input field type should be “Number”, otherwise, you need to convert the text value of the input field into a number, here’s how:

// 1: Store the text value in a variable
const stringValue = $w('#input').value;

// 2: Convert the text value into a numeric value
const numericValue = Number(stringValue);

// Or convert it immediately
const numericValue = Number($w('#input').value);

So, the code was combining them because it treats them as strings, not as numbers, now that they’re numbers, it’ll sum them instead of combining them.

Hope this helps~!

11

@ahmadnasriya Thank you so much, it works perfectly!
but I am facing another problem. I want to save the result to my collection table. but it seems my code is not working

total += basictotal;
    console.info(total);let basicTotal = {"sum":total };
         wixData.update('stok-basic', basicTotal).then( (results) => {let item = results; //see item below} ).catch( (err) => {let errorMsg = err;} );

is there any problem with my code?

Thanks in advance,
Rifai

12

@ajib18j Yes, you’re increasing the value of the variable before declaring it, the declaration must be before the use of any instance.

Try this instead:

// total: is a variable declared to store the sum value;

// Now before you update an entry, you need to get it first by performing a query.
return wixData.query('stok-basic').eq('fieldId', fieldValue).find().then((x) => {
    let item = x.items[0]; // The item that we need to update it.
    
    // Updating the item "total" field with the total value;
    item.total = total;
    
    // Attempt the update ...
    return wixData.update('stok-basic', item);
})

Hope this helps~!
Ahamd