FormAnswer

a formanswer represents a single question's answer extracted from a form submission it is the return type of the findanswers family of cql functions unlike formresponse docid\ lihl9i6dr0einbnndg2ec , which represents an entire form submission with all its answers, a formanswer is focused on one specific question — making it easy to aggregate or analyze a single field across many submissions properties property type description answervalue @any the value given for this question the type depends on the question — for example, a numeric rating question returns a number, a text question returns a string assessmentid string docid\ ujw2aqaktel5uuklup73s the id of the assessment cycle this response was part of, or null if the submission was not associated with an assessment formid string docid\ ujw2aqaktel5uuklup73s the id of the form the answer came from formresponseid string docid\ ujw2aqaktel5uuklup73s the id of the parent formresponse docid\ lihl9i6dr0einbnndg2ec this answer belongs to questionid string docid\ ujw2aqaktel5uuklup73s the id of the question this answer is for submitat timestamp docid\ j1ufztc3 yprdi3ucin3u the timestamp the form was submitted submitperson person docid\ bzrx1mtdjk8cgkaw7ujqj the person who submitted the form, or null if anonymous target person docid\ bzrx1mtdjk8cgkaw7ujqj the person the form was about (the target), or null if the form had no target usage notes formanswer is designed for aggregation the most common pattern is to chain it with mean{} , count() , or groupby{} to derive insights from a specific question across many responses the answervalue property holds the raw answer value for numeric questions (ratings, scores), you can use mean{answervalue} directly for enum/label questions, use groupby{answervalue} count() to see the distribution examples findanswers('managerreviewrating', ' 365d') mean{answervalue} average manager review rating across the org over the past year findanswersbyassessment('managerreviewrating', 'q3 2024 performance review') groupby{target department} mean{answervalue} average manager review rating per department within a specific assessment cycle findanswersbytarget('peerfeedbackimpactrating', person, ' 180d') count() number of peer feedback impact ratings submitted about the current person in the past 6 months see also formresponse docid\ lihl9i6dr0einbnndg2ec — the full form submission object findanswers() — retrieve answers for a question across the org findanswersbyform() — scope answers to a specific form findanswersbyassessment() — scope answers to a specific assessment cycle findanswersbytarget() — scope answers about a specific person