Change Field Display Order by Drag-and-Drop
You can change the field order defined in the database by simple drag-and-drop. Simply select multiple fields, then drag it to where you want. PHPMaker will generate scripts and display records according to this order.

Change Multiple Field Properties
Some field properties allow Multi-Update. You can select multiple fields, then right click and select Set field properties... to update them at the same time.

Multi-Page is supported for Add/Edit/View/Search pages, you can optionally enable it for each page. Page labels are also supported. See Table Setup.

If Multi-Page is enabled and the page number is 0, the field will appear in all pages.

The dropdown list for this setting is preloaded with a few functions for your selection. For example, you may want to record the last modified date of a record, then you can select "CurrentDate". Do not select a function that return values of unmatching data type, for example, you should not select a function that return a non-numeric string for a numeric field.

Card without card-* classes

Card with card-* classes

The following card-* classes are supported: Note Field with the following class will be shown without caption.

• TOTAL - Sum of all field values in current page
• COUNT - Count of records in current page
• AVERAGE - Average field value in current page

Extended Quick Search is enhancement of Quick Search. If a field is checked for Ext. Search, a form element for the field will be shown in the Quick(Basic) Search form and the user input criteria for this field will be included when performing Quick(Basic) Search.

Extended Quick Search will use the same search operators specified under the "Advanced Search Page" section (see below).

DIV Tag attributes

"onmouseover='my_js_function();' onmouseout='my_js_function2();'"

or preferably as an array, e.g.

["onmouseover" => "my_js_function();", "onmouseout" => "my_js_function2();"]

Format

• Default (based on locale settings)
• DateTime (Date and time, format based on locale settings)
• Date (Date only, format based on locale settings)
• Time (Default) Format based on locale settings (e.g. 12-hour with AM/PM for "en-US")
• Time (HHmm) 24-hour without seconds
• yMMdd
• MMddy
• ddMMy
• yMMdd HHmmss
• MMddy HHmmss
• ddMMy HHmmss
• yyMMdd
• MMddyy
• ddMMyy
• yyMMdd HHmmss
• MMddyy HHmmss
• ddMMyy HHmmss
• yMMdd HHmm
• MMddy HHmm
• ddMMy HHmm
• yyMMdd HHmm
• MMddyy HHmm
• ddMMyy HHmm

where

• y - A full numeric representation of a year, 4 digits
• yy - A two digit representation of a year
• MM - Numeric representation of a month, with leading zeros, 01 through 12
• dd - Day of the month, 2 digits with leading zeros, 01 to 31
• HH - 24-hour format of an hour with leading zeros, 00 through 23
• mm - Minutes with leading zeros, 00 to 59
• ss - Seconds, with leading zeros, 00 through 59

For "Currency", "Number", "Percent", use ICU DecimalFormat (see the Patterns section for complete information) and Tools -> Locale Settings.

For "Date/Time", use ICU Date/Time Format Syntax.

If the string function name is not listed in the dropdown, you can enter your own function name. If the function has one argument only, the argument must be the field value and you only need to enter the function name, e.g. strtolower. If the function has more than one arguments, use {value} to denote that field value, for example, to format a date field by PHP date function, enter:

date(DATE_RFC822, strtotime({value}))

If you want your own functions to be selectable in the dropdown, you can add your function to the following registry:
HKEY_CURRENT_USER\SOFTWARE\PHPMaker\<Version>\Settings\General

e.g. StringFunctions=MyFunction1,MyFunction2

You can put your functions in server side Global Code section, see Server Events and Client Scripts.

Hyperlink

If the HREF field has lookup table or user values, by default the display value will be used. If this option is enabled, the original field value will be used instead.

For example, you can enter: (no quotes)

mypage?id=

The value of the HREF field will be appended to the end of the your prefix in the outputted HTML.

If you want pass a field value, you can enter: (no quotes)

mypage?myfield={$this->urlEncode($this->MyField->CurrentValue)}&id=

If you need to pass parameters which should not be URL-encoded, for example, if you use Encrypt() to encrypt your parameter, you can enter: (no quotes)

mypage?myfield={$this->raw(Encrypt($this->MyField->CurrentValue))}&id=

For example, you can enter: (no quotes)

&field2={$this->urlEncode($this->Field2->CurrentValue)}

For example, you can enter a string, e.g. (string with single/double quotes)

"rel='xxx'"

or preferably as array, e.g.

["rel" => "xxx"]

Tooltip

By default the width is not specified and the width will depend on the field value. However, when the tooltip field is a long text field, the width can take up the browser width, which may be unwanted. Then you can specify a value to limit the width.

Custom View Tag

There are some ready-to-use Custom View Tag for you to choose:

• Google Maps
• Barcode and QR code
• YouTube videos

If your data stores information for above, just click the down arrow button to open the setup form, enable one of them, read the notes at the bottom panel carefully, then click the Settings tab to setup, and click OK to save your settings.

You can create your Custom View Tag, they are implemented in exactly the same way as extensions.

If your code is simple and you don't bother creating a Custom View Tag for reuse, you can enter your code directly. Click the [...] button to enter your own code to display the your data in your own PHP, HTML and JavaScript.

Custom View Tag is HTML, if you want to embed PHP code, use <?php and ?>, if you want to use JavaScript, use <script> and </script>.

The above tags are just some helper tags, you can write your own Custom View Tag without using them at all.

Example

Output the field value conditionally:

Example

Output a custom link:

"onmouseover='my_js_function();' onmouseout='my_js_function2();'"

or

["onmouseover" => "my_js_function();", "onmouseout" => "my_js_function2();"]

Custom Edit Tag

To use Custom Edit Tag, click the down arrow button to open the setup form, enable one of them, read the notes at the bottom panel carefully, then click the Settings tab to setup, and click OK to save your settings.

You can create your own Custom Edit Tag, they are implemented in exactly the same way as extensions.

If your code is simple and you don't bother creating a Custom Edit Tag for reuse, you can enter your code directly. Click the [...] button to enter your own code to display the your data in your own PHP, HTML, CSS and JavaScript. You can enter JavaScript and stylesheet paths under Tools -> Scripts & Stylesheets. Note that the paths are global for the whole project, not just for a field, you'll see JavaScript and stylesheet paths required by other fields.

Custom Edit Tag is HTML and PHP, if you want to embed PHP code, use <?php and ?>, if you want to use JavaScript, use <script> and </script>.

{{{old_tag}}}

• **Assert** (see section below)
• Integer
• Float
• Range - for validating a range of number
• Date - for validating date with or without time
• Time - for validating time with or without seconds
• Credit card
• GUID
• US Phone Number
• US Zip Code
• Email
• US SSN (social security number)
• Regular Expression
• URL

If the Validate setting (see above) is Regular Expression, this setting must be a valid JavaScript regular expression pattern along with flags that identify how to apply the pattern (delimit the pattern by "/" characters, not single or double quotes), e.g.

/foobar/i

See Creating a Regular Expression for more information about the pattern and flags.

If Regular Expression, arguments must be the pattern to search for, as a single or double quoted string, e.g.

'/foobar/i'

See PHP function preg_match for more information about the pattern.

The value must be a valid PHP expression. (If it is a string, must be single or double quoted.)

If a field is selected, it will be included in the Multi-Update page. In the generated Multi-Update page, there is a checkbox for each field, the field will only be updated if the checkbox is checked so users can update only the checked fields without affecting values of the other unchecked fields.

The value must be a valid PHP expression. (If it is a string, must be single or double quoted.)

The value must be a valid PHP expression. (If it is a string, must be single or double quoted.)

The value must be a valid PHP expression. (If it is a string, must be single or double quoted.)

The value must be a valid PHP expression. (If it is a string, must be single or double quoted.)