Google Form: send score and answers for multiple choice tests

[Seabee2127]

Hello, this looks cool I wish it would work for me. :-( Everything is fine until I add mcq. Which in your video at the 52 sec mark magically make a setup & results sheet for you. It didn't do that for me nor did I have to authorize anything. Tried the trigger thing don't work either. Please help.

[romainvialard]

@Seabee2127

Can you open a new thread on the Google Apps Script help forum ?

[MrLeecoolscience]

Hi, I've tried this over and over again and I cannot get the script to work. Do you have a new script or do you know why it isn't working. I set up a quiz just like yours followed your steps to the tea... doesn't work.. would love to figure this out. Thanks??

[romainvialard]

@MrLeecoolscience

Can you open a new thread on the Google Apps Script help forum ?

It will be easier to help you there.

[DOCTORSALSA1]

Sorry, it didn't work for me - I tried it with my original long quiz and then shorter simple ones. It does not send an email with the results as promised. Is there anywhere I can look for a solution?

[gigabyte0889]

Does not work for long quizzes :(

Else really great work Romain. Genial :)

[romainvialard]

@gigabyte0889

I know and I'm working with Google to make it work :)

[dosaparks1]

This looks awesome and I would love to set it up on my quiz but after following the instructions I am finding that there is no results being posted or no email being sent.

After submission it shows a timestamp in column A but nothing in cols B & C on the 'Setup & Results' page.

I noticed on the video you only had cols A and B active but I have col C too for some reason.

Any idea why it doesn't show the results? I created a youtube account just to ask as it looks great.

[romainvialard]

@dosaparks1

Hi,

Could you open a new thread on the google apps script help forum ?

It will be easier to help you there :)

[dosaparks1]

@romainvialard

Okay. I think I have done this. What you've done in the video is great so hopefully I can work it out. Appreciate your time on this one.

[dosaparks1]

@romainvialard

Okay. I think I have done this. What you've done in the video is great so hopefully I can work it out. Appreciate your time on this one. Looks like I can't post the link here so I'll try to get it through to you another way

[sanglei]

i can't find the script. :(

[romainvialard]

@sanglei

Sorry about that, I'll ask the Google Apps Script team to fix it

[sanglei]

@romainvialard thanks. i really need it and i'm not that good in excel/ google docs

[romainvialard]

@sanglei

It's available again :)

[sanglei]

@romainvialard THANK YOU VERY MUCH. :) i can now start with my project, :) i really should update myself with stuffs like this. good thing there are smart people like you. :)

[hkstevenchan]

That's what I have been looking for.

Thanks a lot.

[MrsForsberg]

Any word on when this is going to be available? I have a test on Thursday!haha

[romainvialard]

Hi, sorry for the delay, it's available again.

[Bear3bear1]

Are you allowed to use only multiple choice questions for this script? What about grid or check boxes? Are those allowed and will it still work?

[romainvialard]

@Bear3bear1

Yes, it should still work

[romainvialard]

Link to the script (if you can't find it in the gallery):

docs.google.com/document/d/1mA­E86cstODElOc7rUAvrH7-MMNbqbzyq­Q4e60Z7u7rk/edit#

(you'll need to copy / past it in the script editor, and trigger the function 'setup' to create the sheet 'Setup & Results')

[TurnOneOver]

This is incredible...thanks! I'll keep an eye out for this one!!!

[TurnOneOver]

Hi, do you still have this scrpipt available?

[romainvialard]

@TurnOneOver

Hi,

I've made a small update on the script and Google hasn't reviewed it yet.

Sadly, when you submit a new version, the older one is no longer available in the gallery. So, you just have to wait.