Lead Capture as a Joomla 1.5 Module

[shane55]

This Information is outdated, please see the following post:

[shane55]

Well, I had this thing working but it wasn't exactly elegant, so instead I decided to play with the campaigns lead capture form wizard. After creating it and stripping out all of the formatting for color and text, I am left with what follows. It integrates fine into joomla and inputs leads great except Email doesn't seem to be carried in and stored in the database. I selected the email box from the wizzard and never changed any variable names so I am not sure why this isn't passing through - anyone else have this problem? Attached is my revised code!

<td><span sugar="slot">Email: </span></td>
            <td><span sugar="slot"><input id="webtolead_email1" name="webtolead_email1" onchange="validateEmailAdd();" type="text" /></span></td>

I think this is where the error is - is webtolead_email the wrong name for this field - what is the name of the email field in the leads table? any help would be greatly appreciated.

[stro]

I had the same issue inside and outside of joomla. i created a webtolead form and posted it on my site to test. i put information in all fields but only some of the fields came through to the db. not sure where the break is, but would like to know.

Greg

[TeckniX]

I'm binging this back up from the dead - I'm currently using SugarCRM Professional Version 5.2.0f (Build 5688)
and having the exact same issue. It seems that the webtolead_email1 or webtolead_email2 aren't being saved to the database at all.

The Create Lead Form, should have all the needed information, yet it's still not working.

If anyone could help me understand what happens to the lead email address once it is submitted or how it is saved, I would greatly appreciate.

I tried to look at the Vardefs to see if maybe something was in there, but couldn't really understand what was happening.

http://www.sugarcrm.com/wiki/index.p..._Documentation

[dreverri]

This Knowledge Base article might be relevant:
http://kb.sugarcrm.com/custom/an-alt...dcapture-form/

[TeckniX]

Thank you for the prompt response, except I don't seem to have access to the Knowledge Base http://kb.sugarcrm.com

When I try to access the link you've provided, I get the following:


Not sure what I'm doing wrong since it never asked me for a login/password...

[TeckniX]

HAHAHAHA - I figured it out, this is super lame btw....

If you're logged in to the forum, the KB will try to use that login for whatever reason and gives you the user/pass error found above.

If you're not logged in then you can view the KB without any problems! Now that's a really stupid BUG. FIX IT!!!!

[davehaertel]

I'm binging this back up from the dead - I'm currently using SugarCRM Professional Version 5.2.0f (Build 5688)
and having the exact same issue. It seems that the webtolead_email1 or webtolead_email2 aren't being saved to the database at all.

The Create Lead Form, should have all the needed information, yet it's still not working.

If anyone could help me understand what happens to the lead email address once it is submitted or how it is saved, I would greatly appreciate.

I tried to look at the Vardefs to see if maybe something was in there, but couldn't really understand what was happening.

http://www.sugarcrm.com/wiki/index.p..._Documentation

I'm not sure if you got this figured out or not, but I would take a look at the fact that joomla is infamous for it's editors and core files stripping out code that it doesn't deem necessary or that it deems a security risk. I have had a lot of headaches over trying to figure this out and have gone to just creating the articles with enough information to save it and then injecting the code into the article table in the database, that way it bypasses Joomla's checks and it accepts the code as it was written from Sugar's web form generator.

Hope that helps