drop down issue

[Amin.Ahmed]

helloo

FormRanger is not populating my drop down list options into the google form question.  I've checked my Google Sheet for duplicates, and there are not any duplicate answer choices listed.  Any troubleshooting tips?

[Joseph Schmidt]

I suspect duplicates or you have more than 999 entries.

Add a column and put =COUNTIF($A$1:$A,A2) Adjust to the correct column. Put the formula in all rows. Any that have anything greater than one are duplicates.

You can easily set a filter to show the duplicates.

See the not in the description of the group.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Mon, Jan 8, 2024 at 10:10 AM 'Amin.Ahmed' via NV Form Ranger Add-on <nv-form-ra...@googlegroups.com> wrote:

helloo

FormRanger is not populating my drop down list options into the google form question.  I've checked my Google Sheet for duplicates, and there are not any duplicate answer choices listed.  Any troubleshooting tips?

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/7eb08659-7a00-4c90-b54e-c951d2153be9n%40googlegroups.com.

[David & Pan Knapp Karaket]

Hi! 

I'm going to use Form Ranger to create very short choice quizzes for a student — hoping to spend no more than 10 minutes a day on the quizzes once I have a Google sheet populated with multiple choices.

The questions will be generic – "Which of these sentences Is correct," and so on. I don't want the correct answer always to be in the same position, and I also don't want to spend time choosing it manually. Is there any way to do this with Form Ranger, or maybe Form Ranger and a bit of Google app script?

Thanks!

[Joseph Schmidt]

Hmm!  This is a new question.

You can have Google Shuffle option order.

How are you going to grade the quiz?  I don't think you will be able to set up a Google quiz with the options being changed by FormRanger.

I would definitely experiment on a small scale before I put much effort into it.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/CAD%2BNrfB6fzOAtw%2Bxe1EeNbZwG%2BZSWbyUE5sxe9F%3DpSEGiykMZg%40mail.gmail.com.

[David & Pan Knapp Karaket]

Thanks! I suspect it will be hard to make this work as a quiz, but I just realized I can use the Google app script onFormSubmit() function to generate a feedback email It is pretty much whatever I like in it — easy to make it much more informative than the built-in quiz feedback. So I'm gonna try that first. If it's of interest, I'll send you anything that works.

David Knapp

David Knapp & Pan Karaket

Pan & David Restaurant,

167 Moo 3 Tha Devawongse
Ko Sichang, Chonburi 20120, Thailand
telephone: 

--> restaurant +66 38 216 629 

--> home +66 38 216 509 

--> mobile +66 83 277 5459

web: http://www.ko-sichang.com/

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/CAPWPTOSMjREA9CG68_EgazFGtr4kpvceV_LORVBx06ta%3Dh7hVQ%40mail.gmail.com.

[Joseph Schmidt]

Have you looked at flubaroo add-on?

It allows feedback.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/CAD%2BNrfBxLgWMd_R%3DbuU7sdSjkk4J1kXzcfTyhXQGL_x5Bf2UvA%40mail.gmail.com.