how to create a new calculated field in my dataset

Ask the community
,
1

I have this dataset and I want to create the calculated fields OV = ov001 + ov002 + ov003 + ov004 + ov005
ins = ins001 + ins002 + ins003 + ins004
in my dataset
example:

2

Hello Lucila Liendo,

looks like Excel, not like Wix :roll_eyes:

Here a link to a post, could be helpful…
https://www.wix.com/corvid/forum/community-discussion/trying-to-sum-db-values-with-a-loop

3

And here a code-example, how it could perhaps work…

$w.onReady( () => {
  $w("#dataset1").onReady( () => {
    $w("#dataset1").getItems(0, 1)
        .then( (result) => {
 let items = result.items;
 let totalCount = result.totalCount;

 //------------------------------------------
            console.log((totalCount))
            console.log(items)
 //------------------------------------------
            console.log(items[0].ov001)
            console.log(items[0].ov002)
            console.log(items[0].ov003)
        } );
    } );
} );

Look in CONSOLE (Press F-12 in google-Browser)

$w.onReady( () => {
  $w("#dataset1").onReady( () => {
    $w("#dataset1").getItems(1, 1)
        .then( (result) => {
 let items = result.items;
 let totalCount = result.totalCount;
 

 //------------------------------------------
            console.log((totalCount))
            console.log(items)
 //------------------------------------------
            console.log(items[1].ov001)
            console.log(items[1].ov002)
            console.log(items[1].ov003)
 
        } );
    } );
} );

Look again…

$w.onReady( () => {
  $w("#dataset1").onReady( () => {
    $w("#dataset1").getItems(2, 1)
        .then( (result) => {
 let items = result.items;
 let totalCount = result.totalCount;
 

 //------------------------------------------
            console.log((totalCount))
            console.log(items)
 //------------------------------------------
            console.log(items[2].ov001)
            console.log(items[2].ov002)
            console.log(items[2].ov003)
 
        } );
    } );
} );

…and again.

What happened in CONSOLE ???