Browse By Tags
Home
»
All Tags
»
Workflow
7.2
activities
Any DB
ASP
campaigns
clientside
COM
Company
Component
Context
create script
CRM Standalone Install
English
Escalation Rules
example
Fields
Javascript
Known Bug
Marketing
Opportunity
Sage CRM 2018
SQL
Table Level scripts
Training
waves
Blog Post:
Distinguishing Between Primary Workflow Rules in Create Scripts
Jeff Richards
In Sage CRM it is possible to have multiple workflows created for an Entity. For example we may have one Opportunity workflow that is used by a one team for a particular type of sales opportunity and another workflow that is used for a different type of sales process. The different workflows may...
on
26 Nov 2012
Blog Post:
Adding Workflow Capability to a Secondary or Custom Entity
Jeff Richards
It is possible to take an existing entity,either one that you have added to the system or an existing table such as notes, and allow it to be workflowed. The technique below will be effective for both custom tables and existing system tables. Using the Library table as an example Add a libr_workflowid...
on
23 Dec 2007
Blog Post:
Adding Clientside Code into Dynamically Built Workflow Action screens
Jeff Richards
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 that when a user was processing an opportunity...
on
28 May 2010
Blog Post:
Customizing Progress Screens when Workflow Switched Off (Lead/Opportunity/Cases/Solutions)
Jeff Richards
There are 4 core entities in the system that have progress tables. Lead Opportunity Cases Solutions There are default workflows provides for these entities and in most implementations of Sage CRM the powerful feature of the graphical workflow engine will be used. This is found...
on
9 Feb 2011
Blog Post:
Building a Workflow Map Diagram that Shows Progress through Workflow
Jeff Richards
Workflows in Sage CRM can become long and a user may wish they had a version of the diagram that is available when the workflow is constructed. You can see from this image below that an extra button has been added to the Opportunity screen. In this example application, when the 'Workflow Map'...
on
6 Jul 2009
Blog Post:
Duration in Workflow Tracking pages
Jeff Richards
The oppo_duration field is defined in the custom_edits tables as being of Entry Type 'Minutes'. The minutes are held as the physical data type 'int' select * from custom_edits where colp_entrytype = 57 Fields of entry type 'Minutes' can be used in any entity and they have a couple...
on
21 Mar 2008
Blog Post:
Using ASP Pages in Workflow
Jeff Richards
Sage CRM has a very powerful internal workflow engine. Workflow may control the processing of data from the initial insertion of the record through to its final state. The user driven aspect of workflow is created from a mixture of workflow rules and states . The states represent the arbitrary resting...
on
3 Oct 2007
Blog Post:
Populating Default Date Field Values
Jeff Richards
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 then the field displays the Current Date/Time plus...
on
29 Dec 2008
Blog Post:
Invoking Workflow from Self Service and Web Service (SOAP) Based Applications
Jeff Richards
One of the challenges that a developer will face when working with Self Service or with an external Application using the SOAP Web Services interface is that workflow is not fully covered by the APIs. Self Service and Workflow Self Service uses the COM API and is designed for use in ASP pages....
on
20 Sep 2010
Blog Post:
Resetting Workflows and Jumping between Workflows
Jeff Richards
This is a technique for moving records from one workflow to another. In fact there are 2 ideas here. 1) The first is the concept of resetting a workflow. Basically this is when you have started to progress along a workflow and then realise that you should have followed a different path. A "reset"...
on
5 Aug 2008
Blog Post:
The Workflow Rule Action - Run Stored Procedure
Jeff Richards
The system administration guide discusses the workflow action 'run stored procedure'. This article expands on the information contained in the documentation. A workflow rule action of type 'run stored procedure' can be created very simply just like any other rule. The purpose...
on
3 Mar 2009
Blog Post:
Using a TableLevel script to Update Submitted Values
Jeff Richards
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 field should be populated with a values based...
on
22 May 2009
Blog Post:
Using Quick Notifications to alert users of reassigned records
Jeff Richards
The links in this article were corrected 22nd May 2009. Oh how angry I get with myself sometimes. I am a very stupid person. Someone sends me an email entitled 'a quick question' and in my idiocy I start trying to answer the question and look up nearly 3 hours later to find I have consumed...
on
22 May 2009
Blog Post:
How does metadata create a Screen?
Jeff Richards
If we consider a screen like the Case Summary screen we can imagine it being built in a series of layers. If we consider the hyperlink http://localhost/CRM/eware.dll/Do?SID=198369875659391&Act=281&Mode=1&CLk=T&Key0=8&Key1=43&Key2=57&Key8=46&T=Case We can see that the Action...
on
22 May 2009
Blog Post:
Date and Times in Escalation Rules
Jeff Richards
I have discussed in a previous article the structure and purpose of the SQL clause of an Escalation rule. e.g. (quot_IsQuote is not null) AND UPPER(RTRIM(quot_Status))=UPPER(RTRIM(N'Active')) AND (Escl_DateTime<#T And Escl_UserID=#U) We know that in the SQL trigger clause the #T and...
on
22 Feb 2008
Blog Post:
Company and Person Workflow Progress with Tracking tab in CRM
Jeff Richards
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. As standard, CRM does not offer a CompanyProgress...
on
3 Jul 2009
Blog Post:
Controlling Workflow Availability
Jeff Richards
Imagine a system where you may want to ensure that your users do not create any new support cases for a company that has had their status changed to "On Hold". The ideas discussed here would also apply to any record created as a child of a company or a person. In your own systems you may have...
on
8 Mar 2008
Blog Post:
Creating and Controlling an Insert Page in Self Service
Jeff Richards
Below is a very simple example of a self service page that allows a case belonging to an authenticated visitor to be edited. The ASP code is found below. The code is comment and discussed below. <%@CodePage=65001 Language=JavaScript %> <!-- #include file ="ewaress.js"...
on
5 Dec 2008
Blog Post:
Escalation Rule that runs only during normal business hours
Wing Kwong
If you want your escalation rule to run only during certain period of time, you can add the following to your existing SQL clause: (... existing SQL triggering clause) AND datepart(hour, current_timestamp)<'18' AND datepart(hour, current_timestamp)>'7' AND DATENAME(WEEKDAY, GETDATE...
on
18 Jan 2010
Blog Post:
Cloning an Opportunity using the ASP COM API
Jeff Richards
I have written earlier about cloning or copying existing records. Please see the article Using the COM API to Clone a Record . This article provides a worked example on how you can use that article to add a button to the opportunity summary screen that will copy an existing opportunity record and...
on
10 Jan 2012
Blog Post:
Taking a Snapshot of Currency Exchange Values
Jeff Richards
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 in Euros or a financial controller in the US could...
on
28 Nov 2008
Blog Post:
Modify field on another table in a workflow action
Sage CRM Team
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 rule on. However this will not work by design: You...
on
24 Apr 2009
Blog Post:
Controlling workflow state in ASP
Jeff Richards
This is some code from an asp page designed to be used in a cross entity workflow. The original page forms part of an Opportunity Workflow. But the actual code here was in an ASP page is called from a rule associated with the communication entity. The button would appear on the communication screen...
on
1 Nov 2009
Blog Post:
Conditionally send e-mail on entity creation
Sage CRM Team
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 is achieved by putting a Send E-mail action on the...
on
24 Apr 2009
Blog Post:
Objects Available in the Internal COM API
Jeff Richards
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. The are sometimes...
on
13 Mar 2009
>