Edit on GitHub

Table

The table widget can hold structured data in the form of an array. The input widget for table data is a table with variable rows and columns as shown below.

Table preview

The data is stored in an array, which needs to be flattened for storage in the database. For this purpose columns are separated with a "|" and rows are distinguished with line breaks. The database field for a table is a TEXT column. For example, the data shown in the screen above would be stored as:

one|two|three
four|five|six
seven|eight|nine

Table settings

The input widget can be preconfigured with default data or a fixed amount of rows and columns. The default amount of rows and columns, as well as the default data, can be changed later when the data is entered. It's possible to prevent adding/removing additional rows/columns by setting the "Rows fixed"/"Cols fixed" checkbox. If this is set to fixed the add and delete button for rows and columns will disappear.

In order to set table data programmatically, an array needs to be passed to the setter as shown in the code snippet below:

$object->setTable([
    ["one", "two", "three"], 
    ["four", "five", "six"], 
    ["seven", "eight", "nine"]
]);