You can customize your data appearance on the List/View/Print/Export pages using formatting options on the "View as" settings dialog. You can define your field settings for all pages at once or separately for each page.

To control the filed appearance on the page click right button over the field and choose Properties. Depending on selected format you will see different box-dialogs.

To set different field formats for different pages enable the Use different settings for all pages check box. Depending on selected format you will see different box-dialogs.

Dates will be displayed in short format ( 02/17/2003 ).

Dates will be displayed in long format ( 17 February 2003 ).

Datetime values will be displayed as date and time ( 02/17/2003 14:22:03 ).

Datetime values will be displayed as time ( 14:22:03 ).

Numeric values like 14000 will be displayed as $14 000.00 ( actual format depends on your system regional settings like currency symbol, decimal symbol etc.).

Example: 0.38 will be displayed as 38%.

Choose this format if you store hyperlinks in this database field. Those hyperlinks will be made clickable automatically.

Choose this format if you store email addresses in this database field. It will be converted into mailto HTML code automatically.

Available for Binary and Text fields. Depending on field type you will be able to choose either folder where files are located (for text field) or field name that stores filenames (for binary field).

Binary field

In this case file is stored in the database and you need to choose a field that stores name of database file. This filename is required to set correct file type when you retrieve uploaded file from the database. If you don't choose filename field or leave it empty, you will be presented with Open with ... dialog every time you download this file from the database.

Text field

In this case files are stored in some folder and text field contains filename. You need to define the folder where files are located. The path should be relative to the folder with generated pages. Since some hosting providers do not allow making reference to the directories, which are above the current one, you can use the Absolute path option and specify the full path to the directory on the server, in which files will be uploaded. E.g. C:\Inetpub\WWWROOT\project1\files.

Available for Binary and Text fields.

Example of how image is displayed in the browser:

Binary field

In this case images are stored in the database in the binary fields. ASPRunnerPro creates code that extracts images from the database on the fly. Supported image formats are JPEG, GIF and BMP.

You can define fixed image size using the Image width and Image height text boxes.

If you want to display the thumbnail image, you should select the Display thumbnails check box and choose the field name that stores the thumbnail.

Note: you need an additional binary field (field of MEDIUMBLOB type) to store thumbnails. This field is the auxiliary one and we do not recommend to display it on your pages. You can display/hide fields on the Choose fields page.

Text field

In this case images are stored in some folder and text field contains filename of the image. You need to define the path to the images folder in the URL prefix text box. Here are some examples of the URL prefix usage:

Note that in most cases URL prefix ends with forward slash.

You can define fixed image size using the Image width and Image height text boxes.

If you want to display the thumbnail image, you should select the Display thumbnails check box and then define the thumbnail prefix. For example, if the original image filename is example.gif and thumbnail image filename is th_example.gif correspondingly, then thumbnail prefix is th_. Note that thumbnail images are stored in the same folder as the images.

iBox plug-in

If you want to display the images using iBox plug-in, select the corresponding check box. You can get more information about iBox plug-in at http://www.enthropia.com/labs/ibox/.

Formats number as a US phone number. Supports 7-digit or 10-digit numbers (123) 456-7890 or 123-4567.

Number

Choose this format if you like to format this field as number. You can set the default number of digits after the comma for all numeric fields.

Use this view type when you store formatted HTML code in database field and wish to display this HTML code on the list page.

Use view format to present field value as a check box. Works best with the following data types:

Allows adding Google Maps to your web pages.For more information, see "View as" settings: Map.

Allows formatting field values by adding ASP code. For more information, see "View as" setting: Custom.

Select the field that contains the audio titles. Audio titles are displayed instead of the audio file URL/path.

If the selected field contains audio file URL, select the corresponding check box. If the audio files are stored in some directory on the server, enter the path to that directory. The path should be relative to the folder with generated pages. Since some hosting providers do not allow making reference to the directories, which are above the current one, you can use the Absolute path option and specify the full path to the directory on the server, in which audio files are stored. E.g. C:\Inetpub\WWWROOT\project1\files.

Edit as type can be either Text field (enter audio file name there) or File/Image (upload files).

Example of how the audio files appear in the browser:

If the selected field contains video file URL, select the corresponding check box. If the video files are stored in some directory on the server, enter the path to that directory. The path should be relative to the folder with generated pages. Since some hosting providers do not allow making reference to the directories, which are above the current one, you can use the Absolute path option and specify the full path to the directory on the server, in which video files are stored. E.g. C:\Inetpub\WWWROOT\project1\files.

You can see what video file types are supported at http://flowplayer.org/documentation/technical-facts.html.

Edit as type can be either Text field (enter video file name there) or File/Image (upload files).

Example of how the video files appear in the browser: