Checkbox Columns

You may create checkbox columns when you want to check that a task is complete, work is done or a payment is transferred. Moreover, checkbox column data are often used as a condition for notification sending to your users.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

Checkbox Options

Column Property

Description

Display as graphic

This property allows a user to specify graphical representation of the check box value. If the Display as graphic check box is selected, the field will be represented as a picture (a tick will appear in a corresponding table cell). If the Display as graphic check box is left clear, the column will contain Yes/No values.

Data Entry

There are the Checkbox and the Radio Buttons option for checkbox column allowing a user to edit the state via a checkbox

or radio buttons

Yes Label

No Label

You can specify alternative texts for the checked and unchecked state.

Leaving both Yes and No Labels empty preserves existing functionality – checkbox with no label on entry and texts Yes/No on display.

If you provide a text for Yes Label and leave No Label empty, the label is displayed beside the checkbox.

In the view mode the label for checked state and empty string for unchecked state is displayed.

In case of radio buttons, the system tries to fit the both buttons into a single line; if there is not enough space, buttons are displayed one under another.

Of course the Display as Graphic option will suppress text and will display the checkmark instead, yet there is a couple of places, where the Display as Graphic option is ignored, for example, in documents and email notifications.

Also, strings provided for Yes and No Labels are recognized when importing the textual data from CSV file or clipboard – once you set up the labels you can import the file containing, say, Ja/Nein or Si/No directly into checkbox column.

Totals

This property allows a user to view the total for all column entries; select the checkbox if you want the Totals line to be present at the end of the table.

Averages

This property allows a user to view the average for all column entries; select the checkbox if you want the Averages line to be present at the end of the table.

Next: Phone Number Columns