I am trying to write some code that will prevent standard QA testers from setting a defect severity to "Show Stopper". I am able to use the console to prevent them from doing this when editing a bug however preventing it on a new bug seems to be a little more difficult.
I tried writing the following code but it does not seem to work:
If Bug_Fields("BG_SEVERITY").IsModified = "True" then
If Bug_Fields("BG_SEVERITY").Value = "4-ShowStopper" then
Bug_FieldChange("BG_SEVERITY") = False
Do you guys have any advice on how I would go about doing this?
Sub Defects_Bug_FieldCanChange(FieldName, NewValue)
On Error Resume Next
Defects_Bug_FieldCanChange = Project_DefaultRes
Select Case FieldName
If User.IsIngroup("QA Tester") Then
If Newvalue = "4-ShowStopper" Then
Defects_Bug_FieldCanChange = False
MsgBox "Use of '4-ShowStopper' has been restricted", vbOKOnly+vbExclamation, "Admin Message"