Calculated Fields Form

0

Absolutely! The “Calculated Fields Form” plugin opens up a world of possibilities. Here’s a breakdown of what you can achieve: Financial Calculations: Design forms that automatica

Version
Last updated
Active installations
WordPress Version
Tested up to
pa_languages
Rating
Total ratings
Tags

Description

Absolutely! The “Calculated Fields Form” plugin opens up a world of possibilities. Here’s a breakdown of what you can achieve:

Financial Calculations: Design forms that automatically compute totals, taxes, discounts, and other financial metrics.

Booking Forms: Seamlessly handle date operations, availability checks, and booking calculations.

Product Pricing: Dynamically calculate product prices based on user inputs or predefined rules.

Math Operations: Perform basic arithmetic, percentages, and complex mathematical functions.

Text Processing: Manipulate text fields, concatenate strings, and format data.

Date Operations: Handle date differences, age calculations, and time-related tasks.

Advanced Operations:

Distance Calculations: Compute distances between locations.

Chart Generation: Create charts dynamically based on form data.

Third-Party Service Integration: Call external APIs or services for real-time data retrieval.

And the best part? All resulting forms are mobile responsive, ensuring a seamless experience across devices.

The most remarkable aspect is that you don’t need to hire a developer to create forms. With basic knowledge, you can have professional forms in minutes.

The form builder is entirely visual, offering a wide selection of controls (Text fields, Numbers, Currency, Date/time, Slider control, Email, Radio buttons, Checkboxes, Container fields, Multi-page control, QR code reader, Recording, Calculated fields, and many others). This versatile toolkit empowers you to create customized forms effortlessly.

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.

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.

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.

Extending features add-ons

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

Payment Gateways add-ons

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

Integration with third-party services add-ons

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

Integration with third-party plugins add-ons

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

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

Conditional rules

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

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

Additional details about the use of dependencies

Predefined values

The predefined values in the fields have two possible uses:

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

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

The “User Instructions” attribute

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

Adding CSS layout keywords

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

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

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

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

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

Customizing the form’s design

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

column2
column3
column4

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

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

Formatting the form (distributing the fields in columns)

Multi-page form

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

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

Hidden calculated fields

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

Equation / Formula format for calculated fields

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

  • With simple mathematical operations:

    fieldname1 + fieldname2
    
    fieldname1 * fieldname2
    
    fieldname1 / fieldname2
    
    fieldname1 - fieldname2
    
    fieldname1 - fieldname2
    
  • With mathematical operations involving multiple fields and grouped fields:

    fieldname1 * (fieldname2 + fieldname3)
    
  • With rounding operations. Round the result to two decimal places:

    PREC(fieldname2 / fieldname3, 2)
    
  • There are infinite number of formulas that can be created using complex structures. For example, the following formula includes conditional statements:

    (function () {
    if (100 < fieldname3) return fieldname1 + fieldname2;
    if (fieldname3 <= 100) return fieldname1 * fieldname2;
    })();
    
  • For complex formulas/equations you must use the function format with return statement to return the result to the calculated field:

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

Operations and operators to use in equations/formulas

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

However, the plugin includes a wide variety of operations and …