Browse By Tags
Home
»
All Tags
»
COM
»
List Block
»
ASP
clientside
Columns
Custom Jump
Entry Screen
Fields
GridColumns
GridSize
include files
List Page
Meta Data
Multiple Blocks
ODBC
preferences
Sage ERP MAS 90
Sage MAS
Search Screen
Self Service
Summary Screen
UserOptions
Blog Post:
Creating a simple ASP List Page that Displays Data from an external Database using an ODBC driver
Jeff Richards
This article is part of a series that discusses how you can link to an external database and list, search and view data from a table in that external system. I have used Sage ERP MAS 90 as my example database. The techniques discussed here can be used within implementations of the Extended Enterpise...
on
22 Sep 2010
Blog Post:
Basic Code Structure of a List Page
Jeff Richards
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...
on
25 Aug 2016
Blog Post:
Manage Escalations
Jeff Richards
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...
on
3 Jul 2009
Blog Post:
Creating and controlling List Pages in Self Service
Jeff Richards
Below is a very simple example of a self service page displaying a list of Cases belonging to an authenticated visitor. The ASP code is found below. The code is marked in different colours and discussed in a following section. <%@CodePage=65001 Language=JavaScript %> <!-- #include...
on
5 Dec 2008
Blog Post:
Building Custom Jump Hyperlinks from List blocks
Jeff Richards
Setting up a Custom Jump from a list to an ASP page is not difficult as we can see from the image below. What is not so obvious is how we can cause more than one name/value pair to be included in the QueryString of the hyperlink. In the above example the field oppo_opportunityid is being used. If we...
on
23 Mar 2008
Blog Post:
Controlling List Size in ASP Pages
Jeff Richards
How can we override the User grid size preference for a custom list on ASP pages? You may have seen that there is a List block property called RowsPerScreen ListBlock.RowsPerScreen = 5; On the face of it, this should allow us to change the list size to what ever we need. But according to Developers...
on
12 Nov 2008
Blog Post:
Creating an ASP Search Page that Displays Data from an external Database using an ODBC driver e.g. Sage 100 ERP, formerly known as MAS 90
Jeff Richards
This article discusses the challenges that can be faced when building a Search page that queries an external database table through an ODBC driver. I have used for this example a connection to a Sage ERP MAS 90 table. I have assumed that you will have read the following articles Connecting to...
on
22 Sep 2010
Blog Post:
Displaying Multiple List Blocks using the ASP COM API
Jeff Richards
We have seen in other posts that it is perfectly possible to create ASP pages that contain multiple blocks. These have been search pages or entry pages that have drawn their blocks from either the same or different entities. What we have not discussed so far is the display of multiple list blocks...
on
13 Mar 2009
Blog Post:
Creating an ASP Summary Page (ReadOnly) that Displays Data from an external Database using an ODBC driver e.g. Sage 100 ERP, formerly known as MAS 90
Jeff Richards
This article provides example code for building a Summary page that displays data from an external database table through an ODBC driver. I have used for this example a connection to a Sage ERP MAS 90 table. I have assumed that you will have read the following articles Connecting to an External...
on
25 Oct 2010
Blog Post:
Building Lists without reference to Meta Data in the ASP COM API
Jeff Richards
Above is a picture of a new list added into the My CRM area of Sage CRM. The code below shows how a list can be created using the ASP COM API. var intRecordId = CRM.GetContextInfo("user","user_userid"); var Arg = "oppo_assigneduserid="+intRecordId; var myBlock = CRM.GetBlock...
on
9 Jun 2009