Auto-Generated Finding Text
We have several questionnaires where we ask multiple questions for each Control Standard. These are considered "child" questions and do not generate Findings. We then have one "parent" question for each Control Standard that does generate a Finding if any of the "child" questions for that Control Standard has an incorrect answer. We do this in order to reduce the number of Findings that need to be handled for each questionnaire.
The issue is that they want to easily know by looking at the auto-generated Finding which "child" question(s) were answered incorrectly and therefore generated the Finding for the "parent" question.
One idea I had was to create a calculated text field that for each "parent" question would list each of it's "child" questions and the response. I would then add this calculated field to the auto-generated Finding text. My thought was the calculation would look something like this:
IF ([Question Name]="Parent Question 1",
[Child Question 1 Response]
[Child Question 2 Response],
IF ([Question Name]="Parent Question 2",
[Child Question 3 Response]
[Child Question 4 Response]
However, even though I see [Question Name] in the auto-generated Findings Text, it doesn't appear that is something we can use in a calculated field.
Does anyone have any thoughts on how I can accomplish this?
Thank you in advance.
@TerriPoortinga, the [Question Name] isn't really a field but sort of a "mail merge" type of field for the Findings Text and cannot be used anywhere else in Archer.
The Findings Text is really limited to as what you can do with it.