Sheets: Checkboxes and Radio Buttons
Checkboxes and radio buttons are Sheet Elements used to indicate a selection by toggling an X on or off. Checkboxes allow one or many selections. Radio buttons allow only one selection out of a group of options. Both can correspond to a specific field in the database or be a misc field that does not.
The checkbox or radio button is the actual X, not a box surrounding the X. This makes it useful for scanned backgrounds. If you need to add a box, you can add a rectangle behind the checkbox or radio button as a visual indicator.
When Customizing a Sheet, click CheckBox.
Field Name: The available field options the checkbox can correspond to. The field you select may change other options on the screen.
When misc is selected, the Reportable Name field shows. Enter an identifying name for this misc checkbox/radio button.
For a sample misc query, see Input Fields.
X/Y Pos: Determines the position of the upper left corner of the checkbox in relation to the x and y axis. X = horizontal. Y = vertical.
Width/Height: The size of the checkbox/radio button. Suggested size is 11x11.
Radio Button Group Name: Only visible when misc is the field name. Used to create custom checkboxes or radio buttons not tied to a database field.
For radio buttons (single selection), enter a common name used for all radio buttons in the group. For checkboxes (one or many selections), enter a unique group name for the checkbox.
Required: If checked, the user will be required to select an option in the generated form before saving it. If adding radio buttons, all radio buttons in a group should be marked the same: all required or all not required.
Radio Button Value: Only visible when a database field is the selected field name. The values listed are based on database options. Create one radio button for each value.
Tab Order: The order of an element when users press Tab on the generated form. (Hint: Click Tab Order in the right panel to view and edit the tab order of all elements on a sheet.
These steps will create a group of radio buttons that correspond to database fields and whose values can be imported. You must create a radio button for each possible value in a radio button group for it to work correctly. If a user clicks one radio button in a group, the other buttons in the group automatically uncheck.
These steps will create a group of radio buttons whose values cannot be imported, but can be reported in Custom Queries.
These steps will create a checkbox that allow one or many selections. Repeat these steps for each checkbox.