|
You can customize your data appearance using formatting options. 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)
"Edit
as" settings
Fields format you've chosen is preserved on the Advanced search page,
for example, drop-down boxes, date-pickers, checkboxes formats. Apart
from this, search is now case-insensitive.
Text field - simple
text box
See list
of available validation types here.
Text area -
mutlitrow text area. For advanced WYSIWYG edit capabilities check
off "Use Rich Text Editor" checkbox.
More
info about choosing Rich Text Editor
Password - password
field. All entered characters appear as "*".
Date -
date edit control. You can choose between simple edit text
box, drop-down boxes with day, month and year selection, and advanced datepicker.
Simple edit box with datepicker
also allows to enter time.
Radio-button
- use a radio button control to limit a user's selection to a
single value within a set of values.
Checkbox - checkbox control.
Works best with the following datatypes:
MS Access: Yes/No field
SQL Server: TINYINT or BIT field
MySQL: TINYINT
Oracle: NUMBER(1)
Image/File
- depending on field type this control allows to upload images and
files to the database (binary field) or to some directory on the Web
server (text field). PHPRunner also makes it possible to create
thumbnails on the fly. If you want to do this then you should select
the appropriate checkbox and:
Binary
field - choose thumbnail size and the field name in which the
thumbnail will be saved.
Text field
- choose thumbnail size and 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_".
Note:
To use thumbnails functionality you need to have the GD
library installed. On Windows you need to uncomment php_gd2.dll
extension in your php.ini file.
To resize images on upload check off Resize images after upload option and select max width or height of resulting image.
Lookup
wizard
- drop-down box with list of values.
Readonly
- use this format for a field that should not be edited.
Sample
add/edit page screenshot
|
