View Source:   Products (Outlook Interface)

 
This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings  Column Settings   Choose   Generate PHP Code   Remove All Settings   ?  
 
Cancel
FieldUNITSINSTOCK   Type: int   Change Type
Default Title
Grid Title
Edit Title 2 Fields in Row
New Title 2 Fields in Row
Edit Notes
Use {KEY} to incorporate primary key, and prefix ?EDIT? or ?NEW? to display note only in EDIT or NEW state
Detail Title 2 Fields in Row
Filter Title
Input Dimensions
(suggested size: 16)
Columns:

Power Lens
Lookup Values
Input Type       Enter a lookup to allow check boxes and radio buttons
# check/radio columns
Overlib Text
Search Lookup when editing
Matching above sql with fields
Minimum character length   Search mode   Hide key code
Validation
 X: 0-9 A-Z             x: 0-9 A-Z optional       Z: 0-9 A-Z _            z: 0-9 A-Z _ optional
#: 0-9 9: 0-9 optional +: positive numbers only
&: any character ?: any character optional \: escape character >: to uppercase <: to lowercase =EMAIL: email validation
Validation Error Msg
Default New Value
Prefix value with = to execute PHP code and % for SQL function
Optional Editable ColumnEnabled when Column   has value Enter A^B^C, or * for any non-empty value
Power Edit Lens
Grid TD Attributes   (nowrap, width=30%, align=center etc.)
Cell Color grid^title^input  
Color Reference opens in a new window

Section Break Title
Back color   CSS class

WYSIWYG Editor for fields that accept HTML
Must FillNo   * Must Fill Columns
Read OnlyNo   - Read Only Columns
Visible in GridNo   Grid Columns
Visible in New RecordYes   * New Record Columns
Visible in Edit RecordYes   * Edit Columns

Charting
Chart ImagesGIF/JPEG file:
Image for negative values (only for bar chart):
Chart DimensionsWidth:   Height:
Chart Min/Max (SQL)SQL to get Min/Max field values:
Example SQL: select min(UNITSINSTOCK),max(UNITSINSTOCK) from products
Chart Min/Max (manual)Minimum field value:   Maximum field value:
Use manual entry if Chart Min/Max (SQL) left empty
Icon Chart ScaleOne icon/character represents unit(s)
  Cancel
PHPLens: 4.9.2   Data: 0.02   DB: mysql   adodb: 4.62   Compat: 2   PHP: 5.2.17   OS: Linux
License Type: Enterprise   ID: (Natsoft;John Lim;jlim@natsoft.com)   Valid Till: Never Expires

Notes

This demo shows the use of a powerLens to set the anchor tag for PRODUCTNAME to drill down to details.

Note that each PHPLens object is created using a different ID (the first parameter in the constructor): outtop and outbot to ensure that there are no conflicts.