|
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,
ASPRunner.NET 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_".
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). ASPRunner.NET 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 work with thumbnails you need to have ASPJpeg component
installed on the Web server. Most Web hosting companies have this
component installed.
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
|
