Please enable JavaScript to view this site.

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

"View as" settings

Scroll Prev Next More

Using "View As" settings

You can customize the data appearance on the List/View/Print/Export pages using formatting options on the View as settings dialog. You can define the field settings for all pages at once or separately for each page.

 

To control the field appearance on the page, click on the field and then on the View As/Edit as button in the properties.

pd_vieweditas

 

To set different field formats for different pages enable the Use different settings for all pages checkbox.

 

Depending on the selected format, you will see different dialogs.

visual_editor_view_as

Copy settings

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

copy_field_settings

Field events

Field events option allows performing an action when the cursor enters, leaves or is over an edit field. Perform any sort of validation, make other fields hidden or required, etc. Field events are designed to work on Add, Edit, View and Register pages.

 
For example, the mouseover event occurs when the pointer is over the selected element.

visual_editor_view_as_field_ev

"View as" types

Text

The values are displayed as text.

 

Truncate large text fields

 

This option limits the number of characters that can be displayed in a single text field on a page. The "More ..." link appears if the number of characters is higher than the number you have entered into the Characters to display field.

 

Note: for this option work correctly, you must choose the key field for the selected table on the Choose pages screen.

 

misc_settings_table_specific_truncate_text

Short Date

Dates will be displayed in a short format ( 02/17/2003 ).

Long Date

Dates will be displayed in a long format ( 17 February 2003 ).

Datetime

Datetime values will be displayed as date and time ( 02/17/2003 14:22:03 ).

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

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

Image

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

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 a number. You can set the default number of digits after the comma for all numeric fields.

view_as_number

HTML

Use this view type when you store formatted HTML code in the database field and wish to display this HTML code on the List page.

Checkbox

Use this view format to present field value as a check box. Works best with the following data types:

MS Access: Yes/No field

SQL Server: TINYINT or BIT field

MySQL: TINYINT

Oracle: NUMBER(1)

Map

Allows adding maps to the web pages. For more information, see "View as" settings: Map.

Custom

Allows formatting field values by adding PHP code. For more information, see "View as" setting: Custom.

Audio

Choose this format if you store audio files in this field. For more information, see "View as" settings: Audio.

Video

Choose this format if you store video files in this field. For more information, see "View as" settings: Video.

QRCode

The QRCode control allows you to add QR Codes to your pages. For more information, see "View as" settings: QRCode.

See also:

Field events

How to access fields in the field events

Connecting to the database

About Date Control API

"Edit as" settings

About Page Designer

About Editor

 

Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software