findResponses()

returns form responses for a particular form submitted over a period of time syntax findresponses(form\[, from]\[, until]) parameters parameter type description form string docid\ ujw2aqaktel5uuklup73s name or id of the form 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 < 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