|
You can customize your data appearance on the list/view/print pages
using formatting options on the "View
as" settings dialog. 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.
"View
as" settings
You can control the field appearance on the list page. Choose between
the following formats:
Short Date - dates will be
displayed in short format ( 02/17/2003 )
Long Date - dates will be
displayed in long format ( 17 February 2003 )
Time - datetime values will
be displayed as time ( 14:22:03 )
Currency - 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.)
Percent - Example:
0.38 will be displayed as 38%.
Hyperlink - choose this
format if you store hyperlinks in this database field. Those
hyperlinks will be made clickable automatically.
Email Hyperlink - choose
this format if you store email addresses in this database field. It
will be converted into mailto
HTML code automatically.
File (available for Text and
Binary fields)
Depending on field type (text or binary field) you will be able to
choose either URL prefix to folder where files are located or field
name that stores filenames.
Here are some examples of URL prefix usage:
images/ - images folder is located in output directory
/images/ - images folder is located under website root
../images/ - images folder is located one level above
http://www.abc.com/images/ - full path to images folder
Note: in most cases URL prefix ends with forward slash.
Mercedes-Benz-CL-500.jpg will be automatically converted into <img
src="images/mercedes-benz-cl-500.jpg" border=0>
In case of Binary field you need to choose a field that stores
filename. 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.
Image (available
for Text and Binary fields)
Binary field
- if you store images in
the database, PHPRunner creates a code that extracts images from
database on the fly. Supported image formats are JPEG, GIF and BMP.
If you want to display the thumbnail then you should select
the appropriate checkbox and choose the field name that holds the thumbnail.
Text field - choose image size
and URL prefix similar to View
as type File.
If you want to display the thumbnail then you should select
the appropriate checkbox and choose the thumbnail prefix. For
example, if the original image file's name is example.gif and
thumbnail file's name is th_example.gif correspondingly then the
thumbnail prefix should have the value of "th_".
If you want to display the images
using iBox
plugin check corresponding checkbox.
More info about iBox
plugin here.
US phone number -
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. Two digits
after decimal point implied.
HTML - use
this view type when you store formatted HTML code in database field
and wish to display this HTML code on the list page.
Checkbox - use view format
to present field value as a checkbox. Works best with the following datatypes:
MS Access:
Yes/No field
SQL Server:
TINYINT or BIT field
MySQL: TINYINT
Oracle: NUMBER(1) |
