Share this page

# Example: Changing One Field Based on Another Field

This example demonstrates how you can change a field value based on the value entered into another field.

For example, you can cause defects to be assigned to user alex_qc when `UI Suggestion` is typed into the Category field, and to user alice_qc when `Security Issues` is typed.

The example assumes that the user-defined field BG_USER_05 is used to store the category. When the Category field is changed in the Defects module, the BG_RESPONSIBLE field is assigned the appropriate value.

Add the code to the Bug_FieldChange event procedure so that it is triggered when a user changes a field value for a defect.

    Sub Bug_FieldChange(FieldName)
            On Error Resume Next
            If FieldName = "BG_USER_05" then
                Select case Bug_Fields("BG_USER_05").Value
                case "UI Suggestion"
                    Bug_Fields("BG_RESPONSIBLE").value="alex_qc"
                case "Security Issue"
                    Bug_Fields("BG_RESPONSIBLE").value="alice_qc"
                Case Else
                    Bug_Fields("BG_RESPONSIBLE").value="non-assigned"
                End Select
            End If
            PrintError "Bug_FieldChange"
            On Error GoTo 0
    End Sub

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: