!Attention: Calculator Add-On requires Form Maker Pro version 2.8.32 and higher: if you are using an older version, please update your plugin. To update the plugin please login at web-dorado.com, go to My Products and download the latest version.
You should install Form Maker Calculator add-on as a WordPress plugin. In your WordPress back end go to Plugins, press Add new. Here select the downloaded zip file of the add-on and press Install Now. After the installation is completed press Activate button. Alternatively you can extract the add-on’s zip file and upload to your wp-content/plugins folder via FTP, then enter Plugins section and press Activate.
To activate calculator feature go to Form Maker>Manager>Your form>Form Options>Calculator. Enable the add-on.
After that you need to choose the “Calculated field”. This will be the field which will display the calculated amount. Only the following field types can be used as calculated fields- Simple text (Text), Hidden field (Text) and Amount(Payment). Note that it is suggested to make these fields readonly. Amount and Simple Text fields will have Readonly listed as a field attribute checkbox. If you tick the checkbox the users will not be able to change calculated value, otherwise the user will be able to do so.
When the calculated field is selected you should press Add button (+). A textarea will open up where you can fill in operation equation. You can choose the symbol accompanying the value, e.g. add currency sign or fill in textual option of the symbol, e.g. USD. This can be useful in cases you don’t want to include currency symbol coming with Payment field. You can disable automatic currency within Amount field type.
Operands. Here you will see all fields which can be inserted within operation text area.The following types of fields can be used: Simple text (text), Single and Multiple choice options, Select, Date and Time. Note that though you can calculate Amount for PayPal field, the operands of the calculation should be non-Payment fields.
Operators. There are two types of operations which can be processed:
- Mathematical operations. The list includes addition, subtraction, multiplication, division, opening and closing brackets, decimal point and list of math functions:
- ABS. Returns the absolute value of the number passed as parameter. Format of usage: ABS(%field%), e.g. if you have field value of -30.3, ABS (-30.3) should be used for returning 30.3.
- CEIL. Returns the next higher number that is greater than or equal to the number passed as parameter. Format of usage: CEIL(%field%), e.g. if you have CEIL(30.7) you will get 31.
- FLOOR. Returns the next lower number that is less than or equal to the number passed as parameter․ Format of usage: FLOOR(%field%), e.g. if you have FLOOR(30.7) you will get 30.
- ROUND. Returns a number that follows rounding rules. If the value of the passed parameter is greater than or equal to x.5, the returned value is x+1; otherwise the returned value is x․ Format of usage: ROUND(%field%) or ROUND (%field%, [precision]). The default value for precision is 0, e.g. ROUND(50.123) or ROUND(50.123, 0) will be 50, ROUND(50.123, 2) will return 50.12.
- LOG. Returns the natural logarithm (base e) or logarithm with fixed base of the number passed as parameter․ Format of usage: LOG(%field%) or LOG (%field1%,%field2%)․ LOG(25) or LOG(9,3) will return 2.
- POW. Returns the value of the first parameter raised to the power of the second parameter․ Format of usage: POW(%field1%,%field2%), e.g. with 2 and 5, POW(5,2) will be equal to 25.
- SQRT. Returns the square root of the number passed as parameter․ Format of usage:SQRT(%field%), e.g. SQRT(4) will return 2.
- MAX. Returns the greater value of the listed parameters․ Format of usage: MAX(%field1%,%field2%, %field3%) , e.g. MAX(4,2,3) will return 4.
- MIN. Returns the lesser value of the listed parameters․Format of usage:MIN(%field1%,%field2%,%field3%), e.g. MAX(4,2,3) will return 2.
- IF. Checks whether a condition is met, and returns one value if true, and another if false: (logical_test ? value_if_true : value_if_false), e.g. %field1% is 10, (%field%<25?5:3) will return 5.
- OR. Checks whether any of arguments are true. Returns false only if all arguments are false: (x or y), e.g. (%field1%>3 or %field2%<3 )
- AND. Checks whether all arguments are true, and return true if all values are true: (x and y), e.g. (%field1%>3 and %field2%<3)
- NOT. Changes false to true, or true to false: not(x), not(true) returns false.