Calculated Fields Form

Description

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, 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.

  1. Simple Calculator Operations
  2. Calculation with Dates (bookings with check-in and check-out dates)
  3. Ideal Weight Calculator
  4. Pregnancy Calculator
  5. 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 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.
  • Unique Fields Values add-on: verifies that the values entered by users have not been used in previous submissions.
  • Easy Digital Downloads add-on: integrate the forms into Easy Digital Downloads products and calculate their prices at the runtime.
  • Google Analytics add-on: generate usage reports in “Google Analytics” for the users’ actions.
  • 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.
  • Upload Files add-on: add uploaded files to the media library and extend the file types accepted by WordPress.
  • DropBox Integration add-on: copy or move the uploaded files to a DropBox account.
  • ip2location add-on: identify the users’ data using the ip2location databases.
  • 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.
  • Signature add-on: convert form fields into “Signature” fields, allowing the users to sign the form with a mouse or touchscreen.
  • iCal add-on: send iCal file in the notification emails to import the events into most popular calendars like Outlook and Google Calendar.
  • 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.
  • 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.
  • 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.
  • Emma add-on: add new members to the Emma service.
  • Twilio add-on: send notification messages (SMS) in the forms’ submissions.
  • 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.
  • 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.

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. It will be the same name for the JavaScript variable.

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*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.

CLICK HERE for additional information

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

The “Verification Code” add-on allows verifying the users’ emails by sending a verification code and blocking the form’s submission until a valid code is entered.

CLICK HERE for additional information

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

The “Unique Fields Values” add-on verifies that the values entered by users have not been used in previous submissions. It allows to enter simple and complex verification rules (one or multiple fields separated by comma symbols).

CLICK HERE for additional information

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

Integrate the forms created by the “Calculated Fields Form” with WooCommerce products and calculate their prices, weights, dimensions, and more at the runtime.

CLICK HERE for additional information

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

Integrate forms created by the “Calculated Fields Form” with the Easy Digital Downloads products, and calculate their price dynamically at the runtime.

CLICK HERE for additional information

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

Add new leads to a SalesForce account using the data collected by the forms.

CLICK HERE for additional information

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

Post the information collected by the forms to WebHook URLs.

Through connecting the forms created by the plugin with services like Zapier, Microsoft Flow, Workato, or IFTTT (and many others), you will have access to hundreds of third-party services, like Zoho CRM, Dropbox, Mailchimp, Evernote, Google Drive, Facebook, Twitter, and more than 300 services https://zapier.com/zapbook/apps/, https://flow.microsoft.com/, https://ifttt.com/discover

CLICK HERE for additional information

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

Control access to forms. Access can be restricted to registered users, users with certain roles, or to specific users.

The add-on adds a new shortcode to the plugin to list the data submitted by the logged-in user (it is possible to insert the new shortcode into the user’s profile) and assign user permissions to edit their information or delete an entry.

Limit the number of submissions (e.g. one submission per form/user).

CLICK HERE for additional information

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

Build user registration forms. The form can collect basic user information and metadata required by other plugins.

CLICK HERE for additional information

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

Protect forms using Google reCAPTCHA instead of the basic captcha distributed with the plugin, as reCAPTCHA is more visual and intuitive than traditional captchas.

CLICK HERE for additional information

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

Generate usage reports in “Google Analytics” for the users’ actions.

CLICK HERE for additional information

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

Allow the user to enter their credit card details directly on your website without redirecting them to the PayPal website. Once the user has filled the form fields and clicked the submit button, the payment is processed and the posted data (excluding the credit card information) is stored in the WordPress database.

CLICK HERE for additional information

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

Every commercial version of the plugin includes the “Upload File” control to upload files from the form. However, the “Upload Files” add-on allows the uploaded files to be added to the Media Library and be accessed from the pages and posts of the website.

WordPress restricts the file types that can be uploaded. The “Uploads Files” add-on allows the list of accepted files to be extended.

CLICK HERE for additional information

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

Copy or move files uploaded through the forms to a DropBox account.

CLICK HERE for additional information

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

Use the ip2location databases to identify additional user information based on their IP. Address such as country, city, coordinates, weather station, time zone, ZIP code, etc.

CLICK HERE for additional information

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

Transform fields into autocomplete address fields calling the Google Places API.

CLICK HERE for additional information

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

Transform fields into autocomplete address fields by calling the Photon API.

CLICK HERE for additional information

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

Transform fields into “Signature” fields to allow the users to sign the form with their mouse or touchscreens.

CLICK HERE for additional information

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

Send the users iCal files attached to the confirmation emails to import events into the most popular calendars like Outlook and Google Calendar.

CLICK HERE for additional information

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

Export the information collected by the form to CSV files and attach them to the notification emails.

CLICK HERE for additional information

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

An experimental add-on that generates PDF files with the information collected by the forms and attaches them to the notification emails.

CLICK HERE for additional information

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

Integrate the forms with the FormStack Documents service (formerly WebMerge) to generate PDF and Office documents with the information collected from the form.

CLICK HERE for additional information

Integrate the form with the Silverpop service (now: IBM Watson Campaign Automation) CLICK HERE for additional information

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

Send the information collected by the forms to PrintFriendly and attach the resulting PDF files to the notification emails.

CLICK HERE for additional information

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

Add new members to the MailChimp lists with the information collected by the form.

CLICK HERE for additional information

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

Add/update contacts in the Mautic service with information collected by the forms.

CLICK HERE for additional information

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

Add/update HubSpot contacts with information collected by the forms.

CLICK HERE for additional information

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

Connect the forms to the Emma service to add new members to Emma groups.

CLICK HERE for additional information

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

Send notification messages (SMS) through Twilio in the form’s submissions.

CLICK HERE for additional information

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

Adds subscribers to MailPoet Mailing Lists (MailPoet versions 2 and 3).

CLICK HERE for additional information

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

Integrate the forms with the “AffiliateWP” plugin.

CLICK HERE for additional information

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

The Authorize.net Server Integration Method (Authorize.net SIM) is a hosted payment processing solution that handles all of the steps in processing a transaction.

CLICK HERE for additional information

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

The Stripe Payments add-on (www.stripe.com) provides a way to accept all major cards from customers around the world.

CLICK HERE for additional information

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

An interface for accepting payments through secure pages.

You can accept cards, more than 20 local payment methods, and over 80 direct bank transfer connections with a single integration.

CLICK HERE for additional information

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

Integrate with iDeal, the most popular Dutch payment method. The integration is made via TargetPay: https://www.targetpay.com/info/ideal?setlang=en

CLICK HERE for additional information

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

Integrate with iDeal, the popular Dutch payment method.

CLICK HERE for additional information

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

A secure interface for accepting credit card payments through most banks in Spain (Sabadell, Banco Popular, BBVA, Santander, Bankia-Caixa, Bankinter, etc.)

CLICK HERE for additional information

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

A secure interface for accepting payments through credit cards, debit cards, net banking, wallets, and EMI. With over 100 million PayTM users in India, your customers will appreciate the option to pay with their trusted PayTM Wallet.

CLICK HERE for additional information

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

A secure interface for accepting payments through SagePay.

CLICK HERE for additional information

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

An interface for accepting payments through a secure SSL-checkout system for both bank cards and virtual check transactions. All authorized and approved transactions will be delivered to your current bank card and/or virtual check batches, viewable within the Virtual Terminal for order processing and settlement.

CLICK HERE for additional information

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

eWay is a popular payment gateway in countries like Australia, New Zealand, Singapore, Hong Kong, and Malaysia. The eWay add-on implements the integration with the “eWay Responsive Shared Page” for accepting credit card payments, even Paypal and digital wallets via eWay.
CLICK HERE for additional information

Screenshots

  • Calculated forms list
  • Inserting the form using the Classic Editor
  • Inserting the form using the Gutenberg Editor
  • Inserting the form using Elementor
  • Inserting the form using Page Builder by SiteOrigin
  • Inserting the form using Beaver Builder
  • Inserting the form using WPBakery Page Builder
  • Sample calculated form
  • Calculated field settings
  • Advanced equations editor
  • Calculator Form builder
  • Editing general fields
  • Available designs
  • Add-ons section
  • WooCommerce add-on
  • SalesForce add-on
  • WebHook add-on, and its integration with Zapier

Blocks

This plugin provides 2 blocks.

  • Insert CFF
  • Create var from POST, GET, SESSION, or COOKIES

Installation

To install the “Calculated Fields Form” plugin, please follow these steps:

  1. Download the .zip the Calculated Fields Form plugin.
  2. Go to the Plugins section on your WordPress.
  3. Press the “Add New” button at the top of the section.
  4. Press the “Upload Plugin” button and then select the zipped file downloaded in the first step.
  5. Finally, install and activate the plugin.

To build a form, go to the menu option “Calculated Fields Form”

To insert the calculated / contact form into some content or post, use the corresponding form’s shortcode. Each web form has associated a shortcode.

FAQ

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

A: Yes, it is

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

A: Yes, it is

Q: What control types are included in the plugin?

A: The Calculated Fields Form’s page contains detailed information about each field in the plugin: Click Here

Q: Where can I publish a calculated fields form?

A: You can publish the forms into pages and posts. The shortcode can be also placed into the theme templates. Read more

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

A: This feature is included in the commercial versions of the plugin.

The commercial versions of the plugin allow processing the forms’ submissions, send notification emails, and integrate the forms with payment gateways. Comparing the different versions of the plugin

Q: Which calculation operations are available with the plugin?

A: The Free and Professional versions of the plugin include the Mathematical operations module, logical operations, the managing fields module, and the third-party connection module. Other interesting operations modules are distributed only with the Developer and Platinum versions of the plugin: the Date/Time operations module, Financial operations module, Distance module, and Server Side operations module. Read more

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

A: Use the “PREC” operation for rounding numbers with decimal places.

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

A: List and description of date/time operations

Q: Are there financial operations included in the plugin?

A: List and description of financial operations

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

A: The CALCULATEAMORTIZATION is the most complex operation in the plugin and deserves its own section. Please, visit the following link to read a detailed description of its use:

How calculate an amortization?

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

A: Yes, it is possible to create global javascript variables through the form shortcode, or by using the variables shortcode: CP_CALCULATED_FIELDS_VAR

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

A: Please, read the answer in the FAQ entry: Click Here

Q: How to use a session variable in the equations?

A: Please, read the answer in the FAQ entry: Click Here

Q: How to use cookie variables in the equations?

A: Please, read the answer in the FAQ entry: Click Here

Q: How to use a parameter passed by POST in the equations?

A: Please, read the answer in the FAQ entry: Click Here

Q: How to use a parameter passed by GET in the equations?

A: Please, read the answer in the FAQ entry: Click Here

Q: If I’ve inserted multiple shortcodes for the same form in a webpage, each of them defines an additional variable with the same name. How to access the value of the variable defined in its shortcode from the equations in the form?

A: Please, visit the following link to the plugin documentation. Pay attention to the definition of the new variables as a hash of the values: Click Here

Q: How to initialize a date field?

A: Initializing date/time fields

Q: How to change the language on the datepicker?

A: There are different alternatives, directly through the form’s structure or uploading a new file to the plugin’s folder. Please, visit the following link to read the instructions: Click Here

Q: How to create relationships between date fields?

A: It is possible to define the min date, max date, or select a date dynamically based on the value of another date field.

Create relationships between date fields

Q: Is there a way to format the form in a table structure (various fields in the same line)?

A: Yes, that’s possible. Please, read the following post in the plugin’s blog: Formatting the form (distributing the fields in columns)

Q: How to convert a button field into a submit button?

A: To convert a button’s field in a submit button, enter the following code as its onclick event:

    jQuery(this).closest('form').submit();

Q: How to display an image in a checkbox or radio button?

A: Displaying images in checkboxes and radio buttons

Additionally, to hide the checkboxes and radio buttons, for using only the images for choosing, enter the following styles definition into the “Customize Form Design” attribute in the “Form Settigns” tab:

fbuilder input[type=”checkbox”]{display:none !important;}

Q: How to replace the image displayed in a Media field based on the radio buttons selection?

A: How to replace the image displayed in a Media Field?

Q: In which order does the plugin evaluate the equations associated with the calculated fields?

A: Evaluating the equations

Q: Can I link the calculated amount to a PayPal payment form?

A: That feature is available in the commercial versions of the plugin.

Additional details in the “PayPal Payment Configuration” section in the documentation page of the plugin.

Q: Non-Latin characters are not displayed in the form. Is there a solution?

A: Please, read the following entry in the plugin’s FAQ: [Click Here]](http://cff.dwbooster.com/faq#q225 “utf-8”)

Q: The calculated form doesn’t appear on the public website. What is the solution?

A: Please, change the “Script load method” from “Classic” to “Direct” in the “troubleshoot area” located below the forms list in the settings page of the plugin.

The optimization plugins are another possible cause of the issue. Please, read additional details in the FAQ page of the plugin.

Q: How to create a multipage form?

A: Insert “Page Break” between the fields belonging to different pages.

Q: How to display the selected values in the slider control?

A: Displaying selected values in slider control

Q: How to create new validation rules?

A: Create new validation rules

Q: How to display a summary of entered data in the form?

A: Insert a summary control in the form, and enter the names of the fields to display in the summary through its settings.

Q: How to highlight the fields in the summary control?

A: Highlighting fields

Q: Can I display a summary of the fields on the “Thank You” page?

A: Yes, that’s possible by using the shortcode for results. Additional details HERE

Q: How can I apply CSS styles to the form fields?

A: Applying CSS styles to the form fields

Q: Can I modify any of the predefined templates included with the plugin?

A: Yes, that’s possible: Modifying the predefined templates

Q: How to create a new template to use with my forms?

A: Creating new templates

Q: How to hide the fields in the forms?

A: Hiding the fields in form

Q: Why, after assigning some of the column class names (column2, column3, column4, col-…) to a group of fields, the next field is displaced to the right?

A: You can fix this behavior by inserting a separator field between rows

Q: How to assign multiple class names to a field?

A: The class names are assigned to the fields through the attribute: “Add Css Layout Keywords”

To assign multiple class names to a field, you must separate them by space characters. For example, myclass1 myclass2

Q: What files can be uploaded through the form?

A: Accepted files

Q: How can I include the links to the uploaded files in the notification emails?

A: Inserting the links to the uploaded files into the notification emails

Q: Why does the form builder display the error message: “The entered data includes invalid characters…”?

A: If you are copying the information used to configure the form from third-party applications (like MS Word or Excel), this information can include non-valid characters. The plugin validates the form’s structure to avoid this type of errors.

Q: How to use conditional statements in the equations?

A: There are different alternatives to use conditional statements in the equations: Visit the following link

Q: How to print the form only and not the complete page?

A: To print only the form, but not the rest of the page’s content, please, follows the instructions in the following link: Click Here

Q: How to disable the dynamic evaluation of the equations associated with the calculated fields?

A: To disable the dynamic evaluation of the equations in the form, you must untick the checkbox “Eval dynamically the equations associated to the calculated fields” from the “Form Settings” tab of the form builder. After disabling the dynamic evaluation of the equations, you must insert a button field with the “calculate” option as its type. The plugin evaluates the equations by pressing the calculate button.

Q: My company has different departments (like the sales department, the support group, etc.). Can I send a notification email to every department when the form is submitted?

A: Yes, that is possible. You must enter the emails’ addresses separated by the comma through the “Destination emails” attribute in the form’s settings.

Q: Why is the user not receiving the confirmation emails?

A: If the users are not receiving the notification emails after the form’s submission, there are different possible reasons: please, read about them here

Q: How to insert line breaks in the notification emails when the HTML format is selected?

A: If you are using the HTML format in the notification emails, you should insert BR tags for the lines changes in the emails’ contents:

<BR />

Q: How to insert an image in the notification emails?

A: Inserting images in the notification emails

Q: How to send only specific fields in the notification emails?

A: The notification emails can include all fields submitted by the form (<%INFO%>), or specific fields by using their tags(<%fieldname#%>). Furthermore, there are other tags you can include in the notification emails.

Please, visit the following link to get the complete list of tags to include in the email: Accepted tags

Q: How to create dependencies between fields in the notification emails and the “Thank You” pages?

A: Please, read the answer in the FAQ page of the plugin: Click Here

Q: How to implement custom operations?

A: Please, read the answer in the FAQ page of the plugin: Click Here

Q: How to calculate the number of words in a text?

A: Calculating the number of words in a text

Q: How to calculate the number of characters in a text, excluding the blank characters?

A: Calculating the number of characters in a text

Q: How to assign a value to a field that is not a calculated field from an equation?

A: Assigning values to the fields from equations

Q: How to insert links in the form?

A: The form builder does not include a specific field for links. However, you can insert a link (or any other HTML tag) using an “HTML Content” field. Insert an “HTML Content” field in the form, and enter the anchor tag as its content. For example, to insert a link to our website:

<a href=”http://cff.dwbooster.com”>Visit the website</a>

Q: How to define dependencies between fields in the form?

A: Please, read the following post in the plugin’s blog: Click Here

Q: How to define dependencies with multiple fields?

A: Create dependencies with values of multiple fields requires the use of calculated fields. Read more

Q: How to prevent users varying the fields’ values to pay less than the calculated price?

A: The form settings include the attribute “Base amount” to define the minimum price allowed. If a user manipulates the calculated field for paying less, the plugin applies the base amount.

Q: How to vary the PayPal product’s name from the public form?

A: You can enter the PayPal product’s name through the “Paypal product name” attribute in the form’s settings. If you enter a field’s tag as the product’s name, for example, <%fiedname1%> the product’s name will be the value submitted by the fieldname1 field.

Q: How to allow to the users to decide the payment frequency for recurring payments?

A: Follows the instructions below:

  1. Inserts a Radio Button or DropDown field in the form.
  2. Enters the number of months as the choices’ values.
  3. Selects the “From field” option in the “Payment Frequency” attribute.
  4. Finally, select the field inserted in the second step from the list beside the “Payment Frequency” attribute.

Tip: The maximum number of moFrequencywed by PayPal for recurring payments is 12 months.

If you allow the users to select the payment frequency, you must implement the equation to vary the amount based on the payment frequency.

Q: How to select a choice in a dropdown field, or radio button, based on a calculated value?

A: I’ll try to describe the process with some hypothetical examples. Assuming the radio button field is fieldname123, and you can select the choice with the value 5, uses the following piece of code as part of the equation associated with the calculated field:

    getField(123).setVal(5);

But if the fieldname123 is a checkbox field and you want to select the choices with values: 5 and 8, the code would be:

    getField(123).setVal([5,8]);

Q: How to set the value of a slider control programmatically?

A: Please, read the answer in the plugin’s documentation:
Click Here

Q: How to use the “DS” fields?

A: Please, visit the following post in our technical blog:
Click Here

Q: In a form with multiple “DS” fields. How to reduce the number of queries to the database?

A: In this case, the recommendation is to use “RecordSet DS” fields as the data source: Click Here for instructions

Q: How to use the data submitted by one form in another one?

A: Please, read the instructions in the plugin’s documentation.
Click Here

Q: How to store the submitted information in another database?

A: Please, read the instructions in the plugin’s documentation.
Click Here

Q: How do I integrate forms with WooCommerce products?

Integrating the forms with WooCommerce products

Q: How to customize the fields displayed on the cart page of WooCommerce?

Customizing the fields in the shopping cart of WooCommerce

Q: Why is a WooCommerce product not displaying the “Add to Cart” button?

A: You must assign a price to the product through its attribute: “Regular Price” or WooCommerce won’t display the “Add to Cart” button.

Q: What is SalesForce, and how to create new leads from my forms?

A: To get a complete guide about the integration of forms created with the plugin and the SalesForce service, please visit the following link:
Click Here

Q: How to copy the uploaded files to DropBox?

A: Activates and configure the DropBox add-on, distributed with the Platinum version of the plugin:
Click Here

Q: How to generate a PDF file dynamically with the submitted information?

A: There are multiple alternatives, by using the PDF generator add-on, the PrintFriendly add-on or the WebMerge add-on.

Q: How to use an “Upload File” field with multiple selections from Zapier?

A: Please, visits the following link to get the answer to your question:
Click Here

Q: How turn off the up/down arrows in the number fields?

A: Please, visits the following link to get the answer to your question:
Click Here

Q: How to protect the form from attacks by spambots?

A: Please, follow the instructions described in the plugin’s FAQ:
Click Here

Q: I have an issue with the character encoding in the exported CSV files?

A: Please, follow the steps below:

  1. Open Excel.
  2. Import the data using Data < Import External Data < Import Data.
  3. Select the file type of “CSV” and browse to your file.
  4. In the import wizard, change the File_Origin to the related language character identifier.
  5. Change the Delimiter to the comma if needed.
  6. Select where to import to and Finish.

Reviews

July 6, 2022
A very good plugin if: - you want to make complex forms; - you have minimal knowledge of HTML, CSS and Javascript; - you are willing to spend more time creating a form. I don't know if there is another plugin like this, it seems to be the only one so it doesn't have much competition.  Being a niche plugin, it's natural that the price is higher compared to other plugins, especially if it solves your problem. If you want simple or even complex forms but don't require special calculation formulas or the application of a particular algorithm, then there are other plugins that are easier to use and more efficient in terms of time to make a form. If not, this plugin is the best and only alternative at the moment, even if it is not very user friendly and has a few minuses.
June 30, 2022
The plugin is excellent and has become a crucial part of my business. Nevertheless, this is not the most important. It is the EXTRAORDINARY support we receive. Always available, always clear, always explanatory. I have never seen anything similar in my career. Thanks, Mike!
Read all 803 reviews

Contributors & Developers

“Calculated Fields Form” is open source software. The following people have contributed to this plugin.

Contributors

“Calculated Fields Form” has been translated into 6 locales. Thank you to the translators for their contributions.

Translate “Calculated Fields Form” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.1.95

  • Fixes an issue with InnoDB tables whose ROW_FORMAT=COMPACT.
  • Modifies the submissions data sources to allow accessing the unpaid submissions only (Developer and Platinum versions).

1.1.94

  • Fixes a minor issue in the checkbox control.
  • Modifies the MONTH, DAY, and WEEKDAY to accept an additional parameter for leading zeros.
  • Modifies the CSS rules to hide empty validation messages.

1.1.93

  • Modifies the summary control.
  • Modifies the container fields for accepting 12 columns.
  • Modifies the Autocomplete Places add-on (Platinum version).

1.1.92

  • Fixes an issue in the summary field that allowed evaluating scripts.
  • Fixes an issue by reordering fields into DIV and Fieldset controls.
  • Modifies the payment gateways add-ons (Platinum version).

1.1.91

  • Modifies the date/time control to allow defining custom error messages.
  • Fixes an issue in the Date/Time DS field when it receives dates in text format (Developer and Platinum versions).

1.1.90

  • Improves the form creation making the controls draggable.
  • Modifies the fieldset control to allow emulating an accordion control.
  • Modifies the email control.
  • Improves the integration with the CFF Rich Text Editor and CP Blocks plugins.

1.1.89

  • Modifies numeric fields. When Digits format is selected, the field does not accept other symbols to be typed by the user.
  • Includes a new button in the form builder to list the form fields, their labels and whether they are excluded from submission or not.
  • Modifies the DataTable DS field to trigger the custom event cff-datatatable-click with the corresponding record index as parameter (Platinum and Developer versions).
  • Modify the Verification Code add-on to allow to include the email address where the notification email was sent in the popup label (Platinum and Developer versions).
  • Modify the CSV Generator add-on to allow configuring the add-on to write the entry in the CSV file only after payment confirmation (Platinum version).

1.1.88

  • Modifies the method of loading the admin resources to fix a conflict with third-party website builders.
  • Modifies the Stripe add-on (Platinum version).

1.1.87

  • Improves the plugin behavior by escaping all field attributes.
  • Solves a warning in the CFF WooCommerce add-on (Developer and Platinum versions).
  • Fixes a conflict in the CFF – Analytics add-on (Platinum version).

1.1.86

  • Modifies the template 14.
  • Modifies the PayPal integration (Professional, Developer, and Platinum versions).