To post a comment, please sign in with your email.
Dear Formfacade Team, Thank you for your effort in developing these calculation features in Google Forms. Currently, I'm using Formfacade to modify my Google Form questionnaire and assign value points for survey purposes. However, there are a few issues along the way that I'd like to ask: 1. When I tried to assign SCORE to calculate all the sum points of assigned values of a section - the SCORE value came up on the Formfacade website, but not on the Google Form website. The score values resulting from the answer I inputted in the Formfacade website can be found on Google Form Responses, along with the Excel sheets exported from Google Form. Interestingly, if I input the answer in Google Forms, the score values were not on display, even after submission. Are the score values only exclusively available on the Formfacade website? Or is it a matter of a failure of settings/ glitch in the system? I would like to see the scores on the Google Forms website. Can we work around this, or does this mean to use this calculation feature, I have to subscribe to Formfacade and use the questionnaire only on the Formfacade website? 2. As I am trying the questionnaire I modified in Formfacade myself, I have made several attempts to fill out the questionnaire to test for glitches. On the Formfacade's Responses Page, I'm trying to delete the practice submissions, yet I could not seem to delete them. They appeared in the Abandoned section and even if I clicked the delete button, they're still there. These practice submissions also cannot be moved to Trash. Even on Trash, they cannot be deleted as well. I'm concerned about the confusion of data cleaning if I cannot seem to delete a failed entry/ dirty data. Is there any way to delete these dirty data permanently? 3. When I tried to export the questionnaire results from Formfacade's website, there were many error messages. It said the sheets failed to sync. But when I looked at the downloaded sheets, I saw that they actually contained the submission reports, even the submitted and the trash ones. Is there any way to download only the submitted results and not the trashed ones? I'm looking forward to your reply. Thank you very much. Best, Prieska
Asked by Prieska Dinda Astriena
Jul 24, 2024
All Replies (1)
Vipin
Jul 24, 2024
Score calculations
Google Forms does not have the option to assign different points for answer choices and calculate scores. You will have to use the Formfacade - Assign points addon to add score calculations in your google form. Please note that you must use the Formfacade share link or the embed code to collect responses. Otherwise, customization and score calculations will not work. When you use the Formfacade link, the responses will be recorded in Formfacade and Google Forms. You can sync google forms responses to google sheets as well.
Score calculations is a paid feature. You must subscribe to the paid plan to use it after the trial ends. For pricing detials, refer to the links below.
Formfacade - Assign points pricing
https://formfacade.com/calculate/pricing.html
Formfacade - Enhance pricing
https://formfacade.com/enhance/pricing.html
Delete abandoned responses
You cannot change the status of the abandoned responses, but you can delete them. Please note that you will not be able to delete the responses created in the last 48 hours.
Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the three dots more icon next to the Abandoned status > click Delete All > select All responses and click Confirm. This will delete all responses created before 48 hrs.
Delete responses
You can move redundant responses to Trash status. These responses will not be included in the Reports. If the Strict privacy is enabled, these responses will be permanently deleted after 7 days.
Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, you can drag and drop (place the cursor on the profile image/default icon to drag) responses to the Trash status or click on an response to view the details, select the Trash status for the Move to option and click Submit. When you move a response to the Trash status, any uploaded files will be deleted. Once deleted, you cannot access these files.
Enable Strict Privacy to delete responses
You can enable the privacy option to delete the responses in Abandoned and Trash status permanently. Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the three dots next to the Abandoned or Trash status > You can enable the privacy settings and click Save. When enabled, the responses in Abandoned and Trash status will be automatically deleted after 7 days. Please note that the Abandoned status will be hidden when the Privacy option is enabled.
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 total score if you have set up your form to record it in Google Forms.
Sync Google Forms 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 Scorecery 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 all the responses will be synced to Sheets.
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.
Click to add files
Related Questions
See related queries.