• 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.
  • 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…
  • 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…
  • Modify field on another table in a workflow action

    When choosing a field for the Display Field For Amendment action, you can select fields from the view that are not on the table the rule is based on. For example you can select the comp_primaryuserid if you use the vSummaryOpportunity view to base your…
  • Conditionally send e-mail on entity creation

    It is common to have CRM send out an e-mail on the creation of a new entity. For example you may have an e-mail sent to the assigned user on a new Opportunity notifying them that a the Opportunity has been created and that it is assigned to them. This…
  • Objects Available in the Internal COM API

    The diagram below contains the objects, methods and properties that are the main ones used in the internal COM API of Sage CRM. These objects can be used in field level scripts; Create and Validate and also in TableLevel scripts and Workflow JScript conditions…
  • Taking a Snapshot of Currency Exchange Values

    Sage CRM offers Multi Currency features. This allows, for example, a Sales user in the UK to quote in Sterling for their British Customers and to Quote in Euros for their German customers. The Sales Manager in Ireland can then see both quotes expressed…