Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Drop Down Lists
Adding Derived Fields in Views into Meta Data
I originally wrote about creating derived fields in a view in the article " Custom_Edits and Derived Fields Created in Views ". This discussion is a continuation of the ideas expressed in that article and will show how meta data definitions of a calculated field can be easily added into Meta...
30 Jun 2009
Using SearchSQL to limit data returned by selection lists
In the screen shot below we can see the demo user "Susan Maye" is limited to assigned the new opportunity to only people in the "Direct Sales" team. This has been accomplished by using the property of the field (a.k.a entryblock) called SearchSQL. The SearchSQL property is discussed...
27 Jan 2008
But I really, really need to search for the actual comp_companyid!
Once upon a time I wrote an article called " But I really, really need to see the actual oppo_opportunityid displayed! " This article looks at how you could use the column alias idea to allow for records to be searched for by the their unique ids. Note : Generally I think this is not...
19 Jul 2011
Company and Person Workflow Progress with Tracking tab in CRM
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...
3 Jul 2009
Adding Fields, Deleting Fields, Views, vSentinel and SQL Errors
Sage CRM provides the system administrator with easy ways to add or remove fields from the system. But when you add or remove a field then you will implicity affect views which are based on those tables. And of course views may inturn be based on views. Each of these views in turn are referenced by...
26 Feb 2009
Changing a Checkbox to a Selection list
Checkbox fields are brilliant for letting a user quickly collect certain types of data. But they do have their limitations and you may discover that you want to be able to store answers such as 'Y' (Yes), 'N' (No), 'M' (Maybe) rather than a simple 'check'. If that is...
25 Oct 2010
Tips for Building Views: A round up of articles on views.
The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or can't be done in Reports, Marketing Groups,...
1 Jul 2009
Converting default ntext fields from an old install of CRM to nvarchar(max)
Sage CRM Team
This is a SQL script that will solve the problem associated with on-premise accounts that still have some ntext fields in their database from older versions of CRM. The ntext fields do not allow some of the actions that are used in the views of CRM, DISTINCT being an example of one of these commands...
11 May 2018
© The Sage Group plc 2019
All Rights Reserved