Below is an example of a SQL query which you can use in a scenario where you want to display a list of duplicate records which are stored in a particular table. Below is the query that has been used to do the needful on the Leads entity (where Client wanted to have the list… Read More »
If you are facing this error while executing the query from the ASP page: And you find that the sql query working fine in the SQL Query Analyzer. It might be a problem with Query Time out duration. Solution: We can set the CommandTimeOut property of the ADODB command object. The default value is 30… Read More »
Now we can REschedule the tasks and appointments for any particular user (i.e. to postponed communications for within the range of dates). It will provide a new tab in the “My CRM” context which will provide a screen to accept user name and date (from and to). It will display the list of all the… Read More »
Now we can Schedule the tasks and appointments End Date excluding the Weekend and Federal Holidays. Below Mentioned Federal Holidays will be taken care of with this Script. New Years Day: Tues., Jan. 1 Martin Luther King, Jr.: Mon., Jan. 21 Washington’s B’day: Mon., Feb. 18 Memorial Day: Mon., May 26 Independence Day: Fri., July… Read More »
Currently, there is no functionality available which allows user to fill one multi select field based upon the another multi select field dynamically. Solution:We have a tool which does the same. Suppose there are two multi select fields named Category (i.e. pers_category) and Sub Category (i.e. pers_subcategory) under the Person Entity. The Selection options for… Read More »
To hide “New Note” button under the Notes tab of Case if current user is not the assigned user of the case. Please have a look at the script written in below Screen…
Whenever we create person from the company context it takes the default Business email address of the company. Are you willing to change this default email address? This can be easily achieved by putting following code snippet in “Custom Content” field of “Person Entry Screen”.
Would you like to have a track on Current timings in city of the companies you are dealing with? here is the solution for your requirement. This component adds an extra field to the Company top content screen called Current Time.This field will show the current time in city found in address box of corresponding… Read More »
Do you want to hide the standard fields from Top Content Screen?If you see, Some standard fields from Top Contect Screen of any entity could not be available in TopContent Screen if you are willing to hide them from Top Content Screen. If you are willing to hide such field we have a script which… Read More »
Need easy access to convert notes to communications which belong to a particular company? A user taking quick notes from company contact person and now willing to convert all/Individual notes to communication. Solution: Now it is available in Sage CRM. We have a tool which will add a new Button named “Convert to Communication” below… Read More »
