# Save a calculated field

**URL:** <https://forum.wixstudio.com/t/save-a-calculated-field/26467>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [November 22, 2020, 4:37pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467 "2020-11-22T16:37:14Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 4:37pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/1 "2020-11-22T16:37:14Z")

</div>

I have a calculated field and I need to save it into a database.  
The calculated field is working fine but the save button doesnt

The code:

//CALCULATED FIELD  
export function calcularIMC\_click\_1(event, $w) {  
**let** Talla = Number($w( “#talla” ).value);  
**let** Peso = Number($w( “#peso” ).value);  
$w( “#imc” ).value = (Peso/(Talla\*Talla)).toString();  
}

//SAVE BUTTON  
export function salvar\_click(event){  
$w( “#dataset1” ).setFieldValue( “mdImc” , $w( “#imc” ).value);  
}

It doesnt work. Can you help me?

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 7:52pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/2 "2020-11-22T19:52:21Z")

</div>

Try this one…

```javascript
exportfunction salvar_click(event){ 
    console.log("Start-Saving-Process")
    $w("#dataset1").setFieldValue("mdImc", $w("#imc").value); 
    $w("#dataset1").save();
}

```

Check also, if you get “Start-Saving-Process”-output in CONSOLE?

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 8:16pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/3 "2020-11-22T20:16:11Z")

</div>

Thanks Dima!

Yes. In the console I get Start-Saving-Process! But still not saving the value field in the database

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 8:26pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/4 "2020-11-22T20:26:06Z")

</div>

Your BUTTON seems to work, check other things like…  
-Check —\> DATABASE-PERMISSIONS ! (set to all permissions to test it)  
-Check —\> DATASET —\> READ & WRITE ? (set your dataset to read & write)  
-does it work in Preview-Mode?  
-put the first item —\> MANUALLY into your DATABASE (test it again)

If still not work, show the first lines of your databse & your current used code.

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 8:30pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/5 "2020-11-22T20:30:35Z")

</div>

Now it saves it but always with the number “0” 😥

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 8:34pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/6 "2020-11-22T20:34:49Z")

</div>

What are the results of your calculations?

```javascript
exportfunction calcularIMC_click_1(event, $w) {
    let Talla = Number($w("#talla").value);
    console.log(Talla)
    let Peso = Number($w("#peso").value);  
    console.log(Peso)
    $w("#imc").value = (Peso/(Talla*Talla)).toString()
;}

```

> Now it saves it but always with the number “0” 😥  
> This is not enough INPUT !

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 8:37pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/7 "2020-11-22T20:37:09Z")

</div>

It calculates your weight/height to see if you are in obesity risk. So the results are for example 16.2 or 20.4

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 8:42pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/8 "2020-11-22T20:42:43Z")

</div>

Check how your DATABASE-FIELDS are configured —\> STRING ? NUMBER ? Something else? How are configured your INPUT-FIELDS ?

Convert Number into String or String into Number.

Something like this…  
12.toString()  
Number(“12”)

Still not working?  
Then create a TEST-BUTTON with a TEST-INPUTFIELD.  
Write a simple CODE —\> When press on BUTTON —\> SAVE to DATABASE.  
If this work, then continue to search for your error from this point.

Do everything step by step.

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 8:50pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/9 "2020-11-22T20:50:10Z")

</div>

The field in de database is a Number Field  
The field in the form is a Number field with decimals.

export function bttImc\_click(event, $w) {  
**let** Talla = Number($w( “#talla” ).value);  
**let** Peso = Number($w( “#peso” ).value);  
$w( “#imc” ).value = (Peso/(Talla\*Talla)).toString();

}

export function salvar\_click(event){

```
console.log( "Start-Saving-Process" ) 
$w( "#dataset1" ).setFieldValue( "mdImc" , $w( "#imc" ).value);  
$w( "#dataset1" ).save(); 

```

}

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 9:12pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/10 "2020-11-22T21:12:53Z")

</div>

```javascript
$w.onReady( () => {
  $w("#dataset1").onReady( () => {
     $w('#bttImc').onClick(()=>{
        let Talla = Number($w("#talla").value);
        let Peso = Number($w("#peso").value);
        console.log(Talla)
        console.log(typeof Talla)
        console.log(Peso)
        console.log(typeof Peso)
        console.log($w("#imc").value)
        console.log(typeof $w("#imc").value)
        $w("#imc").value = (Peso/(Talla*Talla)).toString();
     })
     
     $w('#salvar').onClick(()=>{
        console.log("Start-Saving-Process")
        console.log($w("#imc").value)
        console.log(typeof $w("#imc").value)
        $w("#dataset1").setFieldValue("mdImc", $w("#imc").value); 
        $w("#dataset1").save();
     });
   });
});

```

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 22, 2020, 9:21pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/11 "2020-11-22T21:21:21Z")

</div>

These are the results

0  
number

0  
number

string

Start-Saving-Process

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 22, 2020, 9:27pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/12 "2020-11-22T21:27:58Z")

</div>

Do a little simple test…

```javascript
$w.onReady( () => {
  var RESULT
  $w("#dataset1").onReady( () => {
     $w('#bttImc').onClick(()=>{
        let Talla = 2;
        let Peso = 3;
        console.log(Talla)
        console.log(typeof Talla)
        console.log(Peso)
        console.log(typeof Peso)
        console.log($w("#imc").value)
        console.log(typeof $w("#imc").value)
        RESULT = (Peso+Talla); //should be ---> 5 (Number)
        console.log(typeof RESULT)
     })
     
     $w('#salvar').onClick(()=>{
        console.log("Start-Saving-Process")
        console.log($w("#imc").value)
        console.log(typeof $w("#imc").value)
        $w("#dataset1").setFieldValue("mdImc", RESULT); 
        $w("#dataset1").save();
     });
   });
});

```

Does it work ?

Update:

```javascript
$w('#salvar').onClick(async()=>{
    console.log("Start-Saving-Process")
    console.log($w("#imc").value)
    console.log(typeof $w("#imc").value)
    await $w("#dataset1").setFieldValue("mdImc", RESULT); 
    $w("#dataset1").save();
});

```

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 23, 2020, 12:12am UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/13 "2020-11-23T00:12:26Z")

</div>

YES! That way it saves “5” into the database!

This it what the console log shows:

1  
number

2  
number

string  
number

Start-Saving-Process

string

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 23, 2020, 4:20pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/14 "2020-11-23T16:20:10Z")

</div>

@russian-dima Hi Dima!

YES! That way it saves “5” into the database!

This it what the console log shows:

1 number 2 number string number  
Start-Saving-Process string

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 23, 2020, 4:37pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/15 "2020-11-23T16:37:39Z")

</div>

@danieltalero78

I hoped you would get your solution on your own. 😁  
As you can see, there must be a problem with the right type of your variable.

Just do some BRAINSTORMING. Look what is different between your problematic situation and my little and very simple example, which worked for you.

Use more CONSOLE-LOGs, so you will be able to see more of the programmed process.

And do not forget, you can not calculate the mixed way with **STRING** s and **NUMBER** s. Try always to convert to **NUMBER** s first, before you do some **CALCULATING**. Then after **CALCULATING** , you can **convert** your **RESULT back** in what ever you want, for example back to **STRING**.

---

<div class="post-metadata">

**Author:** ![danieltalero78](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/danieltalero78/32/22650_2.png) [@danieltalero78](https://forum.wixstudio.com/u/danieltalero78)\
**Post date:** [November 23, 2020, 10:11pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/16 "2020-11-23T22:11:32Z")

</div>

@russian-dima Thanks for your help

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [November 23, 2020, 11:58pm UTC](https://forum.wixstudio.com/t/save-a-calculated-field/26467/17 "2020-11-23T23:58:11Z")

</div>

@danieltalero78  
Give a feedback, if you could solve it by your own, or not.😉
