外掛說明

The “Calculated Fields Form” plugin allows you to create web forms with calculated fields, whose values are dynamically calculated based on other fields’ values in the web form.

The possibilities are unlimited. For example, you can create forms with financial calculations, date operations to create reservation forms, and calculate the product prices. The plugin includes text operations for editing, translation, or advertising services. There are more advanced operations available such as determining the distance between addresses or generating graphs. The resulting forms are 100% mobile responsive.

The most impressive thing is that you don’t need to hire a programmer to create the forms. With basic knowledge, you will have a professional form in just five minutes.

Creating a form is all visual. The “Calculated Fields Form” plugin includes a form editor with multiple controls. Such as text fields, numeric fields, currency fields, slider controls, email fields, radio buttons, checkboxes, container fields, page breaks to create multipage forms, QR code reader (thanks to the Html5-QRCode project), recording, and most importantly, calculated fields.

The form editor includes a list of controls, a property bar to easily edit field properties, a dashboard where you can design your forms, and the attributes for form configuration. Also, the plugin comes with multiple predefined layouts to change the forms’ appearance. If there are not enough predefined layouts for your project, there is a style editor to customize the form’s design.

The “Calculated Fields Form” plugin includes integration with popular page builders:

Classic WordPress Editor
Gutenberg Editor
Elementor
Page Builder by SiteOrigin
Beaver Builder
WPBakery Page Builder
DIVI Builder

For other editors, it is possible to insert the form into the pages via its shortcode. Each web form has an associated shortcode that allows you to insert it wherever you want.

Features

Main features:

Visual form builder with an intuitive and interactive interface.
Includes general-purpose controls such as radio buttons, checkboxes, menu lists, date fields, slider controls, numeric fields, text currency fields, etc.
Includes calculated fields whose values result from operations involving other form fields.
Insert as many calculated fields in the form as you need.
Contains an advanced formula editor associated with the calculated fields with syntax highlighting and error detection.
Features many operations modules: mathematical operations, operations with dates, financial operations, distance operations, text management, operations for calling remote services, etc. The calculated fields can identify numbers and prices within the values of the fields.
Distributed with several predefined forms that you can use as a starting point for your projects.
Includes several design templates.
Supports multi-pages forms by inserting page break controls between fields belonging to different pages.
Allows the grouping of fields inside container controls (Div and Fieldset).
Possible to define dependency rules between fields in the form, which is very useful in the design of wizards.

Other features:

From the plugin configuration page, it is possible to duplicate a form by pressing the “Clone” button associated with it. By cloning a form, you can reuse the work already done.
Includes a troubleshooting and optimization area.
Allows you to disable forms in the indexing process to improve the speed of the website.
Includes a version control in the forms to recover previous versions.

Predefined forms:

“Calculated Fields Form” is distributed with five predefined sample forms.

Simple Calculator Operations
Calculation with Dates (bookings with check-in and check-out dates)
Ideal Weight Calculator
Pregnancy Calculator
Lease Calculator

You can clone a sample form to implement your project, or create a new form from scratch.

Calculated Fields Form Commercial
The free version of the “Calculated Fields Form” plugin includes only basic functionality. Other distributions (Professional, Developer, and Platinum) are available with advanced functionalities, such as sending notification emails, integration with payment gateways and external services, controls for database’s connection (and connection to other data sources), complex operations, and many other features.

Features of the Professional version:

Includes all the features of the free version of the plugin.
Submit the data collected by the forms and store it on the website for review.
Send notification emails with the data collected by the form, as well as confirmation emails to the users.
Integrate the form with PayPal and calculate the amount to be charged through a calculated field.
Payments allow SCA (strong customer authentication), compatible with the new payment services (PSD 2) – Directive (EU).
Export and import forms between different WordPress sites.
Different mechanisms to protect forms, such as captcha, WordPress nonces, and honeypot fields.
Associate “Thank You” page with the form, where you can show a summary of the form’s submission.
Dashboard widget to show the last week’s submissions.
Cache the forms to increase the rendering speed.
Export the information submitted by the forms to a CSV file and use it with third-party tools such as Excel, OpenOffice, LibreOffice, or any other spreadsheet editor.

Features of the Developer version:

Includes all the features of the free and Professional version of the plugin.
Advanced controls that connect to different data sources (databases, CSV files, posts, taxonomies, user information, and JSON objects).
Financial operations module.
Date and time operations module.
Distance and travel time operations module uses “Google Maps”.
Chart.js operations module to generate charts with the form data. Uses the ChartJS.org library.
A script that allows the developer to save the data collected by the form in an external database.

Includes add-ons to extend the form features and make use of third-party plugins and external services

Server-Side Equations add-on: define server-side equations.
Verification Code add-on: verifies the user’s email by sending him a verification code and blocking the form’s submission until the verification code is entered.
WooCommerce add-on: integrate forms with WooCommerce products and calculate their prices, dimensions, and weight at the runtime.
SalesForce add-on: integrate the form with the SalesForce service.
WebHooks add-on: send the information collected by the form to a WebHook URL to open countless possibilities. By connecting your form to services such as Zapier, Microsoft Flow, IFTTT, Workato, and others, you can connect to hundreds of third-party services (e.g. Zoho CRM, Dropbox, Mailchimp, Google Drive, Facebook, Twitter, etc.).
User Permissions add-on: control the forms’ access, as well as allowing users to access and edit their data.
User Registration Form add-on: build a user registration form that captures the user’s basic information and metadata.
reCAPTCHA add-on: replace the basic captcha with Google reCAPTCHA to protect the forms.

Features of the Platinum version:

Includes all the features of free, Professional, and Developer versions of the plugin.

Extending features add-ons

CSV Generator add-on: export the information collected by the form to CSV files and attach these to the notification emails.
PDF Generator add-on: generate PDF files with the information collected by the forms and attach them to the notification emails.
Signature add-on: convert form fields into “Signature” fields, allowing the users to sign the form with a mouse or touchscreen.
Unique Fields Values add-on: verifies that the values entered by users have not been used in previous submissions.
iCal add-on: send iCal file in the notification emails to import the events into most popular calendars like Outlook and Google Calendar.
Upload Files add-on: add uploaded files to the media library and extend the file types accepted by WordPress.

Payment Gateways add-ons

PayPal Pro add-on: enable the payer’s credit card details to be entered directly through the website without any redirection to the PayPal website.
PayPal Checkout add-on: enable PayPal Checkout integration. Supports more payment methods than PayPal Standard.
Authorize.Net add-on: accept payments via Authorize.Net from the form.
Stripe add-on: accept payments via the Stripe payment gateway from the form.
Skrill Payments Integration add-on: integrate with the Skrill Moneybookers payment gateway.
TargetPay (iDeal) add-on add-on: integrate with iDeal, the popular Dutch payment method.
Mollie (iDeal) add-on: accept payments via iDeal.
RedSys / Servired / Sermepa add-on provides: a secure interface for accepting credit card payments from most banks in Spain.
PayTM add-on: a secure interface for accepting payments with credit cards, debit cards, net banking, wallets, and EMI.
SagePay add-on: a secure interface for accepting payments via SagePay.
Sage Payment add-on: a secure interface for accepting payments through a secure SSL checkout system for both bankcard and virtual check transactions.
eWay add-on: integrate with eWay payment gateway. eWay is a popular payment gateway in countries like Australia, New Zealand, Singapore, Hong Kong, and Malaysia.

Integration with third-party services add-ons

Google Places add-on: transform form fields into autocomplete address fields.
Autocomplete Places add-on: transform form fields into autocomplete address fields by using the Photon API.
Google Analytics add-on: generate usage reports in “Google Analytics” for the users’ actions.
DropBox Integration add-on: copy or move the uploaded files to a DropBox account.
WebMerge add-on: integrate the forms with FormStack documents (formerly WebMerge) to generate PDF and Office documents at runtime with the information collected by the web forms.
Sendinblue Contact add-on: integrate the forms with Sendinblue to add/update contacts with the information collected by the web forms.
PrintFriendly add-on: generate PDF files with the PrintFriendly API and attach the resulting files to the notification emails.
Mailchimp add-on: add new members to the MailChimp account.
Mautic add-on: add new contacts (or update existing ones) into the Mautic Service.
HubSpot add-on: add/update contacts in HubSpot, using the information collected by the form.
Twilio add-on: send notification messages (SMS) in the forms’ submissions.
ip2location add-on: identify the users’ data using the ip2location databases.

Integration with third-party plugins add-ons

Easy Digital Downloads add-on: integrate the forms into Easy Digital Downloads products and calculate their prices at the runtime.
Emma add-on: add new members to the Emma service.
MailPoet add-on: add new subscribers to MailPoet’s Mailing Lists (MailPoet versions 2 and 3).
AffiliateWP add-on: integrate the forms with the AffiliateWP plugin.
The Events Calendar add-on: creates new events, venues, categories, tags, and organizers in The Events Calendar plugin with the information collected by the form.

Please keep the plugin updated. Updates contain bug fixes as well as new features. The WordPress directory distributes the updates for the free version of the plugin. But for commercial versions, it would be necessary to register your copy of the plugin. The following link describes the registration process: CLICK HEREThis section mainly contains notes on features of the form builder that are too detailed to include in the main description.

Conditional rules

It is possible to show or hide form fields (dependent fields) based on the options selected in checkbox fields, radio buttons, the options selected in dropdown menus, or the result of calculated fields.

The value of a dependent field is zero when it is hidden/disabled. The plugin excludes the disabled form fields from the submission.

Additional details about the use of dependencies

Predefined values

The predefined values in the fields have two possible uses:

1- To fill the field by default. This makes it easier for the end-user to enter values.

2- Hint of the values to be entered in the field (like “Enter your name”). To use the predefined value as a placeholder, you must tick the “Hide predefined value on click” checkbox. The value will disappear once the user starts filling in the field. The calculated fields’ equations ignore placeholders.

The “User Instructions” attribute

The “User instructions” attribute in the field settings allows you to instruct the user on how to fill in the field. By default, the instructions appear as smaller text on the public website. But they can be configured as tooltips.

Adding CSS layout keywords

The “Add CSS layout keywords” attribute in the fields settings allows you to apply CSS styles to fields. You must only enter the name of the CSS class names, and not their definitions.

You can define the CSS classes via the “Customize Form Design” attribute in the “Form Settings” tab. This attribute contains a CSS editor with syntax highlighting and error checking.

If you want to assign several class names to the field, separate them by space characters.

The plugin includes multiple predefined classes that you can assign to the form fields.

More information about the form’s design can be found by reading the following post in the plugin’s blog:

Customizing the form’s design

The classes listed below allow you to align two, three, or four fields on the same line:

column2
column3
column4

For example, if you want to put two fields on the same line, give both fields the class name “column2”.

There are other variants for displaying several fields on the same line, such as container fields (Div or Fieldset). Container fields allow you to select the number of columns in your configuration. The following post describes all the alternatives for positioning the fields in the form:

Formatting the form (distributing the fields in columns)

Multi-page form

To create multi-page forms, you must insert “Page break” controls between fields belonging to different pages.

When the user presses the “Next Page” button, the plugin validates the fields in the current form. If there is any validation error (such as an unfilled required field), the plugin stops the “Next page” action.

Hidden calculated fields

Calculated fields include a checkbox in the configuration that allows them to be hidden from the public website. This feature is essential in those fields that are used to calculate intermediate values or when we want to show the results only in emails or thank you pages.

Equation / Formula format for calculated fields

Below, some possible formulas are included as examples, but the possibilities are endless.

With simple mathematical operations:

fieldname1 + fieldname2

fieldname1 * fieldname2

fieldname1 / fieldname2

fieldname1 - fieldname2

fieldname1 - fieldname2

With mathematical operations involving multiple fields and grouped fields:
```
fieldname1 * (fieldname2 + fieldname3)
```
With rounding operations. Round the result to two decimal places:
```
PREC(fieldname2 / fieldname3, 2)
```
There are infinite number of formulas that can be created using complex structures. For example, the following formula includes conditional statements:
```
(function () {
if (100 < fieldname3) return fieldname1 + fieldname2;
if (fieldname3 <= 100) return fieldname1 * fieldname2;
})();
```
For complex formulas/equations you must use the function format with return statement to return the result to the calculated field:
```
 (function () {
    var result = 0;
    /* Your code here */
    return result;
}) ();
```

Operations and operators to use in equations/formulas

One of the “Calculated Fields Form” strengths is the ability to use any valid JavaScript code to implement the equations/formulas.

However, the plugin includes a wide variety of operations and operators to simplify the development process.

Mathematical Operations and Operators

Conditional Operations

Field Handling Operations

Operations for interacting with external services

Operations for handling URLs and query strings

In addition to the operation modules listed above, the Developer and Platinum versions of the plugin include additional modules:

Date Time Operations

Financial Operations

Distance and Travel Time Operations

Operations to generate charts

Controls available in the form generator of the “Calculated Fields Form”

The complete list of controls is available from this link: CLICK HERE

Create JavaScript variables from parameters received by “GET” or “POST”, “SESSION” variables, or “COOKIES” to use in the equations

The plugin includes the shortcode [CP_CALCULATED_FIELDS_VAR] to generate JavaScript variables from parameters received by “GET” or “POST”, “SESSION” variables, or “COOKIES”:

[CP_CALCULATED_FIELDS_VAR name="..."]

In the shortcode, you must replace the “…” symbols with the name of the parameter or variable. The variables are created as properties of the cff_var variable. For example, in the [CP_CALCULATED_FIELDS_VAR name=”my_var”] shortcode, you can access the variable value from the equations by using cff_var[‘my_var’], or cff_var.my_var

For example:

[CP_CALCULATED_FIELDS_VAR name="varname"]

You can use the variables generated through the shortcode [CP_CALCULATED_FIELDS_VAR] in the formulas of the calculated fields: fieldname1*cff_var.varname

The complete list of parameters accepted by the variables shortcode is available at the following link: CLICK HERE

Tips for calculating prices

One of the most frequent uses of our plugin is for price calculation. When displaying the price of a product, you may want to split the form into two pages. The first page would request the information needed to calculate the price, and the second page would include the calculated field with the final price. Also, you could use the “Instruct. Text” fields to indicate the terms, conditions, and validity period of the offer.

Note that you can make the “Instruct. Text” fields dependent on the calculated value. This allows you to vary the text displayed to the user depending on the calculated price, as the terms, conditions, or offers often depend on the transaction amount.

ClassicPress

This plugin is compatible with ClassicPress.

Add-ons

The add-ons are only distributed with the Developer and Platinum versions of the plugin.

The plugin lists the add ons in the “Add-ons area” of the settings page. To enable the add-ons, you must tick their corresponding checkbox and press the “Activate/Deactivate Add-ons” button.

Server-Side Equations add-on – included in the Developer and Platinum versions of the plugin

Define equations with PHP code on the server-side. The calculated fields call the server-side equations via AJAX.

外掛說明

Features

Main features:

Other features:

Predefined forms:

Features of the Professional version:

Features of the Developer version:

Features of the Platinum version:

Conditional rules

Predefined values

The “User Instructions” attribute

Adding CSS layout keywords

Multi-page form

Hidden calculated fields

Equation / Formula format for calculated fields

Operations and operators to use in equations/formulas

Controls available in the form generator of the “Calculated Fields Form”

Create JavaScript variables from parameters received by “GET” or “POST”, “SESSION” variables, or “COOKIES” to use in the equations

Tips for calculating prices

ClassicPress

Add-ons

Server-Side Equations add-on – included in the Developer and Platinum versions of the plugin

Verification Code add-on – included in the Developer and Platinum versions of the plugin

Unique Fields Values add-on – included in the Platinum version of the plugin

WooCommerce add-on – included in the Developer and Platinum versions of the plugin

Easy Digital Downloads add-on – included in the Platinum version of the plugin

SalesForce add-on – included in the Developer and Platinum versions of the plugin

WebHook add-on – included in the Developer and Platinum versions of the plugin

User Permissions add-on – included in the Developer and Platinum versions of the plugin

User Registration Form add-on – included in the Developer and Platinum versions of the plugin

reCAPTCHA add-on – included in the Developer and Platinum versions of the plugin

Google Analytics add-on – included in the Platinum version of the plugin

PayPal Pro add-on – included in the Platinum version of the plugin

PayPal Checkout add-on – included in the Platinum version of the plugin

Upload Files add-on – included in the Platinum version of the plugin

DropBox Integration add-on – included in the Platinum version of the plugin

ip2location add-on – included in the Platinum version of the plugin

Google Places add-on – included in the Platinum version of the plugin

Autocomplete Places add-on – included in the Platinum version of the plugin

Signature add-on – included in the Platinum version of the plugin

iCal add-on – included in the Platinum version of the plugin

CSV Generator add-on – included in the Platinum version of the plugin

PDF Generator add-on – included in the Platinum version of the plugin

WebMerge add-on – included in the Platinum version of the plugin

Sendinblue Contact add-on – included in the Platinum version of the plugin

PrintFriendly add-on – included in the Platinum version of the plugin

Mailchimp add-on – included in the Platinum version of the plugin

Mautic add-on – included in the Platinum version of the plugin

HubSpot add-on – included in the Platinum version of the plugin

Emma add-on – included in the Platinum version of the plugin

Twilio add-on – included in the Platinum version of the plugin

MailPoet add-on – included in the Platinum version of the plugin

AffiliateWP add-on – included in the Platinum version of the plugin

The Events Calendar add-on – included in the Platinum version of the plugin

Authorize.Net add-on – included in the Platinum version of the plugin

Stripe add-on – included in the Platinum version of the plugin

Skrill Payments Integration add-on – included in the Platinum version of the plugin

TargetPay (iDeal) add-on – included in the Platinum version of the plugin

Mollie (iDeal) add-on – included in the Platinum version of the plugin

RedSys / Servired / Sermepa add-on – included in the Platinum version of the plugin

PayTM add-on – included in the Platinum version of the plugin

SagePay add-on – included in the Platinum version of the plugin

Sage Payment add-on – included in the Platinum version of the plugin

eWay add-on – included in the Platinum version of the plugin

螢幕擷圖

適用於區塊編輯器

安裝方式

常見問題集

Q: Is the “Calculated Fields Form” plugin compatible with “Autoptimize”?

Q: Is the “Calculated Fields Form” plugin compatible with “Plugin Organizer”?

Q: What control types are included in the plugin?

Q: Where can I publish a calculated fields form?

Q: Can I send the form data and calculated results by email?

Q: Which calculation operations are available with the plugin?

Q: How can I round the calculated result to 2 decimal digits?

Q: Which are the operations with date values that the plugin allows?

Q: Are there financial operations included in the plugin?

Q: How can I calculate a payment’s amortization?

Q: Can I create global variables to be used in the equations?

Q: How to populate the form fields with URL parameters?