How to set sum of particular field value as default value

Posted By irappa over 10 years ago

Hi,

I am created one custom entity and its having column called "Price". Now whenever summary screen loads, I want to display the total price. I have tried some thing like below:

DefaultValue = select sum(frie_Price) from FriEnt;

How can I populate sum of price as default value for any field ?

0 Sage CRM over 10 years ago

Try this

var mySQL = 'select sum(xxxx_myfield) as mytotal from mytable';

var myQuery = CRM.CreateQueryObj(mySQL,"");

myQuery.SelectSQL();

DefaultValue = myQuery.FieldValue('mytotal');
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joe.khadra over 8 years ago

how can i do this on the on change script of the price field?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage CRM over 8 years ago

Joe

If you are using Sage CRM 7.2 or Sage CRM 7.3 then you can use the SData() method to carry out an Ajax request.

Examples of using the Client Side API can be found here:

community.sagecrm.com/.../the-client-side-api-in-sage-crm-7-2-amp-sage-crm-7-3-a-round-up-of-articles.aspx

Some more background information about the SData API can be found here:

community.sagecrm.com/.../sage-crm-7-2-a-round-up-of-articles-to-help-you-use-the-sdata-provider.aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

How to set sum of particular field value as default value

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING