I use Dynamic Registration for the user to register at a portal.

Hello,

In this case you can use Dynamic Registration and Dynamic Forms in combination to achieve this work flow.

Basically you will have 4 pages.

1.) Registration page - Using Dynamic Registration
2.) Page for Verification Code - Dynamic Forms
3.) Page A
4.) Page B

So the page # 2 will be the page that will be using Dynamic Forms to execute Redirection Form Completion Events.

You will have a SQL default value on a question to see whether the verification code is correct or not. This will be a Boolean value. If true redirect to page A, if false redirect to page B.

If you have any questions please let me know.

Thanks,

Ryan

Thanks for your reply.

How do I actually save and read the verification code?

for saving
I figure this is supposed to be an SQL statement coompletion event using the $(VerificationCode) token? Do you happen to have an example of this code? I'm not proficient with SQL unfortunately.

for reading
Do you happen to hav a more detailed example on how to run what SQL code with what question type and what validation?

(I figured to try to have Dynamic Forms create the correct verification code by itself, looking up the userID and PortalID, however how is DF supposed to know the UserID, since the user is not logged in yet?Kind of the same problem occurs in this solution. How does DF know which verification code to validate since the user is not yet able to log in?

Hi Tommy,

Let me offer a different approach here using Dynamic Registration and Dynamic Login.

With Dynamic Registration, you just need to create an email event where you add the $(VerificationCode) and/or $(VerificationCodeLink) in the content. The user then can click on the link and get to your Dynamic Login page where the verification code can be entered. If the code is validated, then the user is logged in and will follow any redirection rules you set up. If the code fails, the user is unable to log in.

All of this will only work if you set your site security to Verified in Admin, Site Settings. This is the more common application of the verification code and if you go this route, you don't need SQL for the verification code.

Hope this helps!
Candace

Thanks for your suggestion Candance, however it would be great if somebody could provide some sample SQL code.

My implementation is different as in your scenario. I have a DR module on the regular registration page.

This post is on behalf of a second instance of the DR module. For users to be able to download our product, I need them to register, however I don't want them to follow the regular registration path (where they want to download the product and click download, learn that they need to register, register, verify account, navigate to download page again, click download again), but I want to guide them through registration as quickly as possible.

So if they click download and they're not registered, they're directed to a second instance of the DR module, that redirects to a dynamic forms page (DR completion event), where they have to provide the verification code and if this code is correct (DF completion event) the file download will start. So the user doesn't actually login. This way they click download, fill in registration info, verify code and the download will start.

So I want to register them quickly, but still verify their email address.

Would be awesome if somebody could provide example SQL code. I'm kind of stuck on this and need it to proceed with site development.

Anybody?

Hi Tommy,

Thanks for your questions... I read through what you are trying to do but its difficult because even with SQL there are areas of work flow here that become more difficult to handle.

For example, since you don't want the user to actually sign in then you don't know their UserID. The DNN Verification Code is actually a combination of the portal ID and the userID. So, this is going to be something like 0-50, 0-51, 0-52 etc... Are you looking for any valid code as an option to redirect to A or does it really need to be the code that only they received?

The way I would handle this would be to simply allow them to register, and then inside of the email event you can pass them back to the previous URL after login.

For example, within the email event sending them the verification code you could include the previous URL I believe.

So maybe:
http://www.yoursite.com/default.asp...dpage.aspx

From there after the user clicks login they simply submit the form and are redirected back to where they started with. DotNEtNuke in general (and Dynamic Registration/Dynamic Login) use this ReturnURL all of the time to take the user back to a specific page.

If you really do need to go the SQL route this could be troublesome because you need to check the code that they entered via SQL. So you could do this via SQL Validation to check the code they entered. IF you want to go beyond that though you would have to do something similar to our Demo 32 at http://www.datasprings.com/formdemos where you check the value they entered, then return another value (like true or false) after they click a button. Then from there fire off a redirection to A or B depending on the answer. This is more complicated though and I am not really familiar with the SQL you would need because the verification code is unique per user and the user isn't even signed in yet right? We can assist in writing the SQL if you need us to however these services our handled via our Premium Support and not our community or standard support (or maybe another community member has handled this recently and care share what they did?).

Thanks,

Chad

Hi Chad,

I like your idea. Much more than going with SQL.

Your example unfortunately didn't work. I kept fiddling around trying to format the querystring in different ways. At one point the browser automatically redirected to the correct page and formatted the returnurl in a different way. I copied this from the address bar and implemented it in the email completion event and it works fine now!

the formatting that eventually worked is (tabid 67 is my login page and the page I wanted to redirect to is http://www.mysite.com/Downloads/Download.apsx):


Thanks again!