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 string docid\ ujw2aqaktel5uuklup73s name or id of the question/field to retrieve answers for form string docid\ ujw2aqaktel5uuklup73s name or id of the form assessment string docid\ ujw2aqaktel5uuklup73s name or id of the assessment cycle from timestamp docid\ j1ufztc3 yprdi3ucin3u starting point of the date range to traverse (inclusive) until timestamp docid\ j1ufztc3 yprdi3ucin3u ending point of the date range to traverse (exclusive) return type list docid\ xwh cukhj9waqaefb7h71 < formanswer docid\ pjyhwzhyk83aoscqv k6l > 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