Allows you to modify default input values when editing records
Default:
This is similar to powerLens, but for input fields when editing or creating new records. See also defaultLens to modify default input values when creating records.
Read Only Fields
When you use powerEditLens with readonly fields, the fields would be updated when the user clicks on the save button. For example this field RO:
$lens->powerEditLens = 'RO^=strtoupper({RO})';
$lens->readOnlyLens = 'RO';
would be readonly on the screen, but when you save, the upper-cased data would be updated in the database.
To prevent this from happening, in 2.7.0 and later, we add a new modifier, !! (double-exclamation mark):
$lens->powerEditLens = 'RO^!!=strtoupper({RO})';
$lens->readOnlyLens = 'RO';
Then the field RO will not be updated in the database when the user clicks on Save.Syntax
#uppercase text of field col1
$lens->powerEditLens = 'col1^=strtoupper({col1})'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.2]
|