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. Note that fields format you've chosen is preserved on the Advanced search page, for example, drop-down boxes, date-pickers, check boxes formats.

Text field

Simple text box.

For more information about available validation types, see Validation types.

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 select 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

Multiline text area. For advanced WYSIWYG edit capabilities select the Use Rich Text Editor check box. For more information  about using Rich Text Editor, see Rich Text Editor plugins.

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. You can modify start/end year in the date dropdown box.

Simple edit box with datepicker also allows to enter time.

Time

Time edit control. Use the Use Time picker check box to enable time picker and select time instead of typing it. Select 12 or 24 hour format and one of available minute intervals.

Note: the Use Time picker option does not work in Internet Explorer.

Radio-button

Use a radio button control to limit a user's selection to a single value within a set of values.

Checkbox

Check box control. Works best with the following data types:

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).

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. Since some hosting providers do not allow making reference to the directories, which are above the current one, you can use the Absolute path option and specify the full path to the directory on the server, in which files will be uploaded. E.g. C:\Inetpub\WWWROOT\project1\files.

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. To do this, select the Create thumbnails of the fly check box and choose thumbnail size and thumbnail prefix. For example, if the original image filename is example.gif and thumbnail image filename is th_example.gif correspondingly, then thumbnail prefix is th_. Note that thumbnail images are stored in the same folder as the images.

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, select the Resize images after upload option and select max width or height of resulting image.

Binary field: Image

To create thumbnails on the fly, select the Create thumbnails of the fly check box and choose the field name to save thumbnails in.

Note: you need an additional binary field (field of MEDIUMBLOB type) to store thumbnails. This field is the auxiliary one and we do not recommend to display it on your pages. You can display/hide fields on the Choose fields page.

To resize images on upload, select the Resize images after upload option and select max width or height of resulting image.

Binary field: File

Choose field that stores name of database file. 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.

Lookup wizard

Drop-down box with list of values. For more information about lookup wizard, see Lookup wizard.

Readonly

Use this format for a field that should not be edited.