PHP Generator for MySQL online Help
Prev | Return to chapter overview | Next |
Check box group
Select this control to provide users with the ability to select multiple items. You can also use the Multiple select control for this purpose. The difference between these editors are:
• | Check box group demonstrates all values available for selection, |
• | Multiple select provides adding new items using drop-down combobox and requires less space in the form. Live Demo. |
Changing the control type to Multiple select creates this multi-choice control with the same properties.
In case you use Check box group to work with a table column, the corresponding Filter Builder uses Multiple select for this column.
Max width
Use this property to restrict the maximum width of the editor (this means that in any screen resolution editor's width will be less or equal then the property value). Can be specified in any units supported by web browsers e.g. 300px, 25em, 50%, etc.
Values
You can separate values to be represented in the control and values stored in the database. For this purpose use the dialog opened by the ellipsis button and enter the values you need, or add them manually as pairs stored_value=value_to_be_represented separated by commas (Example: 1=One, 2=Two).
Display mode
Use the drop-down list to select whether the check box group will be represented on the same column (Stacked) or on the same line (Inline).
Retrieve values from database
Turn this option ON to fill in the control with values from a database.
Data source
Data source name to retrieve values from.
Stored field
Data source field name to retrieve stored values from.
Displayed field
Data source field name to retrieve displayed values from.
Sorting
Sorting order of displayed values in the editor.
Filter condition
Allows to reduce the list of values represented in the editor with a specified criteria. This condition corresponds to the WHERE clause applied to the data source (you must not add the WHERE keyword to beginning of the condition). The following operators can be used in this clause: =,<> (!=), >, <, >=, <=, BETWEEN, LIKE, IN. It is also possible to use predefined variables like %CURRENT_USER_NAME%.
Add new item on the fly
Turn this option ON to allow adding new items directly in the editor. When this option is checked, an 'Insert item' link is displayed on the bottom of the editor.
Click the ellipsis button at the right to customize the modal dialog to be displayed when adding a new item. For example, you might want to hide some fields and/or customize the form layout.
Note: If values are retrieved from a database, hard-coded values described above are ignored and NOT included into the list of available choices.
Inline styles
Use this field to set formatting options to be used inside the style attribute of the element. For example, to set the font color and the background color for a control, place the following string to Inline styles:
color: red; background-color: yellow;
Custom attributes
This property allows you to add simple metadata to individual elements, largely for the purpose of providing information to make JavaScript functions easier. Such attributes can be later handled in client-side events. For example, to add several custom attributes to an editor, enter the following string into the Custom attributes edit box:
data-city="Boston" data-lang="js" data-food="Bacon"
It is recommended to prefix all custom attributes with data- to keep the result document compatible with the HTML5 requirements.
Prev | Return to chapter overview | Next |