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

  • Thread starter Thread starter Gian Torralba
  • Start date Start date
Status
Not open for further replies.
G

Gian Torralba

Guest
Hi Sudhakar, Thanks for the quick response. Here are two possible ways to get the dynamic values on the report. Since expression fields doesn't update the values when the record is not updated and we still need to use the selectNumber API to compute the total, I suggest changing the expression field to an integer field and then creating an update field trigger on the related object that will update the integer field on create/update. The second approach is that we stick to the expression field but instead of the update field trigger, you can use an object script trigger and the updateRecord API that will re update the record. I would suggest using the first one since it will only update a single field rather than the whole record. Thanks, Gian

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