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.

Johann Heyne

<p>The Table Field plugin is an Add-on and enhances the functionality of the <a href="https://www.advancedcustomfields.com" rel="nofollow ugc">Advanced Custom Fields (ACF) plugin</a> and the <a href="https://wordpress.org/plugins/secure-custom-fields/" rel="ugc">Secure Custom Fields plugin</a> with easy-to-edit tables.</p>
<p>This plugin requires the <a href="https://www.advancedcustomfields.com" rel="nofollow ugc">Advanced Custom Fields plugin</a> or the <a href="https://wordpress.org/plugins/secure-custom-fields/" rel="ugc">Secure Custom Fields plugin</a>!</p>
<p>The table field works also with the ACF repeater and flexible field types and supports the <a href="https://www.advancedcustomfields.com/blog/acf-5-8-introducing-acf-blocks-for-gutenberg/" rel="nofollow ugc">ACF Blocks for Gutenberg</a></p>
<h4>Features</h4>
<ul>
<li>Table Header (Option)</li>
<li>Table Caption (Option)</li>
<li>Support for ACF Gutenberg blocks</li>
<li>Add and remove table columns and rows</li>
<li>Change order of columns and rows by dragging</li>
<li>To move to the next cells editor press key: tab</li>
<li>To move to the previous cells editor press key: shift + tab</li>
</ul>
<h3>Translations</h3>
<ul>
<li>English – default, always included</li>
<li>German: Deutsch – immer dabei!</li>
<li>Danish: Dansk – altid der!</li>
<li>Polish: Polski – zawsze tam jest!</li>
</ul>
<p><em>Note:</em> Please <a href="https://translate.wordpress.org/projects/wp-plugins/advanced-custom-fields-table-field" rel="nofollow ugc">contribute your language</a> to the plugin to make it even more useful.</p>
<h3>PRO</h3>
<p>There is also a <a href="https://www.acf-table-field.com?src=wp" rel="noopener nofollow ugc">Table Field Pro</a> Add-on for the Advanced Custom Fields and Secure Custom Fields plugins.</p>
<ul>
<li>Setup custom default table</li>
<li>Setup minimum and maximum amount of rows and columns</li>
<li>Setup style choice for the table and parts of the table</li>
<li>Restrict table editing functionalities</li>
<li>Configurable optional WordPress editor for cell content editing</li>
<li>Table head and foot rows</li>
<li>Stub column</li>
<li>Rowspan and colspan</li>
<li>Improved way for moving rows and columns</li>
<li>Disable moving individual columns</li>
<li>Support for REST-API</li>
<li>Support for WP GraphQL</li>
<li>Support for third-party plugins</li>
</ul>
<p>The Pro plugin can run in parallel and you can change an existing field with field type “Table” to the field type “Table Pro” as required.</p>
<p><a href="https://www.acf-table-field.com?src=wp" rel="noopener nofollow ugc">to the plugin website</a></p>


Table Field Add-on for ACF and SCF

This plugin handles a classic, seemingly simple, but surprisingly (or possibly annoyingly) complex development task of entering a table of data, very smoothly (in my experience).

Additionally, I encountered a bug in one of the most recent version, while implementing ACF Blocks using the ACF Table Field Plugin, and the Developer not only replied, but had a fix within 24hrs.  While, I'm sure other bugs might take a longer time to resolve, I'm grateful for the quick response and turn around in my experience.

Thank you!

Very Useful Plugin, and Responsive Dev :D

Was looking for a clean way to insert tables anywhere in my website. This is the solution.

Perfect

A Table Field Add-on for the Advanced Custom Fields and Secure Custom Fields Plugin.

Calculated fields for ACF vs Table Field Add-on for ACF and SCF