findResponses()

Returns form responses for a particular form submitted over a period of time.

findResponses(form[, from][, until])

List <FormResponse >

findResponses('1:1 Form', '-30d').count()

Returns the number of form responses that have been submitted in the past 30 days.

findResponses('Manager Review', '2024-01-01', '2025-01-01').mean{answerValue.reviewScore}

Returns the average review score of all submissions of the Manager Review form submitted in calendar year 2024.

findResponses('Shoutout', intervalFrom, intervalUntil).groupBy{submitPerson}.count()

In a Dashboard, return the top submitters of the Shoutout form.

findResponses('Shoutout', intervalFrom, intervalUntil).groupBy{target}.count()

In a Dashboard, return the top recipients of the Shoutout form.