Calculated Columns.Example - 1

Appearance

View mode
Number of cards in a row Here you can select the number of cards to be placed in a row for each of supported screen resolutions. Your current resolution is highlighted in this way.
	Large desktop
	Desktop
	Tablet
	Phone

This example demonstrates how to add calculated columns to a page. Such columns do not exist in the data source the page is based on and their values are automatically computed using other column values or another deterministic expression.

The server-side OnCalculateFields and the client-side OnCalculateControlValues events allow you to provide PHP and JavaScript code respectively for calculating values of these columns.

This page contains two calculated columns: Full Name and Age. Click the button to learn how the values of these columns are computed.

// server-side event

        protected function doCalculateFields($rowData, $fieldName, &$value)
        {
            if ($fieldName == 'full_name') {
                $value = $rowData['first_name'] . ' ' . $rowData['last_name'];
            } elseif ($fieldName == 'age') {
                $dateOfBirth = new DateTime($rowData['birthday']);
                $dateInterval = $dateOfBirth->diff(new DateTime());
                $value = $dateInterval->format('%y');
            }
        }

// client-side event

// OnCalculateControlValues event body
 editors['full_name'].setValue(editors['first_name'].getValue() + ' ' + editors['last_name'].getValue());
            if (editors['birthday'].getValue()) {
                require(['moment'], function(moment) {
                    editors['age'].setValue(moment().diff(editors['birthday'].getValue(), 'years'));
                });
            }

Actions	First Name	Last Name	Full Name	Birthday	Age
	Patrick	Smith	Patrick Smith	1997-05-01	26
	Timo	Wittman	Timo Wittman	1986-10-12	36
	Linda	Madson	Linda Madson	1960-10-04	62
	Ben	Jones	Ben Jones	1999-12-24	23
	Anne	Brown	Anne Brown	1980-08-01	42
	Paul	Davis	Paul Davis	1977-02-23	46
	Maria	Kerber	Maria Kerber	1971-04-08	52
	Rebecca	Taylor	Rebecca Taylor	1991-08-15	31
	Terry	Moore	Terry Moore	1986-02-20	37
	James	Goodridge	James Goodridge	1952-09-02	70
There are no records to display

	Column	Order

Legend
New	Recently added or significantly updated pages.
Pro	Pages illustrating features available only in the Professional edition of PHP Generator.

Created with PHP Generator for MySQL. Want to learn more? Download the demo project!

Calculated Columns.Example - 1

Page settings

Appearance

Multiple Sort

Filter builder

About this demo

Change your password

Change password for user ''