Calculated Fields Form

Description

Calculated Fields Form is for visually:

♦ Creating forms with automatically calculated fields
♦ Finance calculators
♦ Quote calculators
♦ Booking cost calculators
♦ Date calculators
♦ Health / fitness calculators
♦ Form builder for adding input fields on the form
♦ Add one or more calculated fields
♦ Predefined forms templates

With the Calculated Fields Form you can create forms with dynamically calculated fields to display the calculated values.

It includes a form builder for adding/editing different field types, including one or more automatically calculated fields based on the data entered in other fields.

Calculated Fields Form can be used for creating both single and complex calculations. For example, general calculators, ideal weight calculators, calorie calculators, calculate quotes for hotel bookings and rent-a-car services, calculate quotes for appointments and services, loan & finance calculators, date calculators like pregnancy calculators, etc…

Features:

  • Visual form builder with multiple fields and form formatting options
  • Any number of calculated fields can be added
  • Easy and visual calculator interface
  • The calculator supports both easy and advanced operations, including ternary operators and common Math functions
  • Supports multiple field types, like drop-down, checkboxes, radio buttons, dates, numbers
  • Accept operations with dates (e.g. days between two dates)
  • Smart automatic number and prices identification into the field values
  • Supports form separators and comments sections to layout the form in a friendlier way
  • Manage multiple calculated forms
  • Practical “clone” button to duplicate a form
  • Five pre-built practical samples included
  • Multi page forms supported
  • Conditional rules supported. Useful for creating wizards
  • Intuitive and interactive form builder interface
  • Predefined forms templates

Latest Features Added

  • Dependent fields: Fields can be shown/hidden based on other checkboxes, radiobuttons or drop-down selections
  • Dependent fields from calculated values: Fields can be shown/hidden based on the value of a calculated field
  • Troubleshooting area to automatically fix conflicts with other scripts in themes or third-party plugins, and also for special characters’ support
  • Multi page calculated forms
  • New validations, field types and features in the form builder
  • Calculated fields can be hidden fields.
  • Includes new controls to create more versatile forms.
  • Allows to create a cache of the JavaScript files to increase the website’s performance.
  • Allows to disable the forms when the website is visited by search engine spiders and crawlers, increasing the website’s speed.

There are five samples already included with the installation:

  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 either “clone” those calculated forms to complete your own form or create a new calculated form from scratch for your application.

You can mix text and numbers into a field. If a field contains a number it will be automatically identified and used for the calculations. In addition to that, the checkboxes, radio buttons and drop-down fields can have separately a visual “text” and a hidden “value” linked to each test: the value will be the one used for the calculation.

The dates are also automatically identified and you can apply operations between them. For example, you can calculate the number of days between two dates with a simple operation like “date2-date1” or add some number of days or weeks to a date. To display the result as a date again you can use the CDate operator included in the calculator. The samples #2 and #4 are practical samples.

The form processing and payment processing aren’t included in this version. There are other versions with form processing included and additional features. See the FAQ for more information.

The plugin has two additional (commercial) versions: Premium and Developer. Each of them has its own features:

Features in the Premium version:

  • All features of the free version of the plugin
  • Submits the form data, and stores the data in the database for future review
  • Allows the sending of notification emails with the data submitted, to the form editor and users
  • Allows to charge the calculated field directly through PayPal
  • Allows the export and import of your forms between different WordPress sites
  • Allows the display of the submitted data in the thanks page
  • Includes a dashboard widget to display the submissions of the last week
  • Allows the storing of forms in the cache to increase the rendering speed

Features in the Developer version:

  • All features of the free and premium version of the plugin
  • Includes new controls that get their information from different datasources (database, CSV file, Post, Taxonomies, and users data)
  • Includes financial operations
  • Includes operations for date times management
  • Includes the “distance” operation, that integrates the plugin with “Google Maps” to get the distance between two addresses
  • Includes a script for saving the submitted data in an external database
  • Includes an add-on to integrate the forms with WooCommerce products (Beta Version).
  • Includes an add-on to integrate the forms with the SalesForce service.
  • Includes an add-on to post the submitted information by the forms to WebHooks URLs, allowing integration of the forms with services like Zapier, or Microsoft Flow. Both services: Zapier and Microsoft Flow, connect services as important and popular as Zoho CRM, Dropbox, Mailchimp, Evernote, Google Drive, Facebook, Twitter, and more than 300 services.
  • Includes an add-on to associate the information submitted with the users on the website.
  • Includes the User Registration Form add-on to register new users in the website with the data collected by the form.
  • Includes an add-on to integrate the forms with Google reCAPTCHA, instead of the captcha distributed with the plugin.

Features in the Platinum version:

  • All features of the free, premium, and developer versions of the plugin.
  • Includes the Google Analytics add-on to generate reports about the usage of forms, to identify the users actions and behaviours.
  • Includes the PayPal Pro add-on to ask for the credit card details of payers and charge it directly into your website without any redirection through the PayPal website.
  • Includes the Upload Files add-on to integrate the uploaded files in the website library, and add new mime types to WordPress.
  • Includes the DropBox Integration add-on to copy or move the uploaded files to a DropBox account.
  • Includes the ip2location add-on to identify the users data from the ip2location databases. Requires PHP 5.3 and over.
  • Includes the “Google Places” add-on that allows integration of the input fields with the Google Places API to autocomplete the addresses entered by the users.
  • Includes the “Signature” add-on to convert some form fields into “Signature” fields, allowing the users to sign with the mouse or directly in touchscreens.
  • Includes the “WebMerge” add-on to integrate the forms with the WebMerge Service, and generate PDF and Office documents at runtime with the information collected by the forms.
  • Includes the “MailChimp” add-on to add new members to the MailChimp Service using the data collected by the form.
  • Includes the “Emma” add-on to add new members to the Emma Service using the data collected by the form.
  • Includes the “MailPoet” add-on to add new subscribers to the MailPoet’s Mailing Lists.
  • Authorize.Net add-on integrates the forms with the Authorize.Net payment gateway.
  • Stripe add-on integrate the forms with the Stripe payment gateway.
  • Skrill Payments Integration provides integration with Skrill Moneybookers payment gateway.
  • TargetPay (iDeal) add-on provides integration with iDeal, the most popular Dutch payment method.
  • Mollie (iDeal) add-on provides integration with iDeal.
  • RedSys / Servired / Sermepa add-on provides a secure interface for accepting credit card payments through most banks in Spain.
  • PayTM add-on provides a secure interface for accepting payments through credit card, debit cards, net banking, wallet and EMI.
  • SagePay add-on provides a secure interface for accepting payments through SagePay.
  • Sage Payment add-on provides a secure interface for accepting payments through a secure SSL checkout system for both bankcard and virtual check transactions.

To find the last updates, and tips about the use of the plugin, please visit our blog, “like” our Facebook page, or follow us on Twitter:

Blog: http://blog.net-factor.com

Facebook: https://www.facebook.com/netfactorsl

Twitter: https://twitter.com/netfactorsl
This section contains mainly notes about the form builder features that are too long to explain in the main description page.

Conditional Rules

The form fields can be shown or hidden depending on the selection made in the checkboxes, radio-buttons, select/drop-down, and calculated fields.

Description about the use of dependencies

Predefined value

The fields can have “predefined” or “prefilled” values. There are two possible uses for this:

1- Can be used for pre-filling the form with common values to save time for the end user.

2- Can be used for showing a sample of the data that should be entered in the field. In this case you may want to also mark the checkbox “Hide predefined value on click”. This way, the value will disappear once the user starts using the field without having to manually delete the placeholder value.

The “Instructions for User” option

Each field has a settings value labelled “Instructions for User”. Use that settings value to give instructions to the end user about filling in that field. The instructions will appear in a smaller text immediately below the field in the public website.

Add Css Layout Keywords

This is also explained in the FAQ. The “Add CSS Layout Keywords” is a way to apply CSS styles separately for each field. This settings field is available for each form builder field in the admin area. Into that field you can put the name of a CSS class that will be applied to the field.

Important: Put only the name of the CSS class into the “Add Css Layout Keywords”; don’t put the CSS styles rules directly there.

There are some pre-defined CSS classes to align two, three or four fields in the same line. The CSS classes are named:

column2
column3
column4

For example, if you want to put two fields into the same line then specify the class name “column2” for both fields. The above is valid for both the classic fields and the calculated fields.

The CSS classes/rules can be placed into the “wp-content\plugins\calculated-fields-form\css\stylepublic.css” file or into your theme’s CSS files.

Multi Page Forms

To add a new page to create multi-page forms, just insert the field named “Page Break”. Each form’s page will be validated separately before going to the next form. However, note that the calculations are applied to the whole form every time a field is modified, so a calculated field in another page may be modified even if that page isn’t visible.

Calculated “hidden” Fields

The calculated fields can be “hidden” fields. This way the calculated values of those “hidden” fields won’t be displayed in the form. This is useful for using intermediate calculated values or for showing the calculated values only in the email (pro version).

Equations / Formulas Format for Calculated Fields

Here are some sample formulas that can be used as a base:

  • With simple mathematical operations:

    fieldname1 + fieldname2
    
    fieldname1 * fieldname2
    
    fieldname1 / fieldname2
    
    fieldname1 - fieldname2
    
  • With multiple fields and fields grouping included:

    fieldname1 * ( fieldname2 + fieldname3 )
    
  • Rounded to two decimal digits:

    prec( fieldname2 / fieldname3 , 2)
    
  • There is a huge number of equations that can’t be recreated with simple mathematical operators, or the operations listed above, and thus requiring “IF” conditions. Here is a sample of the formula that can be used in that case:

    `
    

    (function(){
    if(fieldname3 > 100) return fieldname1+fieldname2;
    if(fieldname3 <= 100) return fieldname1*fieldname2;
    })();
    `

  • For complex equations where it is required to define blocks of JavaScript code, you should use the following format:

        (function(){
            var calculatedValue = 0;
            //Your code here
            return calculatedValue;
    })();
    

…. and note that the return value of that function will be the value assigned to the calculated field.

Functions that can be used for the formulas

In addition to the JavaScript functions, the following functions can be used directly in the formulas:

Description of the basic operations

In addition to the above, the following operations are available in the Developer and Platinum versions of the plugin:

Date Time module

Description of operations in the module Date Time

Financial Module

Description of operations in the financial module

Distance Module

Description of operations in the distance module

Fields available in the Calculated Fields Form’s form builder

To get the complete list of available fields, please visit the following link: CLICK HERE

Create JavaScript variables to be used in the equations, from GET, or POST parameters, SESSION variables, or COOKIES

The icon with the “X” symbol, that appears when editing the contents of pages or posts, inserts a shortcode in the content with the structure:

[CP_CALCULATED_FIELDS_VAR name=”…”]

The … symbol should be replaced by the parameter or variable name, and will be the same name as the JavaScript variable. For example: [CP_CALCULATED_FIELDS_VAR name=”varname”]

CLICK HERE for additional information

Tips for calculating prices

One of the most frequent uses is for calculating prices. When displaying prices of a good you may want to divide the form into two pages: the first one to ask for the information needed to calculate the price, and then on the second page you can display the calculated field with the price, and use the “Instruct. Text” fields for adding the terms, conditions and valid time for the price.

Note that you can make the “Instruct. Text” fields dependent on the calculated value. That way, you can change the text shown to the user depending on the number shown in the calculated price, since frequently the terms, conditions or offers vary according to the price amount.

Add-Ons – Only available in the Developer and Platinum versions of the plugin

The list of add-ons available in the plugin appear in the “Add-ons area” of the settings page of the plugin. To enable the add-ons, simply should tick the corresponding checkboxes, and press the “Activate/Deactivate Addons” button.

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

The developer and platinum versions of the plugin include the WooCommerce add-on, to integrate the forms created by the “Calculated Fields Form” with the WooCommerce products.

CLICK HERE for additional information

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

The add-on allows you to create new leads in the SalesForce account with the data submitted by the forms.

CLICK HERE for additional information

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

The add-on allows posting the submitted information by the forms to WebHook URLs. With the WebHook add-on it is possible to integrate the forms created by the plugin with services like Zapier, Microsoft Flow, or IFTTT (among others). Services like Zapier, Microsoft Flow and IFTTT connect services as important and popular as 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

Users Permissions add-on – Only available in the Developer and Platinum versions of the plugin

The add-on allows you to associate the submitted information with the users on the website. Furthermore, the plugin allows the defining of rules to restrict the access to the forms to only registered users, specific roles, or specific users. The add-on adds a new shortcode to the plugin for listing the information submitted by the user (it is possible to insert the new shortcode in the user profile), and assign permissions to the users for editing the submitted information, or deleting an entry. With the add-on it is possible to limit the number of submissions to only one by form and user.

CLICK HERE for additional information

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

The add-on allows to register new website users with the information collected by the form, and even populate metadata required by other plugins.

CLICK HERE for additional information

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

The add-on allows you to protect the forms using Google reCAPTCHA instead of the captcha distributed with the plugin. reCAPTCHA is more visual and intuitive than the traditional captcha.

CLICK HERE for additional information

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

The “Google Analytics” add-on allows you to generate usage reports in “Google Analytics” about the interactions of users with the form.

CLICK HERE for additional information

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

With PayPal Pro the form can ask for the credit card details and charge it directly into your website without any redirection through the PayPal website. Once the user has completed the form fields and clicks the submit button the payment is processed and the posted data (excluding the credit card related information) are saved into the WordPress database.

CLICK HERE for additional information

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

The “Upload Files” add-on allows the files uploaded through the forms to be added to the Media Library, and then accessed from the pages and posts of the website.

Furthermore, it allows to include the support of new MIME types, rather than the files format supported by default by WordPress.

CLICK HERE for additional information

Dropbox Integration add-on – Only available in the Platinum version of the plugin

The “Dropbox Integration” add-on allows to copy or move the files uploaded through the forms to a Dropbox account.

CLICK HERE for additional information

ip2location add-on – Only available in the Platinum version of the plugin

The add-on integrates the Calculated Fields Form with the ip2location databases to identify additional information from users based on their IP, such as: Country, City Name, Coordinates, Weather Station, Time Zone, ZIP Code, etc…

CLICK HERE for additional information

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

The “Google Places” add-on allows you to integrate the input fields with the Google Places API to autocomplete the addresses entered by the users.

CLICK HERE for additional information

Signature add-on – Only available in the Platinum version of the plugin

The “Signature” add-on converts the selected fields in “Signature” fields, allowing the users to sign with the mouse or directly in touchscreens.

CLICK HERE for additional information

WebMerge add-on – Only available in the Platinum version of the plugin

The “WebMerge” add-on integrates the forms with the WebMerge Service, and generates PDF and Office documents at runtime with the information collected by the forms.

CLICK HERE for additional information

The “WebMerge” add-on may be used to integrate the form with the Silverpop service (today IBM Watson Campaign Automation) CLICK HERE for additional information

MailChimp add-on – Only available in the Platinum version of the plugin

Includes the “MailChimp” add-on to integrate the forms with the MailChimp Service to add new members to the lists.

CLICK HERE for additional information

Emma add-on – Only available in the Platinum version of the plugin

Includes the “Emma” add-on to integrate the forms with the Emma Service to add new members to the Emma groups.

CLICK HERE for additional information

MailPoet add-on – Only available in the Platinum version of the plugin

Includes the “MailPoet” add-on to add new subscribers to the MailPoet’s Mailing Lists.

CLICK HERE for additional information

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

The Authorize.net Server 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 – Only available in the Platinum version of the plugin

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

CLICK HERE for additional information

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

The Skrill Payments add-on provides a secure interface for accepting payments through a secure page. 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 – Only available in the Platinum version of the plugin

The TargetPay add-on provides integration 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 – Only available in the Platinum version of the plugin

The Mollie add-on provides integration with iDeal, the most popular Dutch payment method.

CLICK HERE for additional information

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

The RedSys / Servired / Sermepa add-on provides 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 – Only available in the Platinum version of the plugin

The PayTM add-on provides a secure interface for accepting payments through credit card, debit cards, net banking, wallet and EMI. With over 100mn Paytm users in India, your customers will love the option to pay with their trusted Paytm Wallet.

CLICK HERE for additional information

SagePay add-on – Only available in the Platinum version of the plugin

The SagePay add-on provides a secure interface for accepting payments through SagePay.

CLICK HERE for additional information

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

The Sage Payments addon provides a secure interface for accepting payments through a secure SSL checkout system for both bankcard and virtual check transactions. All authorised and approved transactions will be delivered into your current bankcard and/or virtual check batches viewable within the Virtual Terminal for order processing and settlement.

CLICK HERE for additional information

Screenshots

  • Calculated forms list
  • Inserting a calculated form into a page
  • Sample calculated form
  • Calculated field settings
  • 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

Installation

To install a Calculated Fields Form, follow these steps:

  1. Download and unzip the Calculated Fields Form plugin
  2. Upload the entire /calculated-fields-form/ directory to the /wp-content/plugins/ directory
  3. Activate the Calculated Fields Form plugin through the Plugins menu in WordPress
  4. Configure the settings at the administration menu >> Settings >> Calculated Fields Form
  5. To insert the calculated / contact form into some content or post use the icon that appears when editing content

FAQ

Installation Instructions

To install a Calculated Fields Form, follow these steps:

  1. Download and unzip the Calculated Fields Form plugin
  2. Upload the entire /calculated-fields-form/ directory to the /wp-content/plugins/ directory
  3. Activate the Calculated Fields Form plugin through the Plugins menu in WordPress
  4. Configure the settings at the administration menu >> Settings >> Calculated Fields Form
  5. To insert the calculated / contact form into some content or post use the icon that appears when editing content
Q: Is the “Calculated Fields Form” plugin compatible with “Autoptimise”?

A: Yes, both plugins are compatible…

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

A: Yes, both plugins are compatible…

Q: What does each field in the Calculated Fields Form settings area mean?

A: The Calculated Fields Form’s page contains detailed information about each field and customisation:

http://cff.dwbooster.com/

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 template. Other versions of the plugin also allow publishing the forms as a widget.

Q: Is form processing an option, for example, to email the form data and calculated results?

A: Form processing isn’t available in the version listed in this directory. There are other versions with form processing, email notifications and payment processing. You can check the other versions at http://cff.dwbooster.com/

Q: Which calculation operations are included?

A: Mathematical operations, logical operands and more

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

A: Uses the “PREC” operation, described here

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 to calculate an amortisation?

A: CALCULATEAMORTIZATION is the operation with the most complexity in the “Calculated Fields Form” and requires its own section. Please visit the following link to read a detailed description about the use of the CALCULATEAMORTIZATION operation:

How to calculate an amortisation?

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

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

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

A: Visit the following link for instructions

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 can I access, from the equations in the form, the value of the variable defined in its shortcode?

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

Q: How can I define an initial date in a date field?

A: Initialising date/time fields

Q: How can I change the language on the datepicker?

A: To use a different language on datepickers you will need to create an additional file and touch some code. Please visit the following link to read the instructions:

How to change the language on datepicker?

Q: How to create relationships between date fields?

A: It is possible to define the min date, max date, or select a date dynamically in a date field, depending on the date selected in 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: Formatting a form with a table structure

Q: How can I convert a common button into a submit button?

A: To convert a common button into a submit button, simply assign, as part of the onclick event, the snippet of code:

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

Note: this option is only compatible with the pro and developer versions of the plugin

Q: How can I 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, and use only the images for choices selection, open the “/wp-content/plugins/calculated-fields-form/css/stylepublic.css” file in the text editor of your choice, and paste the following styles definition at the end of the file’s content:

fbuilder input[type=”checkbox”]{display:none !important;}
Q: How to replace the image displayed in a Media Field, in a function of choice selected in a radio buttons field?

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

Q: In which order are the fields “calculated”?

A: Evaluating the equations

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

A: That feature is available in the Pro version that can be acquired here: http://cff.dwbooster.com/

Visit the following link to our technical blog with a detailed description about the integration of PayPal and the forms created with CFF:
Calculated Fields Form and PayPal

Q: Non-latin characters aren’t being displayed in the calculator form. Is there a workaround?

A: Solution Here

Q: The calculated form doesn’t appear in the public website. Is there a solution?

A: In the “troubleshoot area” (located below the list of forms in the settings area) change the “Script load method” from “Classic” to “Direct”.

Q: How to create multi-page forms?

A: Use the “Page Break” field in the form builder to indicate the new pages in the form.

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

A: Displaying selected values in the slider control

Q: How to create new validation rules?

A: Create new validation rules

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

A: Insert a summary control and select the fields to be displayed in the summary.

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

A: Highlighting fields

Q: Can a summary of submitted fields be displayed in the Thank You page?

A: Displaying a summary in the Thank you page

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

A: Applying CSS styles to the form fields

Tips and Tricks: Using auxiliary fields

Q: Is it possible to modify any of the predefined templates included with the plugin?

A: Modifying the predefined templates

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

A: Creating new templates

Q: How to hide fields on the forms?

A: Hiding the fields in a form

Q: Why after assigning some of the class names (e.g. column2, column3, or column4) to a group of fields, is the field that follows the group displayed displaced to the right?

A: Inserting a separator field between rows

Q: How to create a form with a table structure, when the fields are displayed dynamically using dependencies?

A: Table structure with dependent fields

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”. If you need to assign multiple class names to a field, you only should enter the class names separated by space characters. For example: myclass1 myclass2

Q: What files can be uploaded through the form?

A: What files can be uploaded through the form?

Q: How can I include a link to the uploaded file in the email message?

A: Inserting links into the uploaded files

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

A: Sometimes, users copy the text for the field labels and descriptions from a different platform, for example, Excel or MS Word, but the text copied can include invalid characters. The plugin validates the form’s structure to avoid this type of error.

Q: How to use conditional statements in the equations?

A: There are three ways to use conditional statements in the equations:

Visit the following link

Q: How can the form only be printed, and not the complete page?

A: To print only the form, but not the rest of the page, please follow the instructions in the following link:

Visit the following link to the documentation page

Q: How can I disable the dynamic evaluation of the equations, when the fields values vary?

A: To disable the dynamic evaluation of the equations in the form, you should only uncheck the option: “Eval dynamically the equations associated to the calculated fields”, from the “Form Settings” tab, of the form builder. But, a button should be inserted with “calculate” type, to evaluate the equations by the direct action of users.

Q: I’ve implemented complex equations, but they are not working. What can I do?

A: The plugin tries to optimise the equations to improve the form’s performance and reduce the sequence of equations, but if the equations are not working, I suggest to select any of the calculated fields in the form, and untick the option: “Optimise Form Equations”. If the previous step is not sufficient, be sure the equation has been implemented correctly: Click Here

Q: My company has different departments (e.g. the sales department, and the support group). Could you send a notification email to a representative of each department when the form is submitted?

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

Q: Why are the users not receiving the notification emails if the option to send a copy to the user and the email field have been selected from the form’s settings?

A: If the users are not receiving the notification emails with the submission data, there are different reasons for this:

Visit the following link

Q: How to insert changes of lines 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 the BR tags for the changing of lines in the email content:

<BR />

Q: How can I insert an image in the notification emails?

A: Inserting images in the notification emails

Q: How can I send specific fields in the notification emails, and not all the form fields?

A: The notification emails can include all fields submitted by the form (<%INFO%>) or specific files (<%fieldname#%>), or furthermore, some other special tags. Please visit the following link to get the complete list of tags to include in the email:

Visit the following link with all available options

Q: How to create dependencies between fields in the notification emails, and the Thank You page?

A: Visit the following link

Q: How can I include my own JavaScript files to implement my own operations?

A: Visit the following link

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

A: Calculating the number of words in a text

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

A: Calculating the number of characters in a text

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

A: To enter a value programmatically into a field, that is not a calculated field, will require you to assign custom class names to the fields, and edit any of the equations in your form. Please visit the following link:

Assigning values to fields from equations

Q: How to insert a link in the form?

A: The latest version of the plugin includes the “HTML Content” field to insert HTML tags directly into it. Simply insert an “HTML Content” field in the form, and then enter the tag of the link in the content’s attributes. For example, to insert a link to our website, you should enter the following tag:

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

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

A: Visit the following link for a tutorial about the use of dependencies between fields in the form,

Click Here

Q: How to create dependencies with multiple fields?

A: To create dependencies that depend on the values of multiple fields, it will be necessary to validate the dependencies rules, and display or hide the fields through an equation. Please visit the following link:

Defining dependencies

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

A: The form settings include the attribute “Base amount” to define the minimum price allowed. So, if a user manipulates the calculated field to pay less, the number entered in the “Base amount” attribute will be applied.

Q: How to use the value of a field in the form as the name of the product submitted to PayPal?

A: Through the “PayPal product name” attribute in the form’s settings, the name of the product to be submitted to PayPal is defined. It is possible to use a fixed text, or the value of a field in the form (for example, suppose that you have a DropDown field, or radio buttons field, to select the product’s name), each field has a name associated with the format: fieldname#. For example, to use the value of the fieldname1 field as the product’s name, the text <%fiedname1%> should be entered in the “PayPal product name” attribute.

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

A: Please read the instructions in our technical blog.
Click Here

Q: How to select a choice in a DropDown field, or Radio Button, based on the calculated value?

A: Please read the answer in our technical blog:
Click Here

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 URL parameters for filtering the data on “DS” controls?

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

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

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

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

A: Please read the instructions on our technical blog.
Click Here

Q: How to store the data sent in a different database?

A: Please read the instructions on our technical blog.
Click Here

Q: How do I integrate forms with WooCommerce products?

Integrating the forms with WooCommerce products

Q: How to customise the fields displayed in the cart page of WooCommerce?

Customising the fields in the shopping cart of WooCommerce

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

A: If you have created the form correctly, and associated it with the product, even if you have configured the product to calculate the price with the form, you will need to assign a price to the product through the attribute “Regular Price”, or WooCommerce won’t display the “Add to Cart” button.

Q: What is SalesForce, and how can I 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 can I export the submitted files to DropBox?

A: Please visit the following link to get a tutorial to integrate the form with the Dropbox service:
Click Here

Q: How can I generate a PDF file with the submitted information, and send it as an attachment to the user?

A: Please visit the following link to get a tutorial:
Click Here

Q: How can I use a file field with multiple selection from Zapier?

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

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

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

Q: How to protect the form against spam bot attacks?

A: Please, visit the following entry in the FAQ page of the plugin for the instructions to protect the form:
Click Here

Q: I’ve an issue with the character encoding in the exported CSV/Excel files?

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

Reviews

Great

Works great! It’s kind of confusing at first, but it works amazingly once you understand it.

Great Plugin, so many possible uses

I used this plugin to create a Size calculator for my website. Using their height and weight, people can see which size fits them best. This significantly raised my conversion rate!

GREAT PLUGIN !

USEFUL FOR :
– COMMON JOBS WITH “FIELDS” THAT MUST BE CALCULATED IN VARIOUS WAYS,
– COMPLEX PROBLEMS THAT INVOLVE MANIPULATING DATA IN PROGRAMABLE MODULES,
– AND THE LAST, BUT NOT THE LEAST – 10 STARS FOR SUPPORT. ASK FOR @codepeople

Read all 258 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 3 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.0.189

  • Allows to start the phone fields with the plus symbol (+) for international numbers.
  • Fixes some notices.
  • Reduces the number of database queries.
  • Optimizes the plugin’s code.

1.0.188

  • Fixes an issue with the forms’ preview in some WordPress configurations.
  • The free version of the plugin solves a conflict with Varnish.
  • The Developer and Platinum versions fixes some issues with external datasources.

1.0.187

  • Fixes an issue formatting dynamically the values on number and currency fields.
  • Modifies the server side scripts that generate the client side scripts to prevent issues with notices and warnings not related with our plugin.
  • Modifies the WebHook add-on (for the Developer and Platinum versions of the plugin) to allow decide if sending the data to the webhook before or after receive the payments confirmations.
  • Modifies the WooCommerce add-on (for the Developer and Platinum versions of the plugin) to allow define the selector of the price’s tag in the products pages to update the visual price at runtime.

1.0.186

  • Fixes an issue with the message after cloning a form.

1.0.185

  • Fixes an issue with the access to the external links in the submenu of the plugin.

1.0.184

  • Reduces the number of queries to database.
  • For the Professional version of the plugin, modifies the module to export the forms.
  • For the Developer version of the plugin, modifies the “DS” set of fields, and improves the security of database accesses.
  • For the Platinum version of the plugin, fixes a notice in the MailChimp add-on.

1.0.183

  • Modifies the database’s structure to prevent issues with a wrong character set in the columns.

1.0.182

  • Improves the access to the plugin’s options.
  • Fixes an issue in the CPCFF_FORM class.
  • In the Professional version modifies the module that generates the content of the notification emails and thank you pages, including the special tags: to display the id of subscription for recurrent payments, and the to include only the coupon’s code without the discount message.
  • In the Developer version fixes an issue in the WooCommerce add-on for displaying the summary of collected data in the shopping cart page and the orders.
  • In the Platinum version fixes some issues in the payment gateway add-ons.

1.0.181

  • Fixes the URLs to the demo, help, and upgrade pages.
  • Modifies the module for the forms preview.

1.0.180

  • Reduces the number of database queries.
  • Adds new validation rules in the data received, increasing the security.
  • Improves the performance and the plugin’s code.