Activationcode by e-mailaction

People fill in a form on my website. When they puss the confirm button they receive an e-mail.

Now I want to send an activationcode within this e-mail. So that if the click on the activationcode, that will trigger to change a record in a database. The primary key of that database is also available (because filled in the form).

Is this easily to create? And how ?

Hi n.assmann,

If you use the Add Event button in your Form Actions tab you can create a new form Event. Give it a name like confirm and add the Actions in there to update the Database.

The add a link to your email with a URL that includes event=update and a unique identifier for the record you want to update e.g. ...&key=xxx&event=update.

Bob

I am sorry Bob, but you are really going to fast for me.

I know how to create a form event, and I called it "Activation".
Do I need to add the action "DB Save" in there?

And how do I make the proper link inside the e-mail, I really cant tell from your post.

Hi n.assmann,

Yes you add a DB Save action to the new event.

You use PHP in a Custom Code action before the Email action to build the URL you want. It will be something like this:

<?php
$form->data['my_url'] = JURI::root().'index.php?option=com_chronoforms&chronoform=my_form_name&event=my_event_name&keyxxx';
?>

You can then include this in your email as {my_url}. It will need to be in a set of <a> tags to create the link:

<a href='{my_url}' >click here</a>

Bob