You are viewing limited content. For full access, please sign in.

Question

Question

Random questions in an exam or questionnaire

asked on April 9, 2015 • Show version history

Has anyone done an exam or questionnaire in Forms in which the questions are shown randomly from a list or database?

Could this be done?

0 0

Replies

replied on April 9, 2015

HI Gerardo,

If the look up was generated by a stored procedure, you could return a random set of questions. Have you tried that yet?

-Ben

 

1 0
replied on April 10, 2015

Hi Ben,

No I haven't tried that yet, I didn't even imagined it.

Can you explain me in few words how to do that?

0 0
replied on April 13, 2015

Hi there,

Stored procedure allows you to Select n random rows from a SQL Server table.

An example from Stack Overflow http://stackoverflow.com/questions/848872/select-n-random-rows-from-sql-server-table

 

 

1 0
replied on November 14, 2018

Is there a way to do this within Forms without the use of a database?  Example, I have 100 multiple choice questions and only want 20 random questions of the 100 to show and be answered at a time.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.