Articles on: Working with OpnForm

How to Enable Calculated Values and Answer Piping in Forms?

How to Enable Calculated Values and Answer Piping


Calculated values and answer piping let you create dynamic variables using formulas and reuse them in integrations like email notifications.


Steps


  1. Go to the form edit page.
  2. Click Settings, then go to Variables.







  1. Click Add Variable.
  2. Enter a variable name and define your formula.
  3. In the formula editor:
  • Click @ to insert a form field value.
  • Select the field you want to use.
  • Click fx to add or edit functions and logic.




  1. Click Create Variable to save.


Using the Variable


  • Go to your integration (e.g. Email Notification).
  • In the email body, click @ to insert variables.
  • Select the calculated variable you created.
  • The computed result will be sent automatically in the email or other integrations.







🧠 Example Formulas for Calculated Values



  1. Quiz Scoring (Correct Answer Check)

IF(@FieldName = "Correct Answer", 1, 0)


  1. Total Score (Multiple Fields)

IF(@Field1 = "Correct", 1, 0) + IF(@Field2 = "Correct", 1, 0)


  1. Price Calculation (Quantity × Price)

@Price * @Quantity


  1. Discounted Price

@Price - (@Price * @Discount / 100)


  1. Full Name (Answer Piping / Text Combination)

@FirstName + " " + @LastName



How do I enable and customize the email sent as a submission confirmation?

https://help.opnform.com/en/article/how-do-i-enable-and-customize-the-email-sent-as-a-submission-confirmation-1339dk8/

Updated on: 08/06/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!