Requirement: When you select a value in the A field, set the list value of the B field to read different list values according to the value of the A field, such as when the value of the running province has changed, the selection list of the running region will change.
Create a new function Userfuntion_bug_projectarea in the Script Editor and write the following script:
Sub Userfuntion_bug_projectarea
Select Case Bug_fields ("Bg_user_15"). Value
Case "01. Guangdong"
Bug_fields ("Bg_user_13"). List = Lists ("Guangdong area List")
Case "02. Jiangsu"
Bug_fields ("Bg_user_13"). List = Lists ("Jiangsu area List")
Case "03. Zhejiang"
Bug_fields ("Bg_user_13"). List = Lists ("Zhejiang area List")
Case "04. Jiangxi"
Bug_fields ("Bg_user_13"). List = Lists ("Jiangxi Area List")
Case "05. Guangxi"
Bug_fields ("Bg_user_13"). List = Lists ("Guangxi area List")
Case "06. Fujian"
Bug_fields ("Bg_user_13"). List = Lists ("Fujian region list")
Case "07. Sichuan"
Bug_fields ("Bg_user_13"). List = Lists ("Sichuan region list")
Case "08. Guizhou"
Bug_fields ("Bg_user_13"). List = Lists ("Guizhou area List")
Case "09. Hubei"
Bug_fields ("Bg_user_13"). List = Lists ("Hubei area List")
Case "10. Hunan"
Bug_fields ("Bg_user_13"). List = Lists ("Hunan Area List")
Case "11. Anhui"
Bug_fields ("Bg_user_13"). List = Lists ("Anhui area List")
Case "12. Hebei"
Bug_fields ("Bg_user_13"). List = Lists ("Hebei area List")
Case "13. Henan"
Bug_fields ("Bg_user_13"). List = Lists ("List of Henan regions")
Case "14. Inner Mongolia"
Bug_fields ("Bg_user_13"). List = Lists ("Inner Mongolia area list")
Case "15. Gansu"
Bug_fields ("Bg_user_13"). List = Lists ("Gansu area List")
Case Else
Bug_fields ("Bg_user_13"). List = Lists ("Gansu area List")
End Select
End Sub
Note: Since this function needs to be referenced when a bug field is sent, you need to include a reference in the Defects_bug_fieldchange function:
Sub Defects_bug_fieldchange (FieldName)
Userfuntion_bug_projectarea
End Sub
The above is just a list of one example and usage, do not enumerate all the usage, I hope you can extrapolate.
[Qualitycenter] Set workflow script-set different field values to associate different lists