Browse By Tags
Home
»
All Tags
»
Email
»
Person
API
clientside
Code Snippets
Communications
Company
CRMEmailPhoneData
insert
phone
Reports
SData
SOAP
Sub queries
triggers
Views
Web Services
Blog Post:
Finding Person Records by Email Address using SOAP web services in Sage CRM
Jeff Richards
A customer had the requirement to be able to retrieve person records in Sage CRM using the SOAP web services based on their email address. On the face of it this looks like this may be a difficult job (but it isn't!). This is because of normalization. The Person and Email information are split...
on
28 Aug 2013
Blog Post:
Understanding the CRMEmailPhoneData table
Jeff Richards
If you have spent time looking at the way in which views are constructed in Sage CRM then you may have found the CRMEmailPhoneData table referenced and wondered what is the table's purpose. I asked a colleague in our development team for some help in explaining the table and the following information...
on
19 Jun 2015
Blog Post:
Why do Phone numbers appear in the Company and Person screens when they are stored in the Phone table?
Jeff Richards
This is a follow up to the article I wrote previously called " Understanding the CRMEmailPhoneData table ". That article explained that the CRMEmailPhoneData is a utility table and that it's job is to speed up reports. It holds a row for each company or person with that company or persons...
on
24 Jun 2015
Blog Post:
Hold the Phone! A round up of articles that discuss Phone Numbers and Email addresses in Sage CRM
Jeff Richards
In Sage CRM development around phone numbers and email addresses needs careful thought. This is because Sage CRM "entities" can be complex. For example the information for a Company consists of a company record, a default person record and a default address. Both the company and the default...
on
24 Jun 2015
Blog Post:
Adding a selection list of Person email addresses to the Email screen
Jonathan Jack
When sending emails from within CRM it's sometimes useful to be able to add in multiple people from the associated Company. To do this you can (this example uses sdata): 1) Create a view on the system to expose the necessary person information. 2) Expose the view by adding it to CRM as a table...
on
13 May 2016