Show/Hide Toolbars

Navigation: Using PHPRunner > Page Designer > "Edit as" settings

PHPrunner32x32     PHPRunner manual


"Edit as" settings

Scroll Prev Next More

 

You can customize your data appearance on the Add/Edit/Search using formatting options on the "Edit as" settings dialog. You can define your field settings for all pages at once or separately for each page.

To control the filed appearance on the page right-click the field and choose Properties. Note that fields format you've chosen is preserved on the Advanced search page, for example, drop-down boxes, date-pickers, check boxes formats.

pd_vieweditas

To set different field formats for different pages enable Use different settings for all pages check box. Depending on selected format you will see different box-dialogs.

edit_as

Common options for "Edit as" formats

Validate as

For more information about validation, see Validation types.

Default value

Default value will be assigned to a field directly on the Add/Search pages. Default value should be a valid PHP expression. Text expressions must be quoted.

Example of default value

Description

35

Number.

"ABC"

Text.

now()

Current date/time.

$_SESSION["UserID"]

Username of the person who created or updated the record.

$_SERVER['REMOTE_ADDR']

IP address.

AutoUpdate value

AutoUpdate value will be assigned to a field every time record is updated on the Edit page. You can use this feature to keep track of who and when updated the record. AutoUpdate value should be a valid PHP expression. Text expressions must be quoted.

passwordformat

Placeholder

Placeholders are in-place tooltips that disappear as soon user starts typing something in that field.
placeholder

On the generated page placeholder looks like this:
placeholder_example
You can change placeholders also in the Label Editor.
Feel free to check the following live demo that showcases placeholders.

Prevent duplicate values

Use this option to prevent users from entering duplicate values. Enter a message that will be displayed when users enter value that already exists in database to Message field.

Example of AutoUpdate value

Description

35

Number.

"ABCDEF"

Text.

now()

Current date/time.

$_SESSION["UserID"]

Username of the person who created or updated the record.

$_SERVER['REMOTE_ADDR']

IP address.

Copy settings option allows you to copy field settings from another field.

copy_field_settings

Field events option allows to perform an action when cursor enters edit field or leaves it or mouse is over a field. Perform any sort of validation, make other fields hidden or required etc. Designed to work on Add, Edit, View and Register pages.
For example, the editing event is fired when an element changes its value. Text fields fire this event while user entering the text

See also How to access fields in the field events

field_events

Text field

Simple text box. For more information, see "Edit as" settings: Text field.

Text area

Multiline text area. For more information, see "Edit as" settings: Text area.

Password

Password field. All entered characters appear as "*".

Date

Date edit control. For more information, see "Edit as" settings: Date.

Time

Time edit control. For more information, see "Edit as" settings: Time.

Checkbox

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

MS Access: Yes/No field;

SQL Server: TINYINT or BIT field;

MySQL: TINYINT field;

Oracle: NUMBER(1) field.

edit_as_checkbox

Select the Required field option to make the check box required so that it should be selected before submitting a form. Use this option for the fields such as the Accept License Agreement and Terms.

File/Image

Choose this format if you store files/images in this field. For more information, see "Edit as" settings: File/Image.

Lookup wizard

Drop-down box with list of values. For more information, see "Edit as" settings: Lookup wizard.

Readonly

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

ColorPicker

The Color picker control that allows users select color the same way they do in Adobe Photoshop. For more information, see "Edit as" settings: ColorPicker.

SignaturePad

The SignaturePad control allows you to add signature pad to your forms. For more information, see "Edit as" settings: SignaturePad.