Select random record for giveaway

[cmeinck]

I have a database of email addresses. I'd like to randomly select one email address for a contest I'm running. Any suggestions how to go about this?

Thanks.

Chris

[comment]

Try something like:

Show All Records

Go to Record [ Int ( Random * Get (FoundCount) ) + 1 ]

Set Field [ YourTable::Winner; 1 ]

Commit Records/Requests