Event Table Edit is a free table plugin for Joomla 3.x to create a responsive, editable table with CSV / XML import and export, and a simple appointment booking system function. Any help in the development is highly appreciated.
GNU General Public License v3.0
10
stars
6
forks
source link
Frontend: Add option to calculate column values #135
We could add an option to calculate column values (only working with integer and float columns).
In the backend, we need the option "Add calculating column" (ger: "Additions-Spalte hinzufügen") and yes /no (ger: ja/nein). If yes is chosen, we have the following options:
(1) "Choose column numbers for calculation, separated by comma:" (ger: "Zu addierende Spalten wählen, getrennt durch Kommas")+ [Text field]
(2) "Choose one column for the calculation result. Caution, existing values are overwritten!" (ger: "Spalte für das Rechenergebnis wählen. Vorsicht, vorhandene Werte werden überschrieben" + [integer field]. Add an jscript error check to the integerfield: If integer in text field (2) is in text field (1), show red text field.
Then: add a function to the table that gets the column numbers from the field (1), calculates the values in the row (show error in cell, if calculation did not work due to wrong text values) and shows the calculation result in the user selected column from (2). Results should be refreshed each time values in the columns from (1) are edited.
We could add an option to calculate column values (only working with integer and float columns). In the backend, we need the option "Add calculating column" (ger: "Additions-Spalte hinzufügen") and yes /no (ger: ja/nein). If yes is chosen, we have the following options: (1) "Choose column numbers for calculation, separated by comma:" (ger: "Zu addierende Spalten wählen, getrennt durch Kommas")+ [Text field] (2) "Choose one column for the calculation result. Caution, existing values are overwritten!" (ger: "Spalte für das Rechenergebnis wählen. Vorsicht, vorhandene Werte werden überschrieben" + [integer field]. Add an jscript error check to the integerfield: If integer in text field (2) is in text field (1), show red text field.
Then: add a function to the table that gets the column numbers from the field (1), calculates the values in the row (show error in cell, if calculation did not work due to wrong text values) and shows the calculation result in the user selected column from (2). Results should be refreshed each time values in the columns from (1) are edited.