|
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.
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 using Rich Text
Editor.
Password
Password field. All
entered characters appear as "*".
Date
Date edit control. You can choose between simple edit box,
simple edit box with datepicker, drop-down boxes with day, month
and year selection, and advanced datepicker.
Simple edit box with
datepicker also allows to enter time.
Time
Time edit control. You can select Use Time picker checkbox and enable
time picker to select time instead of typing it. Select 12 or 24
hour format and one of available minute intervals.
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:
File/Image
Depending on the
field type this control allows uploading images and files to the
database (binary field) or to some directory on the Web server
(text field).
To
upload images and files to some directory on the server, you need
to enter the path to that directory. The path should be relative to
the folder with generated pages. Use the Add timestamp to
filename option to add the date/time to the filename so that
each file has the unique name. Use the Delete file when
associated record is deleted option to make sure that a file
will be deleted when associated record is deleted from the
database. This option is global and if enabled is applied to all
tables and fields.
PHPRunner allows
creating thumbnails on the fly. If you want to do this you should
select the Create thumbnails of
the fly 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. More info about
lookup wizard.
Readonly
Use
this format for a field that should not be edited.
|
