Check Boxes from Data Values

Top  Previous  Next

Check boxes are a popular means to represent Yes/No data values.  You sometimes see web pages using check boxes to allow the user to select several options such as which mailing lists from a number of available they would like to subscribe to.  For this type of selection you would need a Yes/No database field for each individual mailing list in the available list.  You can then place each field on your page.  HTML offers the ability offer a group of check boxes with the same name, and the data values are concatenated into a single result, this concept does not port well to databases and is not supported in dbQwikSite.

 

Check boxes can be places on data list page and on data entry pages.

 

start by

1. Click on the Item Editor button (btn_item_editor_002) on the toolbar

 

- OR -

 

1. Right Click on the Item that you would like to be represented as a Radio Button and then select Properties from its popup menu

 

Dialog vary slightly by page type:

 

Check Boxes on Data List pages

This Input Properties dialog box appears

 

dlg_Item_Prop_Check_Data_Page_001

 

2. Set the Type as Check Box,

 

3. Tell dbQwikSite what field from the data set to use for data values, behind this check box.

 

4. Tell dbQwikSite when it should check the box when displaying.  In this example any if the IsPermanent field is equal to 1 the box will appear check for all other values the box will appear unchecked.

 

Your page  would appear similar to:

 

pg_data_check_001

 

Note: The check boxes on data pages cannot be changed by a page visitor, by clicking them.  They are only displaying static data as do all other data values on data pages.

 

Check Boxes on Data Input pages

 

Click on the Item Editor button (btn_item_editor_002) on the toolbar

 

- OR -

 

Right Click on the Item that you would like to be represented as a Radio Button and then select Properties from its popup menu

 

The Input Properties dialog box appears

dlg_Item_Prop_Check_Edit_Page_001

 

To display data as a Check Box, the Type must be set to Check Box.
You can specify text that will be displayed to the right of your check box.  This can add clarity as what the check value represents.  If you do not want a caption, just blank out this field.
You need to tell dbQwikSite, what values to store in the database when the user adds or updates a record.  You specify a value your store in the database.  This same mapping is used when data is displayed on this page.
When you display existing records the check box will reflect the that data of the current record.  However when adding new records, you can specify whether of not the check box should be defaulted to checked or unchecked.

 

Your page item would appear similar to this:

 

edit_checkbox_appearance_001