wundermatics

nick6352683

<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 “Formula” 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 “parent.”” 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’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 (==) – Returns 1 when two values are equal, 0 otherwise</li>
<li>Not equals (!=) – Returns 1 when two values are not equal, 0 otherwise</li>
<li>Greater than (>) – Returns 1 when the first operand is greater than the second, 0 otherwise</li>
<li>Greater than or equal (>=) – Returns 1 when the first operand is greater than or equal to the second, 0 otherwise</li>
<li>Less than (<) – Returns 1 when the first operand is less than the second, 0 otherwise</li>
<li>Less than or equal (<=) – 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 > 2 (returns 1)</li>
<li>10 < 2 (returns 0)</li>
<li>10 <= 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() – Uses standard mathematical rounding rules to round to nearest integer</li>
<li>ceil() – Rounds the value to the next higher integer</li>
<li>floor() – 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 “parent” prefix. See examples below:</p>
<p>Valid formula to use the value of field “foobar” defined inside the group “group2”:<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: “Sum(orderlines.amount)”” will return the sum of all the “amount” fields in the repeater field “orderlines”.</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’s perfectly OK to write a formula like: “Sum(orderlines.price * amount)”. This expression will walk over all lines in the “orderlines” repeater field, perform the calculation “price * amount” 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>


Calculated fields for ACF

A very pedantic developer. Thank You for your attention to detail.

Classwork!

Simple field math for Advanced Custom Fields.

Calculated fields for ACF vs Advanced Custom Fields: Extended