Browse By Tags
Home
»
All Tags
»
Fields
»
SQL
Component
create script
custom captions
Drop Down Lists
Entry Screen
EntryTypes
List Block
Logging
Meta Data
ntext
Person
progress table
Reports
Runblock
SearchSQL
Security
Selection
SQL Server
Tabs
tracking
translations
Views
vsentinel
Web Services
Workflow
Blog Post:
Adding Derived Fields in Views into Meta Data
Jeff Richards
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...
on
30 Jun 2009
Blog Post:
Using SearchSQL to limit data returned by selection lists
Jeff Richards
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...
on
27 Jan 2008
Blog Post:
But I really, really need to search for the actual comp_companyid!
Jeff Richards
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...
on
19 Jul 2011
Blog Post:
Company and Person Workflow Progress with Tracking tab in CRM
Jeff Richards
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...
on
3 Jul 2009
Blog Post:
Adding Fields, Deleting Fields, Views, vSentinel and SQL Errors
Jeff Richards
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...
on
26 Feb 2009
Blog Post:
Changing a Checkbox to a Selection list
Jeff Richards
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...
on
25 Oct 2010
Blog Post:
Tips for Building Views: A round up of articles on views.
Jeff Richards
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,...
on
1 Jul 2009
Blog Post:
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...
on
11 May 2018