Hi all,I have some problem for help. I want to connect database in any form in my website to SuiteCRM.I search in many sources in gg that I can code module in php.Unlucky,I did’t learn php and have no more time for this task.Can I have any solution for this problem?
Thanks for your help
Do you want to connect form? or just POST data from form to SuiteCRM?
If you can’t program in PHP/HTML and don’t know SugarCRM / SuiteCRM time is necessary to go through the learning curve.
Having said this you can start by readin page 116 of SugarCRM Application Guide:
http://support.sugarcrm.com/files/31a9b1d4-6c03-11e7-a2d5-067914c4cb97.pdf
Here is a paste of that section:
Creating Web-to-Lead Forms
You can create a Web-to-Lead form to capture leads from web-based campaigns or
other web-based sources such as your website. When campaign targets submit the
form, it is saved as lead information in the Sugar database. You can use this lead
information to generate more opportunities for your organization.
When you generate a Web-to-Lead form, it is saved to the cache/generated_forms
folder, from where you can copy it to other locations. You can view and edit
generated forms in the TinyMCE editor. Only administrators can add additional
fields to the form.
To create a lead form, select Create Lead Form from the Actions bar on the
Campaigns tab.
This displays the Lead Form Wizard page. Click and drag the desired fields from
the Available Fields list to the Leads Form (First Column) or the Leads Form (
Second Column) list.
To move all the fields, click Add All Fields and then click "Next".
Enter information for the following fields and then click "Generate Form":
Form Header : The default header displays. You can delete it and enter the
desired header information.
Form Description : Enter a brief description of the form.
Submit Button Label : The default label displays on the page. You can delete it
and enter the desired label.
Post URL : The default location where the lead information will be stored
displays on the page. To edit this information, select the Edit post URL? box
and then enter the new location.
Redirect URL : Enter the URL to the page that you would like your leads to
view after submitting their information. If you do not specify a URL, Sugar
will display a "Thank you for your Submission" message.
Related Campaign : Enter the name of the campaign that is related to this
lead form. To select from the Campaigns list, click Select.
Assigned to : Enter the name of the individual you want to assign to the
record or click Select to choose from the User List. By default, this record is
assigned to you.
Form Footer : Enter the form footer, if needed.
This displays the form in the TinyMCE editor. Modify the form if needed and click
Save Web To Lead Form. To save the form, you can do one of the following:
1. Copy and paste the HTML from the box to a text file on your local machine.
For On-Premise Sugar systems, the system saves it in the cache/
generated_forms folder on the Sugar server. You can copy it from the cache to
a different location.
2. To save the generated form as a .htm file on your local machine, you can
right-click Web to Lead Form, open the page in a new tab, select Save Page
As from the browser's File menu and navigate to the location where you want
to save it.
3. To view the form, click the Web To Lead Form link at the top of the page.It is in fact simpler than it appears:
- Create a campaign
2, Within the campaign you can create a Web to Lead form (in SuiteCRM there is also Web to Person form. You can create either), I recommend that you put all available fields in the form and later, when editing it you may remove unwanted fields, - Once you have created the form from within SuiteCRM just copy and paste its code to an editor of your choice.
- Edit the form to your needs. Keep the field names as they are, Notice that the foem calls a script to your SuiteCRM installation: keep the call as it is. You may change all css, formatting and javascript to perform field validation. One of the hidden fields is the return page to your website after the form has been processed,
- Once you are happy with your form you can paste the code in the appropriate section of your website
Et voilà ! Now, when someone enters information in your form you will receive it directly in your SuiteCRM instance.
Mine is a simple but pragmatic and working description of all required steps.
Please note that things can get a little more complex if you want to perform more complicated things.