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):
| Report | What it shows |
|---|---|
| Google Sheets | Every response in a table: id, date, status, and your form fields |
| Responses by status | Responses grouped by their status |
| Responses by email | Responses grouped by respondent email |
| Traffic source | Where your responses came from |
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).
Export, format & more (the ⋮ menu)
The three-dot menu holds the export and formatting actions:
| Action | What it does |
|---|---|
| Export to CSV | Download the report as a CSV file |
| Download as PDF | Download the report as a PDF |
| Show/Hide columns | Choose which columns appear |
| Conditional formatting | Color-code cells by rules |
| Add collaborator | Share the report with someone |
| Make a copy | Duplicate the report |
| Switch to Weekly / Monthly / Yearly | Change the reporting period |
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.
Organize & finish
Choose how to lay it out (Table, Nested table, or Matrix), then 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.
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
- Manage submissions as a pipeline on the Responses board.
- Automate follow-ups with Email Responses.