Simple field math for Advanced Custom Fields.

Calculated fields for ACF

<p>Adds a formula fields ot Advanced Custom Fields that allows you to perform simple math based on field values. Calculations are updated dynamically via ajax while editing a post on the backend post editor as well as on front end forms.</p>
<h3>Requirements</h3>
<p>Calculated fields requires Advanced Custom Fields 5.0 or later and works with Pro as well as the standard version.</p>
<h3>Frontend forms</h3>
<p>Beginning in version 1.2.3, Calculated fields for ACF supports frontend forms created using the acf_form() function (built in to Advanced Custom Fields).</p>
<h4>Formulas</h4>
<p>Calculated fields adds a new setting &#8220;Formula&#8221; to the the ACF field editor. Formulas supports referring to other fields in the same Field group using the field name. If a formula is added to a sub field inside a repeater field, the name refers to another sub field in the same repeater.</p>
<p>A sub field inside a repeater field can also refer to a parent field using the &#8220;parent.&#8221;&#8221; prefix.</p>
<p>A formula can contain the basic mathematical operations: plus (+), minus (-), multiply (*), division (/) and power of (^). Formulas can also contains functions like sin, cos, arcsin, log, ln, sqrt, abs. Parentheses are supported.</p>
<p>If an expression can&#8217;t be evaluated due to invalid syntax or referring to undefined field names, it will silently return zero.</p>
<p>Examples of valid expressions (note, no equal sign at the beginning):</p>
<ul>
<li>fieldA * 2</li>
<li>fieldA * fieldB</li>
<li>abs(fieldA) * (2 + sqrt(fieldB))</li>
<li>amount * parent.price</li>
</ul>
<h4>Conditional operators</h4>
<p>An expression can also contain a conditional expression that will return either 0 or 1. The supported operators are:</p>
<ul>
<li>Equals (==) &#8211; Returns 1 when two values are equal, 0 otherwise</li>
<li>Not equals (!=) &#8211; Returns 1 when two values are not equal, 0 otherwise</li>
<li>Greater than (&gt;) &#8211; Returns 1 when the first operand is greater than the second, 0 otherwise</li>
<li>Greater than or equal (&gt;=) &#8211; Returns 1 when the first operand is greater than or equal to the second, 0 otherwise</li>
<li>Less than (&lt;) &#8211; Returns 1 when the first operand is less than the second, 0 otherwise</li>
<li>Less than or equal (&lt;=) &#8211; Returns 1 when the first operand is less than or equal to the second, 0 otherwise</li>
</ul>
<p>Examples of valid expressions using conditional operators:</p>
<ul>
<li>10 == 10 (returns 1)</li>
<li>10 == 2 (returns 0)</li>
<li>10 &gt; 2 (returns 1)</li>
<li>10 &lt; 2 (returns 0)</li>
<li>10 &lt;= 10 (returns 1)</li>
</ul>
<h4>Rounding functions</h4>
<p>Round a decimal value to the nearest integer. Supported functions are:</p>
<ul>
<li>round() &#8211; Uses standard mathematical rounding rules to round to nearest integer</li>
<li>ceil() &#8211; Rounds the value to the next higher integer</li>
<li>floor() &#8211; Rounds the value to the next lower integer</li>
</ul>
<p>Examples of valid expressions using rounding functions:</p>
<ul>
<li>round(10.2) (returns 10)</li>
<li>round(10.9)  (returns 11)</li>
<li>round(10.888888 * 10) / 10 (returns 10.9)</li>
<li>ceil(10.2) (returns 11)</li>
<li>floor(10.2) (returns 10)</li>
</ul>
<p>Note that the round() function only takes one parameter and always round to an integer. If you need to round to a higher precision, multiply and divide as shown in third example above.</p>
<h4>Group fields (new from 1.2.4)</h4>
<p>Fields defined as part of a group, subfields, can be addressed using the group name as a prefix. Inside the group, a field defined on the parent level can be addressed using the &#8220;parent&#8221; prefix. See examples below:</p>
<p>Valid formula to use the value of field &#8220;foobar&#8221; defined inside the group &#8220;group2&#8221;:<br />
* group2.foobar + 10</p>
<p>Valid formula in a field inside a group (assuming the parent has a field named count):<br />
* parent.count * 22</p>
<h4>Array functions for repeater fields</h4>
<p>If repeater fields are used, a calculated field in the parent field group can summarize a specific repeater sub fields using the aggregation functions sum, count, average, min or max. For example, the expression: &#8220;Sum(orderlines.amount)&#8221;&#8221; will return the sum of all the &#8220;amount&#8221; fields in the repeater field &#8220;orderlines&#8221;.</p>
<p>The available array functions are:</p>
<ul>
<li>sum()</li>
<li>average()</li>
<li>count()</li>
<li>min()</li>
<li>max()</li>
</ul>
<p>Note that anything after the dot (.) in the aggregate expression is an expression in itself. It&#8217;s perfectly OK to write a formula like: &#8220;Sum(orderlines.price * amount)&#8221;. This expression will walk over all lines in the &#8220;orderlines&#8221; repeater field, perform the calculation &#8220;price * amount&#8221; and return the sum of all lines.</p>
<p>Note that when working with aggregate functions, parentheses can not be used. If you need to aggregate a more complex calculation, you should add an extra field in the repeater group and let the aggregate function work on this extra field.</p>
<h4>Data type and calculation order</h4>
<p>Calculated fields works with the assumption that all fields are defined as numeric in the ACF editor. Using a text field in a formula WILL PRODUCE UNPREDICTABLE RESULTS.</p>
<p>Calculations are made as the custom field is stored to the database. To minimize the impact of performance, Calculated fields rely on field order. A formula field can only refer to fields ordered BEFORE itself. A formula field that refers to a field ordered after it WILL PRODUCE UNPREDICTABLE RESULTS.</p>


Alternative Plugins for

Discover the Lists with Calculated fields for ACF

Victoria CRM