The CheckBoxes control
CheckBoxes with AllowFillIn set to True:
Type : CheckBoxes
Provides a unique name for the control.
Indicates if the control is
- Bound to list column
- Is a label for a control bound to list column
Enabled for new records
Sets if the control will be enabled or disabled when the forms handles a new record
Enabled for existing records
Sets if the control will be enabled or disabled when the forms handles an existing record
Marks the cotnrol as Required.
By default, the system recognizes required fields and marks them with this flag. Additionaly, controls can be marked as required event if the bound column is not.
Set an expression then will be evaluated during run-time and enable or disable the control.
Dependencies between controls are automatically identified and the expression is re-calculated every time a control affecting the formula changes.
form.GetControl("c_Status").GetValue() != "Open" && form.UserInGroup("Administrators")
The expression should return a boolean value.
For example :
form.FieldValue("c_Status") != "Rejected" || form.UserID() == "1"
This property defines how the control will get its value.
Here are the available options :
- The value is Static (this is the default for label controls)
- The value will be provided by the user (Not applicable for labels)
- The value will be calculated by a formula
- The value will be retrieved from a list query
- The value will be provided by a web service call
- The value will be provided by a SQL query
A static text must be set in the appropriate designer control.
If the formula contains references to other controls, dependencies will be automatically identifies during run-time and the value will be updated to reflect changes.
form.FieldValue("c_Active") ? "Yes" : "No"
There is an additional option that instructs the form to perform calculations only for new records. Existing records will keep their original value.
A predefined list query is bound to the value of the control. So during form initialization, the specified list query is executed and if it returns any item, it selects the first one and it will apply the value to the label based on the following rule :
If a Field Name has been selected in the corresponding box, that specific column will be used from the list item to fill the control value.
If the Field Name is left blank, the first column retrieved will be used.
The same as above, the required web service is selected and after the web service retrieves data, the first item will be used to update the control value. If no Field Name is set, the control will receive the first field of the retrieved item.
Works the same way ListQueries and Web Service works.
The default value has any effect only of the control is bound to a list column.
For unbound controls, the default value is ignored.
You may set a static value here or use a formula by starting your input with the "equals" (=) sign.
Defines the color of the parent cell.
Declares the font size of the text
Sets the margin applied to the control, that is, the spacing between the control and the cell borders.
Changes the weight of the font used
Changes the font style for the control text
If the control is bound to a choice column, then the Static Values property is automatically
filled with the underlying values from the column. The property is read-only as
every change in the column values will be automatically reflected in the control values.
Splits the CheckBoxes into different columns. The property ignores the value 0 (zero) and translates it into 1 column regardless.
If the internal name of a column is supplied, the retrieved results will be filtered allowing unique values for that specific field.
Defines if the results will be sorted by the Display Field.
Defines the data field name that will group the results.
Defines if the columns that will be created (if more that one) will all have the save width
Set this property to TRUE to allow the users to fill their own value. Use this for fill-in choice or textual columns.
Sets the script that will be executed at the value-change event of the control.
var value = form.GetControl("c_Title").GetValue();
if (value == "Open") form.HideSection("Details");