Web2Py - Validate uploaded file by email
In your table that contains the upload information, add a new string field called 'validation_key'. When a file is uploaded, insert a GUID or reasonably long alpha-numeric string in it. Send this key as part of the link in the email. When the user clicks the link, search for the key and if found, set the matched 'validation_key' in the database to null. A null validation_key indicates a validated upload and you can allow downloads of that file.
web2py experts. The task I'm trying to accomplish is the following:
-permit a person browsing my site to upload a file to my site through a form (implemented through crud.create())
  -the visitor is not required to establish an account or log in to upload a file
  -the user is required to provide an email address in order for the file to be uploaded
-basically, after the user uploads a file, the file is held in escrow/limbo, and a validation/verification email is sent to the user
-once the user clicks on the link in the validation email, the file is posted to the page, and is made publicly available for download
What's the best way to go about doing this? Thanks!