Randomize Text in Fields??

[mKirk]

I'm building a little testing solution. I have a question with 4 possible multiple choice answers...each answer being in a seperate field. I'd like to have a button that would randomly "scramble" the answers in each field. This way an answer "key" couldn't be created as the correct answer would not always be in the same place.

Thanks in advance for any help/suggestions.

===Okay, I made a solution by doing a sequences of copy/pastes using temporary fields. Don't know if it is the most elegant, but it works.===

Edited August 1, 2005 by Guest

[comment]

I would put the answers in a related table, with these fields:

AnswerID (serial)

QuestionID

Answer

IsCorrect (flags the correct answer)

cRandom (unstored calculation, result is number,= Random)

Display the answers in a portal sorted by cRandom. A Refresh Window script step, with 'Flush cached...' option checked, will scramble the order of display.

Edited August 2, 2005 by Guest