help js

[darekmer]

sorry no english
please help :

or sql, how to calculate this box

subform 'todczytpradu_subform'
Kon 'stan_koncowy'
Pocz 'stan_poczatkowy'
Cena 'cena'
KwZap 'kwota_zaplaty'
equation math (Kon - Pocz) * Cena update KwZap

[admin]

darekmer,

Try this..

Code: Select all

function calc_row(pThis){

   var p = $('#' + pThis.id).attr('data-prefix');
   var a = $('#' + p + 'Kon').val();
   var b = $('#' + p + 'Pocz').val();
   var c = $('#' + p + 'Cena').val();
   var x = (a - b) * c;

   $('#' + p + 'Cena').val(x);

}

For Kon, Pocz and Cena..

daremer.PNG

darekmer,


Steven

[darekmer]

Welcome
I do not know English, google translator
not working or do not understand.
I wanted the result of this action appeared in the KwZap.
and nothing appears.

I would add that all four fields are in one table

[admin]

darekmer,

Are you wanting this update to be done as Kon, Pocz and Cena are edited on the Form or as the Form is saved (with SQL)?

Steven

[darekmer]

hello;)
Loading Data to the field 'Konc'.
The 'Pocz' is in the Default Value 'SELECT stan_koncowy FROM todczytpradu WHERE id_dzialki = '#RECORD_ID#'ORDER BY id_odczytu DESC
LIMIT 1 '.
field 'Cena' gets data from another table.
I want to field 'KwZap' automatically counted and saved in the table.

[admin]

darekmer,

Just run

Code: Select all

UPDATE SubformTableName SET  kwZap = (Kon - Pocz) * Cena

On Form After Save.

Steven