Browse By Tags

  • Blog Post: Creating a New Entity using COM API ASP

    This article has been updated to allow download from this site. I have written before many times about creating ASP pages to support access to a custom entity. How does Meta Data create a Screen? DPP and Standard include files for ASP pages The Basic Structure of an Edit Page How...
  • Blog Post: Calling CRM Actions

    The CRM.URL() method is used to allow you to build correctly formatted URLs that reach back into the application. Most commonly this is used to interact with ASP pages and with Sage CRM .NET application extensions. For example to build a button that calls an ASP page the code would look like: var...
  • Blog Post: Accented characters not displaying correctly in ASP pages.

    This is a very short tip and one that you may well know, but since I have just run into the problem again, I thought it was was worth a mention. Do you ever see problems like this? This when characters that are marked with diacritic signs (such as acute, grave, umlaut and carron) are retrieved from...
  • Blog Post: More about Using CRM security in ASP pages

    I have previously discussed that access to buttons can be controlled by the 4 & 5 parameter of the CRM.Button() method used in Classic ASP. The entity referenced in the 4th param has to be an entity normally covered by security. The example covered in the previous example discusses whether or...
  • Blog Post: The Programmatic Refresh of Meta Data using COM ASP API

    This article will discuss 1) 2 methods to programmatically control the refresh of meta data. 2) The display of the old style workflow configuration screen that governs the marketing workflow Background The existing workflow rules for the marketing tables (Campaigns, Waves and WaveItems) are actually...
  • Blog Post: Where am I?

    When working with CRM you may have a requirement to know the servername and install names with which you are working. System Options There are a few nice techniques that we can use in ASP pages. For example the COM API has a method that allows us to check the contents of the custom_sysparams...
  • Blog Post: How to filter a pipeline object based on filter screen values

    We know that a LIST block can be filtered based on a standard filter screen block via var filter = eWare.GetBlock("MyFilterBoxName"); var list = eWare.GetBlock("MyListName"); list.ArgObj = filter; Can we filter a pipeline object in a similar fashion? Unfortunately you cannot...
  • Blog Post: Adding a Link to the Notes table for a Custom Entity using the COM ASP API

    This article discusses how the Notes table is linked to the parental record using the idea of the ForeignTableID and ForeignID fields. Below you can see that I have added the Notes table to a Custom Entity (Project). There are 3 main screens that we need to cover. The idea of the List screen...
  • Blog Post: A Simple Editable Grid in COM API ASP

    This article covers the creation of an editable grid. By this I mean the presentation of data in a spreadsheet like structure, each row in the grid a separate record and each column a separate field. The code sample below is very simple and should only be considered a rough outline of how such a grid...
  • Blog Post: Basic Code Structure of a List Page

    The image below shows a new custom page that has been added into the context of the Company in Sage CRM. The list displays Quotes that have been sent to the Company. The basic structure of a list page script looks like this: <!-- #include file ="../sagecrm.js"--> <% var...
  • Blog Post: Building List screens with FilterBoxes

    Custom Pages that contain Search screens are fussy about block positioning. The search block does not work correctly if it is included into the container following the list making it more difficult to create a screen with filterbox like behaviour. The type of Screen I am aiming at is shown here. This...
  • Blog Post: Creating an View/Edit Screen based on a View using the COM ASP API

    Below is a screen shot of a compound screen that populates the fields on the screen from data retrieved from a view. This page has been built using an ASP page. It has used the method CRM.FindRecord(). Syntax is CRM.FindRecord('Entity,vViewName',ArgString); This is a good way...
  • Blog Post: Manage Escalations

    A new example component has been added to the resources section for development partners to download. The purpose of this component is to make the management of escalation rules easier in implementation of Sage CRM where there are a large number of rules to manage. When working with large number of Escalation...
  • Blog Post: Using the COM API to Clone a Record

    There are a number of articles within this community site that discuss the requirement that some business has to clone records. This might be where a customer needs to copy an existing communication to set up a similar meeting or where an opportunity is very similar but just some details need changing...
  • Blog Post: Extending the DefaultToDo options

    One of the nice features that exists in Sage CRM is the ability for a user to set their own preferences for the opening screen the user is shown when they logon. This is the field "Log Me In To" in the preferences screen. A user can logon to CRM and be shown one of the following screens...
  • Blog Post: Adding a Button that Passes Contextual Information to an External Webpage

    You can add a button In a custom ASP page In a the code of a .NET assembly In a an existing system screen Buttons in an ASP Page If this is in an ASP page then the code for a simple button to call an external ASP page looks like var strCallASPButton = CRM.Button("ASP"...
  • Blog Post: Creating a Dynamic Group in Sage CRM using the COM object TargetLists

    The COM API has an object within it called TargetLists. This object can be used within internal script (Validate, Table Level Script etc) to create both Dynamic and Static Groups. Below is a simple example of the object being used in an ASP page to create a Dynamic Group. You will see that I had...
  • Blog Post: Redirecting to an ASPX (ASP .NET) Page from a Classic COM ASP page

    This article follows on from an earlier article " Combining CRM WebServices and ASP.NET ". That article had discussed using the SOAP based webservices of Sage CRM within an ASP.NET page. I had mentioned that such ASPX pages can be called from Sage CRM tabs (and by extension Button Groups...
  • Blog Post: Getting Hold of User Information in Code

    If you need to control the display of screen elements like buttons in ASP pages (or even client side in the browser screens) according to the identity of the CRM users then you will obviously need to be able to access the current user id. In ASP pages you can get hold of user information by using context...
  • Blog Post: COM API objects available in Self Service

    Notes In the above image you will see a couple of the rows marked to indicate that there are further notes. Also a feature marked N/A indicates that the method or property is not applicable within that coding environment. It does not however mean that it can't be invoked nor does it mean that sometimes...
  • Blog Post: Using ASP Pages in Workflow

    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...
  • Blog Post: Grabbing and Using Company and Person Context in Some Custom Entity ASP pages

    A little while ago I wrote an article called " Adding the Document Drop Plugin into a Custom Page ". That article provided the code to include activex plugin into a custompage to allow upload of documents to the library. The orginal article's code that the company and person records were...
  • Blog Post: Invoking Workflow from Self Service and Web Service (SOAP) Based Applications

    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....
  • Blog Post: Resetting Workflows and Jumping between Workflows

    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"...
  • Blog Post: Allowing a User to Control their own language, location and other settings

    A customer had a requirement for their users to be able to control some additional preferences. In Sage CRM most user preferences are held in the usersettings table. These are the settings that control the way in which CRM information is displayed to the user and are found under the Preferences tab...