• Duplicated lines in Lead communication

    Hi all, I have a workflow where I send emails on action. Looking into the communication list, the email log seems to be duplicated. Looking into the table Communication, the row content are the same but the Comm_CommunicationId is different. Is this…
  • Allow all user to view lead when it had specific state/status

    Hi All, problem background: Salesperson B create a lead. At this point, the lead can only be seen by Salesperson B, and send to manager for approval. After review the lead, the manager then decided that this Lead is not ready to be process due to…
  • Notifications

    Can you tell me CRM if we can have an automated email notification sent to the sales rep when a lead is assigned to them?
  • How to disable Convert to Opportunity until a certain state?

    Hi all, I want to create a Lead approval workflow. It is consist of few stages: Start, approved, not approved, resubmit, and Final Rejection. I do not want to allow the Lead to be Converted to Opportunity until it comes to the final state: Approved…
  • Checking dates in Workflow Transition Rule

    Hi Probably I’m missing something, but I don’t find a simply way to do this. I’m wondering if exists a easy way to check availability of a transition workflow rule depending of a date field in the same way as we can do on the escalations rules. …
  • How to export workflow

    Hi all, I would like to export a workflow from a test CRM site and import it in a live CRM site, is there any way to export and import it instead of creating it again? Thank you.
  • Adding Clientside Code into Dynamically Built Workflow Action screens

    I had a conversation with a participant at one of the recent Bootcamps regarding the use of clientside code in dynamically built workflow screens. This topic has also appeared in the Forums with the community site. The partner's customer had a requirement…
  • A Universal "Go Back" button in Workflow

    The requirement to allow the user to fall back to an earlier point in the workflow is usually handled by looping. We can see from the diagram below how a workflow can allow a user to drop back and repeat or cycle through certain workflow states again…
  • Company and Person Workflow Progress with Tracking tab in CRM

    Many thanks must go to a colleague in the UK professional services team for this article. Introduction Customers often request the ability to track Company or Person changes in much the same way that CRM offers with Opportunity and Case entities.…
  • Tips for Building Views: A round up of articles on views.

    The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or…
  • Using a TableLevel script to Update Submitted Values

    Imagine you have a requirement to a ensure that a particular opportunity field contains certain data as an Opportunity record is inserted. In addition this information should be partially derived from the parent company data. For example the oppo_customerref…
  • Populating Default Date Field Values

    This article has been updated. Create Script example Date/Time fields can can have their values set by using the DefaultType property. If DefaultType set to 6 then the field displays the Current Date/Time DefaultType = 6; If DefaultType set to 14…