Create Same Company in another Database

When you create a company in your CRM database and at the same time looking to create the same company in another CRM database, then you can do this by defining below trigger for your source database: CREATE TRIGGER trig_insert_CompanyON [CRMSOURCEDB].[dbo].[Company]FOR INSERTAS DECLARE @Company_Id AS INTEXEC @Company_Id = [CRMDESTDB].dbo.eware_get_identity_id ‘Company’ INSERT [CRMDESTDB].dbo.Company (comp_companyid,comp_name,comp_type)SELECT @Company_Id,comp_name,comp_typeFROM inserted

Adding tooltip to hyperlink

Description:Now in SageCRM, if any one wants to display tooltip on mouse over on hyperlink to view any details. It can also be customize to view image in the tooltip. Solution:To achieve this, you only need to call function on mouse over and mouse out event on the anchor tag. We have also customized this… Read More »

Sage CRM Product Import

Greytrix released a new tool that will import the products from an excel sheet into Sage CRM and Sage CRM.com. Like most of the other integration products, the product import tool uses Sage CRM web-services to import data in Sage CRM. Along with the installation, Greytrix provides the user with the excel spreadsheet template. The… Read More »

Communication Save Problem Sometimes when you customize the Communications area in Sage CRM, the communication not gets saved and returns back you on new communication entry screen from the below mentioned scenarios. 1. creating a new task or appointment through mass communications or 2. through document merge functionality? If this is the problem of your… Read More »

Custom CSS

Now in SageCRM, if you want to include your own created CSS rather than standard CSS of CRM. Here is how you can achieve it. Click the image to enlarge it.