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.

General Properties:

You can set the Checked or Unchecked option in the General Properties and this chosen value will be inserted by default into this Checkbox field, when a new record is created.

Checkbox General Column.png

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 is represented as a picture Tick-Sign.png (a tick appears in a corresponding table cell). If the Display as graphic checkbox is left clear, the column contains Yes/No values.

Properties defined by the column type:

Checkbox Column.png

Checkbox Options

Column Property

Description

Data Entry

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

Agree-Tick.png

or radio buttons

Radio-Buttons.png

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.

3Check.png

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

2Checked.png

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.

4Check.png

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.

Help

When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: Phone Number Columns