You can format field values by adding PHP code.
The input value is stored in the variable value. The output value is assigned to the same variable value. You can access other fields of the same data record as data["FieldName"].
If you chose Lookup wizard in the "Edit as" settings, use value to access the Display field value and data["LinkFieldName"] to access the Link field value.
Examples
1. Convert a string into the upper case:
$value = strtoupper($value);
2. Format a 10-digit phone number into the following format (xxx) xxx-xxx:
if (strlen($value)==10)
{
$value="(" . substr($value,0,3) . ") " . substr($value,3,3) . "-" . substr($value,6);
}
3. Display the value of the field FirstName as <FirstName> <LastName> (if the LastName field defined):
if ($data["LastName"])
$value = $value." ".$data["LastName"];
4. Display a number in black if the number is positive, and in red if the number is negative:
if ($value>0)
$color="black";
else
$color="red";
$value="<font color='$color'>$value</font>";
5. Display a field containing email address as an email hyperlink (mailto function used). The value of subject in mailto function is set to a value of another field:
$value = "<a href='mailto:".$value."?subject=".$data["SubjectField"]."'>Send email</a>";
6. Display a field value in one line (without line breaks):
$value = str_replace(" ", " ",$value);
7. Display all images uploaded via multiupload:
$filesArray = my_json_decode($value);
foreach ($filesArray as $imageFile) {
$imageValue .= "<img alt=\"".htmlspecialchars($imageFile["usrName"])."\" src=\"".htmlspecialchars($imageFile["name"])."\">";
}
$value = $imageValue;
8. Display a phone number as a click-to-call link for mobile browsers:
$value = '<a href="tel:'.$value.'">Call us!</a>';
9. Display a hyperlink to another page passing the field value as a parameter:
$value = "<a href='https://www.mysite.com/reports/sales_rpt.php order_id=invoice_id".$data["invoice_id"]."'>Link</a>";
See also:
•How to create a custom Edit control plugin
