Table field

The table field allows the user to create and manipulate an HTML table.

General settings

Click on the button labeled "Create table" to create a new one, and a popup appears:

The popup shows you the table's general settings:

• columns - the number of columns

• rows - the number of rows

• layout - choose between horizontal and vertical

• alignment - the cells' global text alignment

• border-style - the cells' global border styles

• text color - the cells' global text color

• background-color - the background color of the cells. If you want to create a zebra effect, choose two different main and alt colors.

At the bottom you'll also find two flags:

• add header - if you want a <thead>

• add footer - if you want a <tfoot>

Click on Create once you're done.

Editing a cell

Double-click on a cell to edit it.

When editing a cell, you can navigate the other table cells by pressing the TAB key.

Adding and removing rows and columns

To add a row, click on the "+" icon on the left side of the table (where you see the numbers).

To add a column, click the "+" icon at the top of the table (where you see the letters).

To delete a row, click the "-" icon at the very end of the row.

Finally, to delete a column, click the "-" icon on top of it.

Custom Cell settings

You can override all the cell single properties.

Right-click on a cell and a contextual menu appears:

Save as template

Every table can be saved as a reusable template.

Just click on the Save as template button and a popup appears:

Select the name and save.

Import template

If you have one or more saved templates, you can always import them.

Click on the Import template button, and a pop-up appears:

Select the template, and this will be automatically applied to the field.

Arithmetic calculations

To evaluate a mathematical expression, use the following syntax:

=(EXPR)

You can perform simple operations like =(23+56) or reference other cell values. Both individual cells (e.g., A1, A2, A4) and cell ranges (e.g., A1:A4) are supported.

The following operators are available:

Operator	Description	Examples
SUM	Addition or subtraction	=(SUM(A1,A2,A4)) • =(SUM(A1:A4))
MULT	Multiplication or division	=(MULT(A1,A2,A4)) • =(MULT(A1:A4))
MIN	Returns the minimum value	=(MIN(A1,A2,A4)) • =(MIN(A1:A4))
MAX	Returns the maximum value	=(MAX(A1,A2,A4)) • =(MAX(A1:A4))
AVG	Calculates the average	=(AVG(A1,A2,A4)) • =(AVG(A1:A4))
ROUND	Rounds a number	=(ROUND(A1, 2))
POW	Raises a number to a power	=(POW(A1, 2))
PERC	Calculates a percentage	=(PERC(A1, 56))
SQRT	Returns the square root of a number	=(SQRT(A1))
ABS	Returns the absolute value of a number	=(ABS(A1))
MOD	Returns the remainder of a division	=(MOD(A1, 3))
MEDIAN	Returns the median value	=(MEDIAN(A1,A2,A4)) • =(MEDIAN(A1:A4))
COUNT	Counts the numeric cells among the arguments	=(COUNT(A1,A2,A4)) • =(COUNT(A1:A4))

Import data from a Google Sheet

Click on the Import Google Sheet button, and a pop-up appears.

Then, paste the Google Spreadsheet ID, select the Sheet, and choose the format.

The data will be automatically appended to the table.

The Google Sheet MUST be public.

If the number of items per row doesn't match the number of columns, an error will be thrown.

Import data from a CSV

Click on the Import CSV button, and a pop-up appears.

Then, select your CSV file, and the data will be appended to the table.

If the number of items per row doesn't match the number of columns, an error will be thrown.

Pagination and sorting

If you want your table to support sorting and pagination, open the Advanced Options panel, set the number of items per page, and enable the sortable option.