findResponses()

returns form responses for a particular form submitted over a period of time syntax findresponses(form\[, from]\[, until]) parameters true false 166,127false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type return type list docid\ xwh cukhj9waqaefb7h71 < formresponse docid\ lihl9i6dr0einbnndg2ec > examples 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