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

Feedback and Knowledge Base