|
You can customize your data appearance on the add/edit/advanced
search pages using formatting options on the "Edit
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.
"Edit as" formats
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.
Default value
now() -
current datetime
$_SESSION["UserID"]
- user id of person who updated the record
$_SERVER['REMOTE_ADDR'] - IP address
Apply on the Edit page as well
If you check off this check box default value will be applied every
time record is updated. You can use this feature to keep track of who
and when updated the record.
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.
|
