nuBuilder Forum

Code: Select all

// If the Access Level Code does not equal to "Management", disable "my_field":
if (nuAccessLevelCode() != 'Management') {
	nuDisable('my_field');
}

Code: Select all

// The function dbGetValue() retrieves the original value from the table, before the record is saved
function dbGetValue($tableName, $primaryKey, $recordId, $columnName) {
	$select = "SELECT `$columnName` FROM `$tableName` WHERE `$primaryKey` = ?";
	$result = nuRunQuery($select, array($recordId));
	$arr = db_fetch_array($result);
	return $arr[$columnName];
}

// Replace my_table with your table name, my_table_primary_key with your table's primary key and my_field with your object id.
$orgValue = dbGetValue('my_table', 'my_table_primary_key', '#RECORD_ID#', 'my_field');
$newValue ='#my_field#';

// Compare the original value with the new value and disallow saving, if the field has been changed/manipulated by an Access Level code other than "Management".

if ($orgValue != '#my_field#' && '#ACCESS_LEVEL_CODE#' !== 'Management') {
   nuDisplayError('It is not permitted to modify the field xyz...');
}