Friday, February 10, 2012
  Search
Support Forum
Confirmed/Verified Optin/Registration
Last Post 23 Apr 2010 05:26 PM by Kent. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Kent
New Member
New Member
Send Private Message
Posts:6


--
07 Apr 2010 06:25 PM  
We are deploying 3 data capture forms on our client's website using Forms Master 2008 version 2.0.8.

Email Subscription
Request Information
Registration to access photo library

 Each of the form includes a checkbox field to allow the prospect to subscribe to receive email communications from the client.  If the user checks the subscription checkbox on any of the 3 forms, we would like to require verification via email, as is done for registration on the code5systems.com website.  So here are the functional requirements.

1.  User completes form and checks checkbox indicating user would like to subscribe to receive email communications.  (we have completed the creation of the forms)
2.  Upon submit - if the subscribe checkbox is checked, the thank you page is displayed that advises that the user will receive an email confirming their subscription to receive email.  A confirmation link will be included in the email.  They must click the link to complete the subscription process.  (we have not created this thank you page)
3.  Upon submit - if the subscribe checkbox is NOT check, a different page is displayed that advises the user that their registration is complete.  (we have completed this thank you page - we can combine 2 and 3 into one thank you page if necessary)
4.  DNN automatically sends an email to the user if the subscribe checkbox was checked, It includes a link to verify their registration.  They click the link and are redirected to a page on the Website that explains that their subscription is complete, etc. 

We know how to do everything here, except #4.  Can you tell us if Form Master 2008 supports this and if so, if there is documentation on how to acheive it.

Thank you.

Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
07 Apr 2010 11:42 PM  
Hi,

#2 and 3: Conditional Thank You page content is not supported. You will have to combine messaging as you said.

#4: Form Master can send an Auto Responder but again not contionally all users Checked or not will get the email. 

So are you trying to be sure that a users's emaill address is valid or are you doing a double opt-in functionality?
Kent
New Member
New Member
Send Private Message
Posts:6


--
08 Apr 2010 12:38 AM  
Super helpful. Thank you. I am doing a double opt-in... we have email validation rules in place. We cannot find the documentation on how to implement the double optin.
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
08 Apr 2010 12:51 AM  
Sorry but there is no double opt-in functionality in Form Master out of the box. HTH I will email you with a possible solution later. I just wrote it and this forum lost is all
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
08 Apr 2010 11:39 AM  
Here is how I would go about doing a double opt-in with Form Master

1. On form one which has the subscribe ckeckbox I would have a hidden field a user checks to subscribe to an emailing. Make sure you create a [TOKEN] for this field On this form I would have a hidden field call it OptInID which I would populate using Auto Fill Type of Field Query and use Select newid() as OptInID in the SQL box. I would use Data Manager to map this form to a real Database Table.

2. On form one create an Auto Responder which includes a link to Form Two (below) using the [TOKEN] for the hidden field created in step 1. the URL would end up looking like

http:// www. mydomain.com/formtwo.aspx?optinid=knadsjou0uoi908u98u54lksfaodfj

3. Create a second hidden form which will do the work of verifying the double opt-in. Make a hidden field which will be populated using Auto Fill Type of URL, specifying optinid as the URL parameter name. This form will clearly tell the user they are opting into an email campaign. Use Data Manager to also map this form to a real Database Table.

The two tables can be linked with a foreign key as the OptInID.

Remember there are no conditional thank you page or auto responder based on the value of a checkbox or any other control in Form Master. All users will get the same thank you page and auto responder.
Kent
New Member
New Member
Send Private Message
Posts:6


--
20 Apr 2010 11:25 PM  
In trying to implement we must have corrupted the form, we are now getting this message when we try to edit the form:
"Conversion from type 'Guid' to type 'String' is not valid."
And it displays the Input Control for adding a new field. We can't seem to get to any of the existing fields etc. Is there a way to recover the form?
Kent
New Member
New Member
Send Private Message
Posts:6


--
21 Apr 2010 07:32 PM  
I believe the following revised query may solve that issue with the component trying to implicitly cast the GUID as a string, instead we'll explicitly cast it in the query.
Select cast( (Select newid()) as varchar(40 )) As OptinID
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
21 Apr 2010 10:45 PM  
Sorry I forgot that needed to be done.
Kent
New Member
New Member
Send Private Message
Posts:6


--
23 Apr 2010 12:09 AM  
Ok...another related question...what's the syntax for executing a stored procedure in the SQL Query with a passed parameter. Tried a couple of iterations of this:
Exec FlagSubScriberDoubleOptIn #URLPTINID#
Kent
New Member
New Member
Send Private Message
Posts:6


--
23 Apr 2010 05:26 PM  
Ok...got it ...
Execute FlagSubScriberDoubleOptIn '#URLPTINID#'
Works
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.