Embed Link in Email with Information to Write to Database RRS feed

  • Question

  • User564995064 posted

    Hi all!

    In my application, we have to send an email out to have a person's information verified.  I would like the email to have a Confirm and a Cannot Confirm button.  When the recipient presses the Confirm button, it will redirect to my site and write a 'Y' in the confirmed field in the database for the person we are confirming.  Likewise, it will write a 'N' if the recipient presses the Cannot Confirm button. (This can be buttons or links, doesn't matter.)  I do not want to include the social security number for the person for obvious reasons, but I can include enough information like name, employer, etc to ensure it is the correct person.  My question is how do I structure the url in the link to get to my site and complete this task.

    Thanks for any assistance you can give.

    Friday, April 27, 2018 1:52 PM


  • User475983607 posted

    Simple, generate a unique key. 

    Create database table to save the unique key and any other information you need.  Create a new Action or Web Page to process the email confirmation.   Add a link in the confirmation email that points to the new Action or Web Page and append the key to the URL querystring.

    The new page reads the querystring unique key, queries the table to fetch the stored data, then process the confirmation.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 27, 2018 2:06 PM

All replies