官术网_书友最值得收藏!

Rollup summary fields 

A rollup summary field (RUS) field is very much like a formula field in that it also performs a calculation. However, this is based on child records, and only when these child records are part of a Master-Detail relationship!

It's used to summarize a numeric value based on (filtered) child records and can perform COUNT, SUM, MIN, and MAX.

It is recalculated whenever a transaction on these child records occurs in the following ways:

  • When a new child is created
  • When one of the children gets updated
  • When a child gets deleted

You can use filters to only pull values from specific child records. For example, let's say that we have a custom Invoice__c object that is related to the account as a Master-Detail relationship. In our Invoice__c object, we have an Amount field and a Status field. We could create a RUS field in the account that represents the total amount that is overdue, which is a calculation of the SUM operation of the Amount field on all related invoices, with a filter on the Status field that is equal to Overdue.

RUS performs an update of the record they reside in and can, therefore, be used to fire off other automation tools, such as WFRs, Process Builders, and more.
主站蜘蛛池模板: 汕尾市| 青川县| 溆浦县| 定远县| 东乡族自治县| 沅陵县| 克什克腾旗| 民乐县| 子洲县| 娱乐| 平潭县| 濮阳县| 武胜县| 南岸区| 忻城县| 汕尾市| 安阳市| 衡阳市| 南澳县| 仙桃市| 丹寨县| 白水县| 华阴市| 巴东县| 湘潭县| 新平| 苍溪县| 桦南县| 喀喇| 彭山县| 固始县| 囊谦县| 夏邑县| 吐鲁番市| 澄城县| 绥化市| 岳阳市| 湘西| 临武县| 邵阳县| 临高县|