calculated function

Firekenny

New member
Hi,
I have created a basic calculated function to multiply 2 values from fields from the same table1 (total price = unit price * qty)
When creating an entry through the form, the total price field automatically updates the value based on the function.
However, when using a separate table2 and form to update the "qty" field (through a hooks function), the qty in table1 is correctly updating itself but the total price does not update itself by applying the above function.

Anything I am doing wrong?

Thanks.

______________________________________________
You are using DaDaBIK version 9.4-Monterosso enterprise, installed on 10-04-2019 (installation code: 149385d97a1a893918), the latest version of DaDaBIK is 9.4-Monterosso released on 07-23-2019

You are runnning the last release of DaDaBIK

PHP Version: 7.2.19

mysql version: 5.6.43-log

Web server: Apache

Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36
 

eugenio

Administrator
Staff member
Hello,
the function related to a calculated field is only executed during the insertion/edit of a record through the form.

Best,
 

jscott

New member
This sounds like a situation where the calculated field is best populated using hooks. You could set your calculated field instead to a text field, then use an [after][insert] hook to define it initially, and an [update][after] hook called bu the separate table (table2) to update it.
 
Top