How to create newsletter subscriber web form?

[whallify]

I had posted this as a reply on a different thread, but maybe that hid it well enough to prevent an answer.

I'm using SugarCRM CE 5.2.0 (Build 5380) and have done several email campaigns with success, and I've used the Web to Lead form many times to create useful landing pages within our normal website framework to create Leads in Sugar.

I'm now interested in starting the newsletter functionality in Sugar. However, I don't see how to create a simple "Subscribe to our newsletter" widget on our webpage so that the end result is a creation of a target on the Newsletter Subscription list. Instead, it just creates leads.

Is there a simple mostly-out-of-the-box answer to this?

What I tried:

1. Created newsletter campaign
2. It created the three target lists (subscription, test, and supression)
3. I did "generate lead form" with last name, email
4. Ran a sample record through the lead form
5. Sugar generated a lead that was referencing the newsletter campaign
6. The newsletter subscription target list has no additional members, and clicking on the subscription list and looking at "leads" (on Marketing tab) on the newsletter campaign shows no leads added.

[weemillent]

I'm actually suffering through the same issue. I've created the subscriber list, created the web to lead form, but the leads, while related to the campaign, are not added directly to the target list.

Is there any way to tend to this?

[kuske]

The WebToLead form does not add any lead to any targetlist.

The campaign, you give to the WebToLead form is only stored in the lead record.

If you want o add all leads generated by such a webToLead form you must add them manually to a target list.

Or you write a logic_hook before_save of a lead whichs recognizes the campaign in the lead data and creates an entry in the whished target list.

[weemillent]

Kuske, Thanks so much for all your help. I've finally gotten everything working with logic hooks.

These are my files, in case it'll help anyone. It seems to work pretty well!

 <?php
// custom/modules/Leads/logic_hooks.php
 
// Do not store anything in this file that is not part of the array or the hook version.  This file will
// be automatically rebuilt in the future.
$hook_version = 1;
$hook_array = Array();
// position, file, function
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(1, 'UpdateTargetList', 'custom/modules/Leads/UpdateTargetListAutomatically.php', 'UpdateTargetListAutomatically', 'UpdateTargetList');
?>  

 <?PHP
class UpdateTargetListAutomatically
{
    function UpdateTargetList(&$bean, $event, $arguments="")
    {
        $listBean = new ProspectList();
        $listBean->retrieve('3ab3e58d-b726-33d0-393c-4a90fec10013');
        $listBean->load_relationship('leads');
        $listBean->leads->add($bean->id); // '8c81cd29-e2b7-661d-e46a-4b999a1eb9f8'
    }
}?>  

[hburg]

I'm glad to see that you found out the solution... but I'm new in Sugar and not much skilled in programming and after trying diferent options I haven't been able to implement the logic hook

So, before trying more possibilities, can you tell me how did you implement this hook?

Thanks a lot in advance!!!

[sebek]

This hook is used in every webtolead form or can it be used just for chosen one?

I use Typo3 form to add leads to Sugar...but would like to have one form to create leads...and one for creating target lists for newsletter campaign.

[weemillent]

Hey guys, I'm still very new to this too. if you notice in the comments section, there is

// custom/modules/Leads/logic_hooks.php

that's where you'd put the two files, the first being logic_hooks.php and the second one being UpdateTargetListAutomatically.php

because we're creating a hook based on leads. so you're not actually moving leads to the target list, you're linking the leads to the campaign.

ideally, you just replace the prospect_id (which you'll find in the url of the campaign target) of the file UpdateTargetListAutomatically.php

I'm probably being a bit convoluted. Hope this helps!

[arosenberg]

Could you please explain more clearly what IDs are replaced in the php code below.

What do I replaced the retrieve ID with?
What do I replace the leads-->add IF with?



<?PHP
class UpdateTargetListAutomatically
{
function UpdateTargetList(&$bean, $event, $arguments="")
{
$listBean = new ProspectList();
$listBean->retrieve('3ab3e58d-b726-33d0-393c-4a90fec10013');
$listBean->load_relationship('leads');
$listBean->leads->add($bean->id); // '8c81cd29-e2b7-661d-e46a-4b999a1eb9f8'
}
}?>

[ollelinux]

kuske, weemillent thank you guys.