findAnswersByForm()

Returns individual form answers for a specific question, scoped to a specific form, optionally filtered by date range.

This is useful when the same question name exists on multiple forms and you need to disambiguate — or when you want to analyze answers from one particular form only.

Syntax

findAnswersByForm(question, form[, 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
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

findAnswersByForm('reviewScore', 'Manager Review', '-365d').mean{answerValue}

Returns the average reviewScore answer submitted via the Manager Review form in the past year.

findAnswersByForm('oooRating', '1:1 Notes', intervalFrom, intervalUntil).groupBy{submitPerson}.mean{answerValue}

In a Dashboard, breaks down average 1:1 self-ratings by person, scoped to the 1:1 Notes form only.

Note

If the question is only used on one form, findAnswers() and findAnswersByForm() will produce the same result. Use findAnswersByForm() when disambiguation is needed.