findAnswersByFormAssessment()
Returns individual form answers for a specific question, scoped to both a specific form and a specific assessment cycle, optionally filtered by date range.
This is the most targeted of the findAnswers* functions — useful when the same question label appears on multiple forms across multiple cycles and you need to pin down exactly which form and cycle you want.
Syntax
findAnswersByFormAssessment(question, form, assessment[, from][, until])
Parameters
Parameter | Type | Description |
|---|---|---|
question | StringString | Name or ID of the question/field to retrieve answers for |
form | StringString | Name or ID of the form |
assessment | StringString | Name or ID of the assessment cycle |
from | TimestampTimestamp | Starting point of the date range to traverse (inclusive) |
until | TimestampTimestamp | Ending point of the date range to traverse (exclusive) |
Return Type
ListList <FormAnswerFormAnswer>
Examples
findAnswersByFormAssessment('reviewScore', 'Manager Review', 'Q3 2024 Performance Review').mean{answerValue}
Returns the average reviewScore from the Manager Review form specifically within the Q3 2024 cycle.
findAnswersByFormAssessment('reviewScore', 'Manager Review', 'Q3 2024 Performance Review').groupBy{target.department}.mean{answerValue}
Breaks down the average review score by department, scoped to a specific form and assessment cycle.
Note
Use this function when you need both form and assessment scoping simultaneously. If you only need one of those constraints, findAnswersByForm() or findAnswersByAssessment() will be simpler.