SQLite PHP Generator online Help
Prev | Return to chapter overview | Next |
OnCalculateControlValues
![](/i/tour-under-title.gif)
This event occurs whenever the values of calculated columns are (re)computed in Edit and Insert forms. Live examples.
Signature:
function OnCalculateControlValues(editors)
Parameters:
editors |
An associative array of form controls. To access the value of the editor of the column_name column, use the editors['column_name'] syntax. |
Example 1:
This code snippet sets the value of the control displaying the full name according to values entered in the controls displaying first and last names.
editors['full_name'].setValue(editors['first_name'].getValue() + ' ' +
editors['last_name'].getValue());
Example 2:
This code snippet sets the value of the control displaying the age according to the entered birthday. To simplify the code, the Moment.js library is used.
if (editors['birthday'].getValue()) {
require(['moment'], function(moment) {
editors['age'].setValue(
moment().diff(editors['birthday'].getValue(), 'years')
);
});
}
See also:
Prev | Return to chapter overview | Next |