|
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.
Short Date
Dates will be displayed in short format ( 02/17/2003 ).
Long Date
Dates will be displayed in long format ( 17 February 2003 ).
Datetime
Datetime values will be displayed as date and time ( 02/17/2003
14:22:03 ).
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.
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)
Custom
Allows formatting field values by adding php code. More info
here.
|
