Create a custom Date field that captures the date when a defect is closed

Question ID: 109747
1
1

Hello. We have created a separate status field for reporting purposes, that will be manually populated by our end users. When the user populates the custom status field with the value “Closed”, we would like for the ‘Closing Date’ field to auto-populate with the date that the custom field was populated. Is there a way to customize this? Any help is appreciated.

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on July 31, 2020 11:58 am
2 views
Answers (1)
1
Private answer

Hello. I believe the workflow script below will provide you with the results you are looking for. You will need to place the block of script below into Bug_FieldChange within the Defects module script in the Script Editor. You will then need to replace the value 'BG_USER_01' in the script below, with the name of your custom status field. We recommend testing this in your test environment before using it in your production environment.

 

If FieldName = "BG_USER_01" Then

If Bug_Fields.Field("BG_USER_01").Value = "Closed" Then

Bug_Fields.Field("BG_CLOSING_DATE").Value = Now

Else Bug_Fields.Field("BG_CLOSING_DATE").Value = " "

End If

End If

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on July 31, 2020 12:00 pm