Hi - You can use the Scorecery addon to assign points and add score calculations. Once you have setup your form, you must use the Scorecery share link to collect responses. When the user fills the form and submits, the response is recorded in Scorecery and Google Forms. You can sync Google Forms responses to Google Sheets. This will include the answers for the questions in the form including the total score if you have set up your form to record it in Google Forms.
Export responses to Google Sheets
There are two options. (1) Sync Google Forms responses to Google Sheets (2) Export points and responses data from Scorecery reports
1. 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.
2. Export points and responses data from Scorecery reports
Login to Scorecery > 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
If you need the individual points for each question, then you can export the data from Scorecery.
Comments (1)
Mar 3, 2024
Hi - You can use the Scorecery addon to assign points and add score calculations. Once you have setup your form, you must use the Scorecery share link to collect responses. When the user fills the form and submits, the response is recorded in Scorecery and Google Forms. You can sync Google Forms responses to Google Sheets. This will include the answers for the questions in the form including the total score if you have set up your form to record it in Google Forms. Export responses to Google Sheets There are two options. (1) Sync Google Forms responses to Google Sheets (2) Export points and responses data from Scorecery reports 1. 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. 2. Export points and responses data from Scorecery reports Login to Scorecery > 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 If you need the individual points for each question, then you can export the data from Scorecery.
Add your comment
Add photo