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.

Vitaly Nikolaiev

whatwedo

Marc Wieland

<p>We analyze the post of the selected post types against the ACF groups in use. Afterwards we remove all data from deleted groups.<br />
There’s a dry run available (discovery) to see how many fields would get removed. On the actual cleanup you get prompted because it can’t be undone (so make a backup first).</p>
<h3>Contribute</h3>
<p>Developed with ♥ by <a href="https://whatwedo.ch" rel="nofollow ugc">whatwedo</a> in Bern.<br />
Thanks to <a href="https://github.com/TrilipuT" rel="nofollow ugc">TrilipuT</a> for contributing.</p>
<p>This plugin was initially created for our own usage to clean a big database from old ACF data.</p>
<p>Check out the <a href="https://github.com/whatwedo/whatwedo-acf-cleaner" rel="nofollow ugc">GitHub repository</a> and submit pull requests or open issues</p>


whatwedo ACF Cleaner


Does what it says on the tin. I needed something to clear out ACF fields from a previous theme, and this did the job quickly and efficiently.


Does what it says on the tin

Cleanup old metadata created by Advanced Custom Fields.

Calculated fields for ACF vs whatwedo ACF Cleaner