=== Calculated fields for ACF === Contributors: wundermatics Tags: acf, admin Requires at least: 4.7 Tested up to: 5.3 Requires PHP: 5.6 Stable tag: 1.1.3 License: GPLv2 or later Simple field math for Advanced Custom Fields. == Description == Adds a formula fields ot Advanced Custom Fields that allows you to perform simple math based on field values. From version 1.1 calculations are done while editing fields in the admin screen. When the post is saved, all fields are recalculated before being saved. == Requirements == Calculated fields requires Advanced Custom Fields 5.0 or later and works with Pro as well as the standard version. = Formulas = 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. A sub field inside a repeater field can also refer to a parent field using the "parent."" prefix (new in version 1.1). 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. If an expression can't be evaluated due to invalid syntax or referring to undefined field names, it will silently return zero. Examples of valid expressions (note, no equal sign at the beginning): * fieldA * 2 * fieldA * fieldB * abs(fieldA) * (2 + sqrt(fieldB)) * amount * parent.price = Array functions for repeater fields = 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". The available array functions are: * sum() * average() * count() * min() * max() 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. 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. = Data type and calculation order = 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. Calculations are made as the custom field is stored to the database. To minimize the impact of performance, Calculated fields rely on field order. Any formula field must be ordered AFTER the fields it refers to. Using fields that are defined before your calculated field WILL PRODUCE UNPREDICTABLE RESULTS. == Installation == = Minimum requirements = * PHP 7.3 or newer Calculated fields will for ACF run on PHP 5.6 or newer, but we highly recommend following the official [WordPress guidelines](https://wordpress.org/about/requirements/) that currently recommends PHP 7.3. = Install from within WordPress = * Visit the plugins page within your dashboard and select ‘Add New’ * Search for ‘Calculated Fields for ACF’ * Click 'Install' and wait until the button caption changes to 'Activate' * Click 'Activate' = Install manually = * Download the zip file * Upload the calculated-fields-for-acf folder from the zip to the /wp-content/plugins/ directory on your server * Navigate to the Plugins page in WordPress admin and locate the plugin Click 'Activate' == Changelog == = 1.1.3 = * Fixes issue with ajax recalculation not triggered by removing a row from a repeater field * Fixes issue with ajax recalculation not triggered by changing a dropdown/select field * Fixes multiple issues related to ACF Blocks. Should work as expected now, but we're considering support for ACF blocks "beta" for now = 1.1.1 = * Fixes typo in javascript file that causes more ajax recalculations that needed * Fixes issue with some PHP versions and empty object keys (https://bugs.php.net/bug.php?id=46600) * Fixes issue with ACF enumerating rows using alphanumeric keys in some cases (older versions) = 1.1.0 = * Adds in-edit recalculations. Calculated fields are updated while still in edit mode * Adds read only option. All fields can be set as read only in the ACF field editor (not just calculated fields) * Adds parent. prefix for formulas in sub fields in a repeater field. = 1.0.1 = * Fixes issue with complex custom fields types that can't be converted to string/numeric