Google-forms – Show quiz result on the same page in Google Forms

google-forms

Google Forms allows to create questionnaire and make it like a quiz in order to get score to correct answers.

I created a quiz in Google Forms but after submitting answers to all questions it shows a button "View score", after clicking on it shows quiz result on a new page. How to make it open quiz scores on the same page? Any guess?

Here is a link to my sample quiz.

Best Answer

I was going to comment on your question or message you but I don't have enough reputation to do that. The questionnaire you created is set as a "quiz" where it has default settings by Google and you can't change it nor redirect your page on form submit. However Google has a way for you to customize or add features to your form and that is using google app script.

https://developers.google.com/apps-script/reference/forms/

Related Solutions

Google Forms – How to Change Default Text on Submit Button

The short answer is: You can't do that using Google's form builder.

The longer answer is that you can copy the form's HTML code and host it on your own website. That HTML code may then be modified to have the button display any text you'd like.
Copying and hosting the HTML code does have its drawbacks. If you edit the form from Google's form builder, the copied HTML code will of course not be updated, so you'd have to copy and mofiy it again.

See this article from ohdoylerules.com for how to copy and host the HTML code. Note that in this article, they are using Google Drive to host their customised HTML. That feature is not available in new Google Drive, so you will have to host your HTML somewhere else.

I have created a demo form here: http://vvv.vidarramdal.com/stackoverflow/webapps-66392/

I have searched the online lots for the answer to my question and several 
times the setText('text button') function has been mentioned. From what I can 
see this only applies to the these more complex customised forms. If that's 
not correct ...

No, you are correct.

Google-sheets – Google Forms Quiz Response Sheet

You could try using an ARRAY FUNCTION I haven't tried it for this use case at the moment but i have used it in a situation which uses the .appendRow() function which I'm pretty sure the form response uses hence why your formula isn't present. Instead of dragging down your formula:

Save it as an ARRAY Formula by holding CTRL while pressing enter to input the formula into the cell on the first Row you need it
Then copy that cell with CTRL+P
Using your Arrow Keys press down once to highlight the cell below
Then hold CTRL+SHIFT and press the down Arrow key. (assuming you're in an empty column that should have highlighted the remaining rows of that column in that sheet. If not keep pressing down till you reach as far as you want to accept responses. NOTE: this is not a good scenario to have. The form response sheet should be left alone as much as possible to ensure consistent behavior....current instructions not included of course)
press CTRL+V or CTRL+V to paste in the remaining portion of the array Formula This should now calculate the added row.

If not I would use something like =COUNTUNIQUE(FORM_RESPONSES!H2:H) in a separate sheet which should return the number of unique values in the entire H column. Or you could open the Script editor in the tools menu and try your hand at some javascript. Which could then even write an email and autom fill a templated word doc for you based on the conditions you mentioned.

I highly recommend that option as automation rewards you with time, and coding is a lot of fun and easier than you may think.

Use developers.google.com/sheets to learn more about Apps Script and to find a scenario or tutorial for most levels of skill including beginner

Best Answer

Related Solutions

Google Forms – How to Change Default Text on Submit Button

Google-sheets – Google Forms Quiz Response Sheet

Related Topic