Is it possible to have users sign up for newsletters "opt in (datasprings module)" from within dynamic forms?

Troy,

Hi. Well Dynamic Registration has a direct integration option with Opt In Email (but this is mostly because you can go back and edit your registration/opt in information) etc.. We are planning to offer a similar integration with Dynamic Forms and especially when the 4.0 release of Opt In Email is released. For now, the answer is yes though... Just a few more steps.

I am attaching a SQL script, you can open this up and go to Host, SQL and execute it. You then need to create a SQL completion event that looks something like this:

DataSprings_OptInEmail_AddFromDynamicForms '$(FirstNAme)', '$(LastName)', '$(EmailAddress)', 'Your Opt In Category Name', 0

This would be if your short field names were named the above short field names and if your Opt In Category Name was titled 'Opt In Category Name' and your portalID was 0.


-Chad

I also would like to pass Dynamic Forms information to my Opt-In list. However, when I run the SQL file, I get the following message:

There is an error in your query!

Could you please post a new one that works? I'm using DNN 4.09.

Thanks.

Just make sure you don't have an EXEC or GO on either end of the stored proc call :-)

Grant

This message is in addition to Chad's 9/19/08 post.  This will allow users to opt out from Opt In Email lists from Dynamic Forms:

Create  Procedure {databaseOwner}[{objectQualifier}DataSprings_OptInEmail_RemoveFromDynamicForms]
@FirstName nvarchar(200),
@LastName nvarchar(200),
@EmailAddress nvarchar(200),
@CategoryName nvarchar(200),
@PortalID int

AS
Declare @CatID UniqueIdentifier
Declare @OptID UniqueIdentifier

--If users already exists then don't insert them
IF (SELECT count(*) FROM  {databaseOwner}[{objectQualifier}DataSprings_OptInEmail] WHERE EmailAddress = @EmailAddress AND InActive = 0) =0
BEGIN
Insert Into {databaseOwner}[{objectQualifier}DataSprings_OptInEmail] (FirstName, LastName, EmailAddress, [DateTime], IsVerified, InActive, PortalID)
Values(@FirstName, @LastName, @EmailAddress, GetDate(), -1, 0, @PortalID)
END

Set @OptID = (Select TOP 1 OptInEmailID from {databaseOwner}[{objectQualifier}DataSprings_OptInEmail] where Emailaddress = @EmailAddress)
Set @CatID  = (Select Top 1 OptInCategoryID from {databaseOwner}[{objectQualifier}DataSprings_OptInCategory] where Category = @CategoryName)
--print  @OptID
--print  @CatID
--We now have the opt in email ID and the opt in category ID
--Add the user to the opt in email categoryID

IF (SELECT count(*) FROM  {databaseOwner}[{objectQualifier}DataSprings_OptInEmailCategory] WHERE OptInEmailID = @OptID AND OptInCategoryID = @CatID AND InActive = 0) = 1
BEGIN
UPDATE {databaseOwner}[{objectQualifier}DataSprings_OptInEmailCategory]
Set OptIn = 0
Where OptInEmailID = @OptID
AND OptInCategoryID = @CatID
END

GO