|
You can format field values by adding php code.
Input value is stored in the variable $value. Output value is
assigned to the same variable $value. You can access other fields
of the same data record as $data["FieldName"].
Examples:
1. Convert a string into the upper case.
PHP code:
$value = strtoupper($value);
|
2. Format 10-digit phone number into the following format (xxx)
xxx-xxx .
PHP code:
if (strlen($value)==10)
{
$value="(" . substr($value,0,3) . ") " . substr($value,3,3) . "-" . substr($value,6);
}
|
3. Display value of field FirstName as "<FirstName>
<LastName>" (if LastName field defined).
PHP code:
global $data;
if ($data["LastName"])
$value = $value." ".$data["LastName"];
|
4. Display a number in black color if number is positive and red
font if number is negative.
PHP code:
if ($value>0)
$color="black";
else
$color="red";
$value="<font color='$color'>$value</font>";
|
5. Display a field containing email address as email hyperlink
(mailto function used).
The value of subject in mailto function is set to a value of
another field.
PHP code:
$value = "<a href='mailto:".$value."?subject=".$data["SubjectField"]."'>Send email</a>";
|
|
