Chapter 6 · Responses

Reports

Analyze form responses in Formfacade Reports: built-in reports, custom columns and layouts, export to CSV/PDF, weekly/monthly/yearly views, and syncing to a dedicated Google Sheet.

Quick Answer

How do I report on responses in Formfacade?

Open the Responses tab and pick a report from its view menu for a spreadsheet-style view of your responses. Use the built-in reports (Google Sheets, Responses by status, Responses by email, Traffic source), switch the date range or layout, and edit a report with the pencil to pick columns and organize it as a table, nested table, or matrix. Export to CSV/PDF, or click Link to Sheets to send every response to a Google Sheet.

Where the Responses board is for managing submissions, Reports is for analyzing them, a spreadsheet-style view you can filter, reshape, and export. Both live in the Responses tab.

The built-in reports

Open Responses and pick a report from the view menu at the top. There are four ready-made reports (plus ⊕ New report to add your own):

ReportWhat it shows
Google SheetsEvery response in a table: id, date, status, and your form fields
Responses by statusResponses grouped by their status
Responses by emailResponses grouped by respondent email
Traffic sourceWhere your responses came from
1 Google Sheets, a spreadsheet-style view of your responses, 2 the other built-in reports, and 3 New report.

Working with a report

Every report has a toolbar in the top-right:

  • Link to Sheets (Google Sheets report): send every response to a Google Sheet (see below).
  • Date range: page through periods with ‹ Aug 9 – Aug 15 ›.
  • View toggle: switch between the standard columns view and Columns to rows (which transposes fields into rows).
  • Search: find values in the report.
  • Pencil: edit the report (see below).
1 Link to Sheets, 2 date range, 3 view toggle, 4 search, 5 edit, 6 more options.

Export, format & more (the ⋮ menu)

The three-dot menu holds the export and formatting actions:

ActionWhat it does
Export to CSVDownload the report as a CSV file
Download as PDFDownload the report as a PDF
Show/Hide columnsChoose which columns appear
Conditional formattingColor-code cells by rules
Add collaboratorShare the report with someone
Make a copyDuplicate the report
Switch to Weekly / Monthly / YearlyChange the reporting period
Export, format, share, or switch the reporting period from the ⋮ menu.

Create or edit a report

Click the pencil to edit a report, or ⊕ New report to build one from scratch. Either opens a short wizard:

Name & reporting period

Give the report a name and pick a reporting period: Auto [Recommended], Weekly, Monthly, or Yearly. Expand More options to include abandoned responses.

Customize columns

Choose which column groups to include: Summary, Other details, Submitted from, and Calculated columns. Expand each to pick individual fields.

Pick exactly which columns the report shows.

Organize & finish

Choose how to lay it out (Table, Nested table, or Matrix), then click Finish.

1 Organize the report as a table, nested table, or matrix, then 2 click Finish.

Sync to a dedicated Google Sheet

On the Google Sheets report, click Link to Sheets to send every response to a Google Sheet. The first time, this creates a dedicated Google Sheet for reporting. It comes with two tabs, Responses and Response Statuses, for a fuller view of your data.

A dedicated reporting sheet with Responses and Response Statuses tabs.

Note

This is separate from linking the underlying Google Form to a sheet (see Google Forms and Sheets). It's a reporting-focused sheet Formfacade builds from your responses.

Next steps