Export responses
When the user fills the form and submits, the response is recorded in Formfacade and Google Forms. You can sync Google Forms responses to Google Sheets. This will only include the answers for the questions in the form including the score if you have set up your form to record it in Google Forms.
Sync responses to Google Sheets
Open your form in Google Forms, click Responses and click on the spreadsheet icon to sync responses to Google Sheets. All the fields in the form are included as columns and each row is a response.
Export points and responses data from Formfacade reports
Login to Formfacade > click on the form to open it > Edit page will be displayed > click Reports > click on the Export button in the bottom right corner. Please note that the responses will be synced to Sheets only when you click on the Export button in Scorecery.
There will be three tabs in the Google Sheets (1) Responses - Shows the answers for all the questions in the form (2) Scores - Shows the points for individual questions along with the answers for other form fields (3) Q & A - You can use pivot table to analyse the data and create aggregate reports.
Comments (1)
Aug 8, 2024
Export responses When the user fills the form and submits, the response is recorded in Formfacade and Google Forms. You can sync Google Forms responses to Google Sheets. This will only include the answers for the questions in the form including the score if you have set up your form to record it in Google Forms. Sync responses to Google Sheets Open your form in Google Forms, click Responses and click on the spreadsheet icon to sync responses to Google Sheets. All the fields in the form are included as columns and each row is a response. Export points and responses data from Formfacade reports Login to Formfacade > click on the form to open it > Edit page will be displayed > click Reports > click on the Export button in the bottom right corner. Please note that the responses will be synced to Sheets only when you click on the Export button in Scorecery. There will be three tabs in the Google Sheets (1) Responses - Shows the answers for all the questions in the form (2) Scores - Shows the points for individual questions along with the answers for other form fields (3) Q & A - You can use pivot table to analyse the data and create aggregate reports.
Add your comment
Add photo