Community

im not able to get assigned score rep[orts based on the \responses.

Comments (1)

Vipin

Sep 23, 2024

Hi Gopinath, You have setup your form to record the total score. When the user submits the form, the responses including the calculated score will be recorded in Formfacade Responses page as well as 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 total score. If you need the points for individual questions, then you can export the 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 Formfacade. 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