Forum Post: RE: How can we use total function in HTML report

  • Thread starter Thread starter Sudhakar
  • Start date Start date
Status
Not open for further replies.
S

Sudhakar

Guest
HI @ Gian Torralba, i have created trigger(Timing::After update,Type::Object Script--i need to update 4 fields at a time that why i have selected object scipt instead of update field value) as below if("{!R101162498.status#code}"=="ACT")//if Referral source status=active { var a= rbv_api.selectNumber("SELECT SUM(ad_today) FROM referral_source");//ad_today is expression field to store single column value and not working as expected.if i update the expression field then it is displaying as expected rbv_api.setFieldValue("referral_source", {!R101162498.id}, "sum_ad_today", a);//sum_ad_today is integer field to store total at bottom,but not working as expected it is displaying Zero(i have updated a record in Action done and checked the value ) . }

Continue reading...
 
Status
Not open for further replies.
Back
Top