Question: User have created fields table using fields.es file. In this es file user should give user name and password of database. Now, user always keep changing password of database for security purpose. So how can user access fields table in such case? User don’t want to change es file. Answer: In regards to this… Read More: Smart ECF »
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: Query to Find out Duplicate records in SageCRM Table »
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: Error: ODBC driver does not support the requested properties. »
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: Reschedule the Task and Appointments for Particular User in SageCRM »
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: Date Calculation considering Federal Holidays. »
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: Dynamic selection for the Multi Selection fields. »
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: Live world clock in Company Top Content »
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: HIde Fields from Top Content Screen »
