Troubleshooting Forminator Number and Currency Field Issues in Email Notifications
Content
Many Forminator Forms users rely on number and currency fields to collect critical data like budgets, donations, and financial quotes. A common and frustrating issue occurs when these values appear correctly in form submissions but are truncated, rounded, or incorrectly formatted in email notifications. This guide will explain why this happens and provide the most effective solutions.
Understanding the Problem
Based on community reports, the problem typically manifests in one of two ways:
- Truncated Numbers: A value like '5,000' in a number field appears in the email as just '5'. This seems to occur because the email system may misinterpret the comma as a thousands separator and only process the digits before it.
- Incorrect Currency Rounding/Formatting: A currency value like '188.737,00' is displayed in the backend correctly but appears in an email as a rounded figure like '188,74'. This is often related to how the system processes and formats decimal places for display.
Most Common Solutions
Solution 1: Use Individual Field Merge Tags (Recommended)
The most reliable fix for this issue is to avoid using the {all_fields} merge tag in your email notifications. Instead, construct your email message using individual field merge tags (e.g., {number-1}, {currency-1}).
- Edit your form's notification settings.
- In the email message body, replace
{all_fields}or{all_non_empty_fields}. - Manually type out your message and insert the specific merge tags for each field you need. For example:
Donation Amount: {currency-1} Project Budget: {number-2}
This method gives you precise control over how the data is presented and bypasses the formatting issues associated with the automated {all_fields} tag.
Solution 2: Ensure Consistent Formatting Settings
For currency fields, inconsistencies between the field's formatting settings and how the email handles them can cause problems.
- Edit your currency field.
- Navigate to the Formatting settings.
- Ensure your chosen format (e.g., '123,456.00' vs. '123.456,00') is set correctly for your region.
- Save the field and test the form again.
Solution 3: Investigate Conflicting Code
If the issue started suddenly without any changes to your form, a theme or plugin update might be the culprit. A common troubleshooting step is to:
- Temporarily switch to a default WordPress theme (like Twenty Twenty-Four).
- Deactivate all plugins except Forminator.
- If the issue is resolved, reactivate your plugins one by one to identify the conflict.
Solution 4: Use Ajax Form Submission
While not a direct fix for email formatting, enabling Ajax submission is a best practice that prevents users from losing all their entered data if another field (like a file upload) causes an error. This improves the user experience overall.
- Edit your form.
- Go to the Behavior tab.
- Find the Enable AJAX option and toggle it on.
- Save your form.
When to Provide More Information
If the solutions above do not resolve the issue, the problem might be specific to your form's configuration. To get further help from the community, you may be asked to provide:
- Form Export: An exported copy of your form's JSON configuration.
- Currency Type: Specify which currency you are using (e.g., USD, GBP, BRL).
- Specific Steps: A clear list of steps to reproduce the issue on a fresh installation.
You can export your form by navigating to Forminator > Forms, clicking the gear icon next to your form, and selecting Export. The contents can be shared using a service like Pastebin.
By following these steps, you should be able to resolve most common issues with number and currency values in Forminator email notifications.
Related Support Threads Support
-
Set form number to be min/max equal valuehttps://wordpress.org/support/topic/set-form-number-min-max-value-same/
-
forminator number field incrementhttps://wordpress.org/support/topic/forminator-number-field-increment/
-
Information boxhttps://wordpress.org/support/topic/information-box/
-
Currency value without decimals in emailhttps://wordpress.org/support/topic/currency-value-without-decimals-in-email/
-
Currency Fields – Formatting not workinghttps://wordpress.org/support/topic/currency-fields-formatting-not-working/
-
Thousands separatorhttps://wordpress.org/support/topic/thousands-separator-9/
-
If attached file is larger than the field limit, other field are losthttps://wordpress.org/support/topic/if-attached-file-is-larger-than-the-field-limit-other-field-are-lost/
-
Truncated numeric values in submission confirmationshttps://wordpress.org/support/topic/truncated-numeric-values-in-submission-confirmations/
-
Form “Number” fields are recently being clipped in emailhttps://wordpress.org/support/topic/form-number-fields-are-recently-being-clipped-in-email/
-
Condition check failshttps://wordpress.org/support/topic/condition-check-fails/
-
Incorrect Currency Format in Email Notificationshttps://wordpress.org/support/topic/incorrect-currency-format-in-email-notifications/
-
Regex method (Important)https://wordpress.org/support/topic/regex-method-important/
-
Remove field number in Emailhttps://wordpress.org/support/topic/remove-field-number-in-email/
-
currency field isuehttps://wordpress.org/support/topic/currency-field-isue/
-
Minimum number of charactershttps://wordpress.org/support/topic/minimum-number-of-characters-2/