Math Formula Field - For Simple Mathematical Calculations

In this guide, we will explain how to use the Math Formula field on your Formyoula mobile forms.

The Formula field functionality is only available in the latest mobile application version 178. Please make sure to update your Formyoula iOS or Android app - http://support.formyoula.com/knowledgebase/articles/350088-where-to-find-the-formyoula-mobile-applications

Current Math Formula field version does not support Repeat group summary or totals.

The Math Formula field supports simple mathematical formulas for addition, subtraction, multiplication and division. Use field labels as merge values to build your expressions. We recommend using number and currency field types.

1.  Please drag & drop below form fields that will be used for the formula example. You can use Text, Number, Currency and Select fields.

Please note that you must use fields that contain number values only. Each field must contain a value for the formula to calculate the result, please use “0” values instead of leaving the fields blank.

2. Next please drag & drop the Math Formula field from the “Input” section.

3. Click on the “pencil” icon to edit the Math Formula field.

MathPNG

4. Please use simple math equations under the “Math Formula Expression” textarea. To merge your form fields into the expression please use the form field labels surrounded by double curly braces. In this example we will multiply the “Select” field value with the “Number” field value then we will add the “Text” field value and will subtract it with the “Currency” field value.

You can use any number of form fields with any simple math equations.

  • {{Field Label}} * {{Field Label}} + {{Field Label}} - {{Field Label}}

  • {{Select List}} * {{Number}} + {{Text}} - {{Currency Field}}

5. When all equation fields are captured the Math Formula Field summary will be displayed the result in a read-only number. Formula fields can be mapped to Salesforce fields to record the calculated values on your Salesforce records.


If you have any questions, please contact support@formyoula.com


Getting Started

  1. Create a Salesforce Form
  2. Purchasing Formyoula Licences
  3. Convert Salesforce objects to Formyoula forms
  4. Adding Users And Form Sharing
  5. Exporting All Form Entries To Excel
  6. Form Sharing
  7. Conditional Fields
  8. Sign In To Formyoula Mobile With Partner and Communities Users
  9. Enable Salesforce Object Access for Chatter Free Users and Other Salesforce Users With Limited or No Access to Objects
  10. Create custom branded PDFs using the Formyoula PDF Editor
  11. Import Users From a CSV File
  12. Download Captured Form Entries as a CSV File
  13. Export Your Formyoula Forms From Your Sandbox and Import Them Into Your Salesforce Production Environment
  14. Create a Custom User Login Email Template for Your New Users
  15. The Difference Between Salesforce and Formyoula User Types
  16. Math Formula Field - For Simple Mathematical Calculations
  17. Custom Navigation Buttons
  18. Create Forms and Capture Form Entries in Any Language
  19. Formyoula Features
  20. How To Skip Form Pages Using Formyoula Custom Navigation?
  21. Change Salesforce Integration User By Changing Form Ownership
  22. Delete Users
  23. Restrict The Formyoula Users Page to Admin Users Only
  24. Assign Admin Privileges to Formyoula Users
  25. Edit Form Entries Directly From Your Dashboard To Resubmit Them
  26. Display Repeat Group Entries In Custom PDF Template Using Merge Fields
  27. Define dependencies between fields (e.g., dependent picklists)
  28. Formyoula Github Integration
  29. PDF Upload Form Element Guide
  30. How to Edit user Details and add Custom Attributes
  31. Installing Formyoula Mobile Web App on Windows and Mac desktop

Feedback and Knowledge Base