Browse By Tags
Home
»
All Tags
»
Table Level scripts
ASP
COM
Communications
Company
create script
Detached TableLevel Scripts
Email
entity level script
Fields
FormValues() Collection
JackAllan
Javascript
Logging
Opportunity
Registry
serverside
SQL
System Actions
update
UpdateRecord
validate script
Validation
Values() Collection
WhereClause
Workflow
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:
Validation rules don't always mean "Stop!"
Jeff Richards
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...
on
13 Mar 2009
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:
How can I get the SID in Serverside scripting?
Jeff Richards
The SID is the session ID value. The SID may be wanted if you are building a string that represents a hyperlink that will be returned to the browser. The SID after all only is needed for a new web request, we do not actually need it within server side scripts normally as there we are already in the context...
on
25 Mar 2008
Blog Post:
The eWareQuery Object: A warning.
Jeff Richards
I was going to call this a 'warning from history' but as you read the rest of the article you may realise that the 'updateddate' may never have been filled in. The eWareQuery object is a fantastically useful tool for on-premise developers to use in ASP pages, table level scripts and...
on
17 Jun 2014
Blog Post:
Collecting Information from Checkboxes in TableLevel Scripts
Jeff Richards
A customer had a requirement to add a series of check boxes to the Lead screen. The check boxes would allow the user to quickly classify and collect the different interests of a prospect as it the new Lead was entered into the system. Once the lead was saved a summary of the interests then needed to...
on
29 Apr 2015
Blog Post:
A round up of essential articles on setting up and using Table and Entity Level Scripts
Jeff Richards
Table and Entity Level Scripts can be thought of as a bit like SQL triggers. They allow a developer to create scripts that are run when certain database interactions take place. They are defined as javascript and stored in meta data. The scripts are then executed when a record is inserted, updated, or...
on
4 Sep 2015
Blog Post:
Uploading Leads with Notes using Table level Scripts
Ravinder (Ravi)
Recently, we had a requirement where a client wanted to upload Leads with Notes. The way Data upload works for leads, we cannot map any field from upload file to tables other than the lead entity. Hence, we came up with below solution. Requirements 1. To be able to upload lead along with notes...
on
12 Apr 2017
Blog Post:
Create a reminder task for a user when an opportunity is inserted.
Jeff Richards
Workflow is very powerful but one of the limitations is that Follow Up Actions, such as 'Create Task' or 'Create Appointment' can not be invoked on Primary Rules. This means that if a business rule states that a task or an appointment must be created as an Opportunity or Case is...
on
26 Aug 2016
<