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 calculated 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 > 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 to Google Sheets
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. 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. The first column in the sheets includes a unique id used by Formfacade for updating the responses and this column will be locked.
Comments (2)
Jul 2, 2024
or can we create our own google sheets and link the answer?
Jul 2, 2024
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 calculated 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 > 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 to Google Sheets 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. 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. The first column in the sheets includes a unique id used by Formfacade for updating the responses and this column will be locked.
Add your comment
Add photo