double in

This might be a bit off topic. Still,
I wonder if CFB can be used to register a user "double-in".
First one will apply for a registration.
Then there will be sent a Link to the user's email.
After clicking it there will be the actual registration and the new user will receive a confirmation message of a successful registration.
What would be the procedure to achieve this?

For this you will need Form Builder, DataAssist and Universal Email and possibly SecurityAssist.


To sttart you will need to configure the user registration table. In addition to the usual columns for a user table, there will need to be two additional column. One column for the registration status the default value for this column should be 0. The other to store a random string.

Use Form Builder to create the initial Registration form.

Use DataAssist to store the registration information in a database. The Users status will automatically get set to 0, you will need to generate a random string to store as well. You can use the SecurityAssist random password function for this.


Use Universal Email to send the email. The email will contain a link with 2 query string variables:

confirm.php?id=##&regCode=#########

the id variable will be the primary key ID value for the user that registered. The regCode will be the random string that was stored in the.



On the confirm.php page, crate recordset to filter the users table based on the ID and regCode passed in the link to find the users record, then use the dataassist Update Record server behavior to update the UserStatus column to 1

Thank you for taking the trouble to explain in depth the procedure.
Makes a lot of sense and I guess there won't be an automated solution waiting round the corner?

best wishes

The User Registration Solution Pack has this in place already:
user-registration/