Browse By Tags

  • Blog Post: Validating Time

    A way of validating time is possible by taking advantage of the way Date/Time fields are added into Sage CRM. For example if you add a new Date/Time field into the company table, e.g. comp_customersincedate there is a lot of additional functionality added when the field is included in a screen (like...
  • Blog Post: The Values() collection

    The Values() collection can be used in all serverside scripts to examine the passed in Values from a form. Create Scripts Validate Scripts Tablelevel Scripts Workflow Scripts The Values() collection must always have an argument passed to it. The Values() collection can not be examined...
  • 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: Server Side Validation and ASP pages

    If you need to perform some server side validation within an ASP page that would use the standard CRM behaviour to highlight the field that contains the invalid data. Then the simplest approach is to use Validation Rules. These can be defined either at the level of the screen or applied to a screen within...
  • Blog Post: Validation rules don't always mean "Stop!"

    I was asked recently about how to create a log of when data was changed within a particular screen. Now the requirement was focussed on the screen and not on the the record. If we had been interested in whenever data in the record changed then of course we could use an Update event function within a...
  • Blog Post: 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. The are sometimes...
  • Blog Post: Validation of Dates

    The validation of dates can be tricky. Partly this is due to jscript and partly down to the flexibility that Sage CRM provides in allowing dates to be presented. I have covered how default values dates can be controlled in the article: Populating Default Date Field Values Other Date related articles...