I have a list with two columns. One is a dropdownvalue and the other a date field. Whenever i change a value in the dropdown the current date has to be updated in the date field.
Example: The status field has dropdown values: open,hold and closed. Initially the value would be open and if it is changed to hold or closed, the current date should be updated in the column "status modified date" field. Also the "status modified date"
should be a protected field and the users should not be able to change the date in it.