Make certain data entry fields optional (readonly) based on data entered in an enabler field
Default:
As an example, let's say that you have a field called "Type". When the value of type is "numeric", then we enable data entry for the field "decimal_places". When the value of "Type" is "char", then we enable the field "size" and disable "decimal places".
$lens->optionalCols = "decimal_places^type^numeric;size^type^char";
We can allow multiple values of in field "Type" to enable "decimal_places", such as type=numeric or type=currency.
$lens->optionalCols = "decimal_places^type^numeric^currency";
Currently, the enable field must be of type text/textarea or select (dropdown menu).
If you want to enable a field whenever a non-empty value is entered, use '*':
$lens->optionalCols = "size^type^*";
Lastly, optionalCols is synchronized with mustfill columns. If a mustfill column is disabled, then the mustfill property is also disabled (temporarily).Syntax
$lens->optionalCols = 'optionalCol^enableCol^enableVal1'.
';optCol2^enableCol2^enableVal2^enableVal2a'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 5]
|